[manutd4life]

Hi every1, i never work with datagridview and i need to make the selected row displayed in textboxes.
For example i had three textboxes (txt1, txt2, txt3) and the datagridview had three columns (name, surname, address).
The datagridview in connected with an access database using oledbconnection.
So i wanted to select a row and then display the selected row in there respective textboxes.
The name goes in txt1, the surname goes in txt2, the address goes in txt3
please help
thanks

[AdamSpeight2008]

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this:

Thanks.

[manutd4life]

Here's the code:

Private Sub DataGridView_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView.CellClick
		dSet.Tables(0).PrimaryKey = New DataColumn() {dSet.Tables(0).Columns("WatchID")}
		Dim row As DataRow
		row = DataGridView.Rows(DataGridView.SelectedCells(0).RowIndex).Cells(0).Value
		txt1.Text = row("name")
		txt2.Text = row("surname")
		txt3.Text = row("address")
	End Sub

i dont know whether the code is good or wrong cause i never work with datagridview
so please help

[manutd4life]

ok i got it,
here's the code:

	Private Sub DataGridView_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView.CellClick
		Dim i As Integer
		i = DataGridView.CurrentRow.Index
		Me.txtSupplierId.Text = DataGridView.Item(0, i).Value
		Me.txtSupplierName.Text = DataGridView.Item(1, i).Value
		Me.txtSupplierSurname.Text = DataGridView.Item(2, i).Value
		Me.txtAddress.Text = DataGridView.Item(3, i).Value
		Me.txtPhoneNumber.Text = DataGridView.Item(4, i).Value
		Me.txtEmailAddress.Text = DataGridView.Item(5, i).Value
	End Sub

my problem is that when i click on an empty row, i got an error.
so how to validate an empty row
please help

[_HAWK_]

Databind each textbox's text property to a field in the table.

[manutd4life]

can u help me out how to databind each textbox

[_HAWK_]

Select a textbox, in it's property window scroll down to databindings expand it, click on the text dropdown button, your datasource window should open up, then keep expanding the table until you reach the field you want, repeat this for each textbox. Enjoy...

[manutd4life]

Everything work fine, i just set the datagridview property
Allow user to add new rows to false and all work great