here's the scenario. There's 2 types of employees; Worker and Manager. The worker will have to access the page 'worker.aspx' and the Manager will have to access the page 'manager.aspx'. In my login database (Access 2007) I have the first name, last name, username, password and job title of both workers and managers. Ex:
[Code]...
I'm working with a database application and i want to check if there is a null value in a specific column but it works only when its not null but if its null it throws an exception automatically. I tried to change the null value property of this column but I'm not able it shows a message that its not a valid property. I tried to change the source code in the code editor but it changes back automatically. Is there a way that I can work around this?
View 5 RepliesI would like to bind different queries for a long set of columns in datagridview that has been set already during the formload, e.g:
With dgvGrid
.Columns(0).Name = "Dept Code"
.Columns(1).Name = "Emp ID"[code]....
there are still more of it. The data needed for those columns is coming from a different table.
I am reading data from the database with SQLCommand object SQLReader, all I want to know is I want to read a specific row from my column myData...e.g.I want to read row 11 or random row from mycolumn, what is the correct syntax I am reading all the data(rows) from mycolumn with the command
"SELECT mycolumn from Table1"
what is the syntax to read the 11 or any row of this column?
I have a gridview loaded with data from my database and a gridview swapping function which after exchanging data between rows with a column call "Priority", I want to save these changes back to my database. Only the "Priority" column value will be change, how do I update only that Column of my dataset table to my SQL database?
[Code]....
I have a program and I get time data from a sqldb and display it in a column in a listbox. What are the proper steps for adding the time as I iterate through the data in the column? I figure I will need to do some conversions on the time to be able to add it and display it as a total.
View 9 RepliesI was wondering if it was possible to check if the file "test.txt" is open? and if so then display a message that the file is in use? My biggest problem is that the file can be opened in notepad, word, excel etc. I have some basic coding, which checks if the file is open - what I am trying to do is check if the file is currently open and if its not in use then proceed with the coding, I have the following coding so far.
Dim Process() As Process = System.Diagnostics.Process.GetProcessesByName("notepad")
Dim Process2() As Process = System.Diagnostics.Process.GetProcessesByName("word")
For Each p As Process In Process
[Code].....
how do i check if a mouse was clicked in a specific coordinate plane on the form"?
View 2 RepliesI have a working login script. It connects to my database but i need to have it search the column status to see if the user loging in is either admin user or mod. and so far i can't get anything to work.Here is my code i have for it checking the column
Code:If sqlquery = "Select * FROM userlist WHERE status = 'admin'" Then Form2.Show() Else Form1.Show() End If
[code]....
Basically what I want to do is create a program that every now and then (maybe 10 minutes) switches between either, all the windows currently open, or a selection of all the windows currently open, then checks the colour of a location on the screen. At the moment I have the program checking the colour at a specific coordinate, so that's all good. The problem I have now is how to switch between windows.
I've thought up a few ways to do this. The windows that I care about checking all have the same name, the same process class, but different process IDs. I already managed to stick all the process IDs into an array of integers hoping that I could use them but I don't have a clue how to bring a window to front using just the process ID. So the first method would work if I could figure out a way to do that.
My second idea, which is a pretty rubbish way of doing it, would be to simply simulate pressing Alt+Tab however many times to change between windows.
Is there a way to alter a specific row to a column?
Like i want to alter a row but not the whole thing only one column?
deducting from customers purchases. The fields look like this:
tblStocks:
Name Type Qty
Pencil 2 15
[code].....
I have following query,
[Code]....
how to do it in linq queries ??? also is it possible to combine firstName and lastname in select query in Linq ? just like we do in SQL Queries like : select me_first_name + ' ' + me_last_name as 'Full Name' from me_employee how can i achieve this task in linq?
Iv've always done a loop like below to go through each row of my DataGridView..For Each row As DataGridViewRow In DataGridView1.Rows....Is there a way to specif a specific row and column that i want to get data from? I tried this below but didnt work
MessageBox.Show(dataGridView1.Rows[1].Cells[0].value)
and
MessageBox.Show(dataGridView1[0, 1].Value)
I have a DataGridView binded to a DataSet that I created using the Visual Studio Data Source Configuration Wizard. Everything works good except for one problem.I have two columns, Modified_By and Date_Modified that should be inserted or updated as the user and the current date, respectively. So every row in the DataGridView should have the same value for these two columns.So far, I have thought of two ways to get this working, but neither one seems very clean. The first idea is to make a custom Fill method that takes as parameters the user and the current date and then add them as extra columns in the select method. For example
View 1 Replieslet's say the datagridview have 3 column
|--------------------------------
| id | name | age |
-----------------------------------
| 1 | john | 20 |
------------------------------------
i want to get "id" only from every row i tried this code,but it wont work
For cn As Integer = 0 To DataGridView1.RowCount - 1
DataGridView1.Rows(cn).Cells(0).Value)
Next
I have a Xtragrid where when I double click the row I need to be able to pass the value of one of the columns to a stored procedure. There's got to be an easy way to do this but I haven't been able to find it.
View 9 RepliesHow can I add all the items of a specific column of a listview. For example I had a listview of a class like:
name............... surname............... age
------------------------------------------------
asdsa..............asdasdasd................21
sadsad..............asdasdasd...............23
sadsad...............adasdasd...............24
I just want to add all the numbers of age column so I can find the total sum of ages of the students. I want, when I clicked my button It makes my textbox's text = 68 for this example.
lets say i have a datagridview with 4 column "a,b,c,d"now i only want insert entire column "b and c" into sql database, is this possible to do it?
View 2 Repliescan i ask how do i insert my records from my textbox to specific column name of my table
IsConnected("Insert into products values(" & _
Me.TextBox1.Text & ",'" & _
Me.TextBox3.Text & "','" & _
[code].....
I have the following piece of VBA code that I need to convert to VB.NET for use with a ListView control (the original VBA control was a ListBox):
For i = 0 To lstProperties.ListCount - 1
If lstProperties.Column(18, i) = "" Or IsNull(lstProperties.Column(18, i)) Then
GoTo OpenFrm
[Code].....
Let's say I want to search only in the 3rd or 8th column of the listview. How do I do that?
View 4 Replieslooking like this:
ID | Value
1 | 6
2 | 5
[code].....
Which syntax is to be used in order to retrieve that IconCriteria(2) applies to cell C5.[code..]
View 2 RepliesI have a datatable contain fId field. I want to update all values for this field to "1" without using loop. [Code]
View 1 Repliesi have a form which is having 1 list view and a text box. list view having total 100 rows data list view is having a 5 column column 3 is having two words "yes" and "no" i just want to count the number of occurrence of the word "yes" in column 3 the total row can be count with this code: COUNT TOTAL ADMISSION Dim rowcount As Integer = 0
[Code].....
I wanted to visualize to the user the diffrence if they opted for certain values. In mycase certain choises would show phonenumbers on intranet.To show how I wil leave the control names default. To recreate the the project. Start a windows form application, place a datagridview, and 2 bindingsources on the form To start we need some data to show and a list to choose from.To make a simple example I chosen to make a person class containing an Id, Name and Position.Id If the Position is a staff position it should be blue others should remain the default style.But lets start with the colorScheme Interface so we can store the colorscheme we want to show for a certain positionitem in the datagrdview It wil need back and forecolors but also colors for teh item whilst selected. To show the Displaymember we want to see I've also added the toString property that should shadow the toString of the object.[code]
View 2 RepliesUsing VB.NET i want find a specific string that occurs in column B of an Excelsheet and copy that entire row and paste it in a new worksheet. This string occurs a couple of times in this B column.I know how to open up an excel sheet in VB but I'm having difficulties searching for the string and then copying that entire row and do it multiple times (loop until the end of the column)
View 4 Repliesi have a problem regarding datagrid.remove and textbox. This is a Function to Add and Subtract Values on a specific Column. If I cellclick on the main datagrid on a specfic row which has record where the record goes to the other datagrid with no record yet to be filled with record, the textbox will count/ add all the values from the UNITS COLUMN and in an instance on one row removed in the other datagrid, the total value of units in the textbox does not subtract or less. here's the code.
Public Function total_units_remove() As Double
Dim totalunits As Double = 0
Dim i As Integer = 0
[Code].....
I'm a beginner developer using VB 2008 Express Edition and SQL Server 2008 Express. I have tried my simple problem using many different ways and also have searched the web, LINQ to SQL, SQL commands, MSDN library, MSDN Forums, 'How do I' help document, and ... but come up empty. In my simple Table.mdf (see below), I have created some tables (T1, T2, T3, ...) which none is joined together. What I try to do upon request is to get a value string of specific row and column of table?
[Code].....