Hello. 1st Message. If too long, forgive. Question is regarding DataTables. Wet behind the ears also but some early experience w-VB6 & SQl. No, no expert. I analyse data for use by the big guys. Learning how they use it as far as datagrids, datatables & forms. Anyway. Simply put. I have a form with 3 datagridviews (Objects)bringing in 3 tables to have data compared and hopefully edited. Not using DataSets but DataTables instead. Struggle is: How do I code an event for clicking on the datagridview field & populate a text box object with the datagrid data selected. Hope this is the right forum for this simple but long query.
'My Connection String....
MyConn.ConnectionString = My.Settings.MyConn
MyConn.Open()

DT = New DataTable
DT2 = New DataTable
DT3 = New DataTable

'Setting my SelectCommand properties....
MyCmd.CommandType = CommandType.Text
MyCmd.CommandText = "SELECT Top 10 ODppid,ODid,PayPlanStatus FROM ODPayPlan ORDER BY ODppid"

MyCmd2.CommandType = CommandType.Text
MyCmd2.CommandText = "SELECT Top 10 ODid, TransCode,TRid,TransVar FROM ODTrans ORDER BY ODid"

MyCmd3.CommandType = CommandType.Text
MyCmd3.CommandText = "SELECT Top 10 ODid,PropId,vVarChar,vDate FROM ODdata ORDER BY ODid"

Dim MyQryString As String = MyCmd.CommandText
Dim MyQryString2 As String = MyCmd2.CommandText
Dim MyQryString3 As String = MyCmd3.CommandText

Dim MySDA As SqlDataAdapter = New SqlDataAdapter(MyQryString, MyConn)
Dim MySDA2 As SqlDataAdapter = New SqlDataAdapter(MyQryString2, MyConn)
Dim MySDA3 As SqlDataAdapter = New SqlDataAdapter(MyQryString3, MyConn)

'Fill the DataGrid...
MySDA.Fill(DT)
MySDA2.Fill(DT2)
MySDA3.Fill(DT3)
Thank You

DeaconKen

For those interested I figured out the required code: Use a Sub for each DataGridView then use this code -
Private Sub DGV1_CellEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DGV1.CellEnter
        If sender.selectedcells.count > 0 Then
            '//Only show if selected cell is in any column
            Dim iRow As Int32
            Dim iCol As Int32
            If CType(sender, DataGridView).SelectedCells(0).ColumnIndex >= 0 Then
                iRow = e.RowIndex
                iCol = e.ColumnIndex
                Me.txtBxTest.Text = DGV1.CurrentRow.Cells(1).Value
            End If
        End If
    End Sub

DeaconKen