Advertisement
KySoto

Start of load datatable into a form

Jun 19th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 2.56 KB | None | 0 0
  1.     Private Sub cmbPartNumber_SelectedValueChanged(sender As Object, e As EventArgs) Handles cmbPartNumber.SelectedValueChanged
  2.         Dim cchk As CheckBox
  3.         If loaded Then
  4.             If Me.cmbPartNumber.SelectedIndex > -1 Then
  5.                 'Debug.Print(Me.cmbPartNumber.SelectedIndex.ToString)
  6.                 Me.Testing_Lookup_GroupHeaderTableAdapter.FillByPnAndGr(Me.Assy_TestingDataSet.Testing_Lookup_GroupHeader, Me.cmbPartNumber.Text, 1)
  7.                 For Each r As DataRow In Me.Assy_TestingDataSet.Testing_Lookup_GroupHeader.Rows
  8.                     For Each c As DataColumn In r.Table.Columns
  9.                         Try
  10.  
  11.                             If r.IsNull(c) Then
  12.                                 'Debug.Print("Column " & c.ColumnName & " Is null")
  13.  
  14.                             ElseIf c.DataType = GetType(Boolean) Then
  15.                                 If Me.Controls.ContainsKey("chk" & c.ColumnName) Then
  16.                                     cchk = CType(Me.Controls("chk" & c.ColumnName), CheckBox)
  17.                                     cchk.Checked = r.Field(Of Boolean)(c.ColumnName)
  18.                                 End If
  19.                             ElseIf c.DataType = GetType(String) Or c.DataType = GetType(Double) Or c.DataType = GetType(Integer) Then
  20.                                 If c.ColumnName = "holdnext" Or c.ColumnName = "DSP_NOTE" Then
  21.                                     If Me.Controls.ContainsKey("chk" & c.ColumnName) Then
  22.                                         cchk = CType(Me.Controls("chk" & c.ColumnName), CheckBox)
  23.                                         cchk.Checked = (r.Field(Of String)(c.ColumnName) = "Y")
  24.                                     End If
  25.                                 Else
  26.                                     If Me.Controls.ContainsKey("txt" & c.ColumnName) Then
  27.                                         Me.Controls("txt" & c.ColumnName).Text = r.Field(Of Object)(c.ColumnName).ToString
  28.                                     End If
  29.                                 End If
  30.                             End If
  31.                         Catch ex As Exception
  32.                             'MessageBox.Show("Source: " & ex.Source & ControlChars.NewLine & "Message: " & ex.Message & ControlChars.NewLine & "StackTrace: " & ex.StackTrace)
  33.                             Debug.Print("Source: " & ex.Source & ControlChars.NewLine & "Message: " & ex.Message & ControlChars.NewLine & "StackTrace: " & ex.StackTrace)
  34.                         End Try
  35.                     Next
  36.                 Next
  37.             End If
  38.         End If
  39.     End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement