Search:

Yeah that's right paulg4ije.

I'm trying what .paul. provide but still no result. :(

Thank you .paul. for your reply.

The Data grid view and the text boxes are in the same form, so it will remain the same code anyway?

Thanks

Thank you for your reply both of you.

@techgnome Do you have any sample code?

Thanks again.

Hello,

I have a table called "EmployeeMainFile" and i have a lot of columns. In my Data Grid view I'm only displaying the EmpCode, EmpName and PassportNo.

My question is if I clicked on one...

Hello,

I have a Data Grid view with Columns, i want the column UProertyNo to have a default value from a text box.
I'm showing the UPropertyNo Column to enter the data manually, but actually i...

Thanks a lot si_the_geek.

I have changed a little bit in the code which you gave me and its solved.

Thanks for giving me this idea.

Hello,

I have a Table in SQL DB called VNewEntries and the columns are: ID, EmpNo, AppointmentDate, VFrom, VTo, VBasicSalary, VAllowances, DeservedBalanceDays, DeservedBalanceKD.

What I want is...

Thank you. it is solved.

I have a data grid view and i insert data in it. When i type a row it automatically open a new row, That's good, but it inserts the null row to the database.

how to not insert it in the database....

In the original post the Employee No "1" has three records 200,500 and 400, i want to get the 400 because it is Max(ID) not the 500(because it is the max salary.

Thank you jmcilhinney for your reply.
Sorry for the last posts but i'm new in this.


The above solution was good, but actually what i want to get is the max salary based in ID on EmployeeSalary,...

Hello,

I have two tables, First is "EmployeeMainFile" and the second is "EmployeeSalary".
In "EmployeeMainFile" i have for example the following records:



ID
EmpNo
Name

The Foreign key is EmpSNo

The EmpSNo is primary with ID, so i have two primary keys in EmpSalary table.

Thank you for your reply.
EmpNo is primary key in EmployeeMainFile
EmpSNo is primary key in EmpSalary.

The Employee and Emp its just a mistake from me, you can consider the EmpSalary as...

Hello,

I have two tables, First is "EmployeeMainFile" and the second is "EmpSalary".
In "EmployeeMainFile" i have for example the following records:



ID
EmpNo
Name

Thanks a lot PlausiblyDamp and si_the_geek.

It is solved. :)

Thank you for your reply PlausiblyDamp.

There is one row for one employee and others no rows.

For EmpSNo it is NVarChar because the Employee No will take characters, for example "ABC123".

Hello,
I have a form, i put the below code on Form Load, but when i open it and there is no row in the data grid view i get the following error:
"index was out of range. must be non-negative and...

Hi,

I have a program made from vb.net and SQL database, how can i install it on client's PC? Should i install the SQL server on the client's PC? and if there is another way tell me.

Thanks.

Yes, both are solved.

Thank you so much.

I'm using this for update




Try
cmd.Connection = con
con.Open()

cmd.CommandText = "UPDATE JobTitle SET JobTitleA = '" & txt_JobTitleA.Text &...

Thank you for your reply.

It is already nvarchar. But the issue that i was using the above code before and it was ok.

So What about Updating, how to update the record?

Hello,

I have a problem, it is when i want to insert Arabic value from Visual Studio to an SQL database it is showing ???? or NULL.

I'm using the following code:



Try
...

Hello,

I have a problem, it is when i want to insert Arabic value from Visual Studio to an SQL database it is showing ???? or NULL.

I'm using the following code:



Try
...

Hello,

I have a crystal report and a gridview. All i want to display only the current rows in the gridview.

I execute the below code, but i got an error "Unable to cast object of type...

Hello,

I have a crystal report and a gridview. All i want to display only the current rows in the gridview.

I execute the below code, but i got an error "Unable to cast object of type...

But in this way, it will only show the data in the .txt file not from the database!

Thank you.

Now when i want to open the Form1 it gives me "Could not find the file 'C:\Users\..\..\..\bin\debug\People.txt'"



Dim dt =
(From line In...

Ok i did it. Still on thing, in the below it gives me "Type 'ChildForm' is not defined"



Private Sub Button2_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
...

Sorry for disturbing you, but i couldn't find ToDataTable.

What to do exactly?

So Shall i download it from the link that you have provided it?

I wrote kevininstructor’s example, but it gives me "'TDataTable' is not a member of 'System.Collections.Generic.IEnumerable(Of<anonymouse type>)'" here:



Dim dt =
(From line In...

Thank you kevininstructor for your reply.

The output is good as you have shown up, but can i get VS2010 code?

Thank you IanRyder for your reply.

For the second code, where i should put it?

Hi,

I have 2 datagridview.
DataGridView1 in Form1 and DataGridView2 in Form2.

In DataGridView1 in Form1 i have data and one column contains Checkbox.

What i want is when i click the...

Thank you for the reply.

i don't want to bound it, because in one form i will enter the data, then in an another form in a datagridview i will select the checkbox if it is true or false.

But if it is not bounded?

Thank you dday9 for your reply.

I guess the code is ok. but how to get from DataGridView.

Hi,

I have 2 datagridview.
DataGridView1 in Form1 and DataGridView2 in Form2.

In DataGridView1 in Form1 i have data and one column contains Checkbox.

What i want is when i click the...