collecting data from datagrid and pull it to other commands

[ronlahav]

i want to identify selected row in datagrid and populate few textboxes with the appropriate data from the dataview/datagrid which connected to a datagrid how can i do that?

i have the folowing event

rivate Sub grdCompanies_Navigate(ByVal sender As System.Object, ByVal ne As System.EventArgs) Handles grdCompanies.DoubleClick


**which code should i put here so when the user double click on a row i get the appropriate data from the dataview and pull it to textbox


End Sub

thanks for help

[Athley]

DataGrid1.CurrentRowIndex gives you the current row index. Use that with your DataView object. Something like this maybe....

dv.Item(DataGrid1.CurrentRowIndex)("ColumnName")

[ronlahav]

thanks for the answer
what happen if i filter the grid? the indexes wont be the same no?

[ronlahav]

i made the datagrid rowselection as the entire row - my problem is when i filter the row i want to go get the appropriate value and input it to some commads - how do i do that?

[Athley]

The index will in most cases probably not be the same, but the row you are doubleclicking is the one with CurrentRowIndex, and as I understand it you want data from the row you doubleclicked to pop into textboxes, ie the one with CurrentRowIndex, right?

[ronlahav]

yup i just need the record data - but i had additional data which exists in the dataview and not in the grid

[Corinne]

Did you ever solve this? I'm having a similar problem & can't figure it out.

[chinhow]

You should have a BindingContext Command in
Private Sub grdCompanies_Navigate(ByVal sender As System.Object, ByVal ne As System.EventArgs) Handles grdCompanies.DoubleClick

Let me know if you have bindingcontext problem.

[Corinne]

How would I use the bindingcontext command? Can you provide an example?

Thanks

[chinhow]

Private Sub datListSetting_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles datListSetting.Click
        Me.BindingContext(DataSet11, "DatabaseTableName").Position = datListSetting.CurrentRowIndex
    End Sub

set the each textbox's properties , databinding.text = dataset's datafield.