Populate a txtbox field, clicking on a datagridview cell from a datatable

• • Reply

  14 years ago

  by dken

  Ken Garcia

  Arizona, United States

  Joined 14 years ago

  Hello. 1st Message.  If too long, pls forgive. Question is regarding  DataTables. Wet behind the ears with some earlier experience w-VB6 & SQl. No, no expert. I analyse data for use by the big guys and while doing so learning how they use it as far as datagrids, datatables, web & 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 (Clicked). Hope this is the right forum for this simple but long query.  Here is some of the code:

  '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
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  Report abuse
• • Reply

  14 years ago

  by konikula

  Matej Kasper

  Trutnov, Czech Republic

  Joined 15 years ago
  Key is event onSelectedCellChanged or somehow like that called crap, which gives you cell index, and key #2 is dg property CurrentRowIndex, which provides pointer to row.
  If more data  selected, vb2003 has problems to get pointers. In more rcnt versions good changes, but in this 'old' 2003 you must go from 0 to Error and check .isSelected... :)
  
  
  
  Report abuse