asked on
ASKER
Private Sub BuildDotCB()
Dim dsDot As New DataSet
Try
DotCB.Items.Clear()
Dim QueryString As String = "Select Distinct ID FROM tblSystemInformationEmployee "
Dim drow As DataRow
drow = Nothing
dsId = New DataSet
dsId= GetResultDataset(QueryString, ConnectionString)
If IsValidDataset(dsDot) Then
For Each drow In dsId.Tables(0).Rows
DotCB.Items.Add(drow(0).ToString())
Next
End If
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
ASKER
Private Sub ViewMode(ByVal GUID As String)
Try
Dim viewDs As New DataSet()
Dim Query As String
Query = "Select * from tblSystemEmployee Where UID = '" & GUID.Trim & "'"
viewDs = GetResultDataset(Query, True)
Dim dv As DataView = New DataView(viewDs.Tables(0))
Dim Notify As String = String.Empty
If dv.Count > 0 Then
If Not IsDBNull(dv(0)("UID")) Then
txtHWGUID.Text = dv(0)("UID")
Else
txtHWGUID.Text = String.Empty
End If
If Not IsDBNull(dv(0)("StreetName")) Then
txtHWStName.Text = dv(0)("StreetName")
Else
txtHWStName.Text = String.Empty
End If
End If
Catch ex As Exception
MsgBox("No Values Found")
End Try
End Sub
Private Sub IDCB_SelectionChanged(sender As System.Object, e As System.Windows.Controls.SelectionChangedEventArgs) Handles IDCB.SelectionChanged
StreetCB.IsEnabled = False
ViewMode(IDCB.SelectedItem.ToString)
Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,
TRUSTED BY
ASKER