hii frnd i need your help i am work on vb.net window application my qus is
IN COMBO BOX I SET THE VALUE FORM THE DATABASE AND IT'S SHOW IN COMBO BOX LIKE NAME BUT NOW IF I SELECT NAME THEN OTHER INFOMATION LIKE EMAIL ID OR ETC ARE ALSO SHOW THE VALUE ..means i select one name and other infomation show .only i select combobox name ...

Public Function select_employee_details(ByVal empcode As String) As DataTable


        Dim cmd As New SqlClient.SqlCommand
        Dim tbl As New DataTable
        Dim da As New SqlClient.SqlDataAdapter
        'Dim reader As SqlClient.SqlDataReader
        Dim ds As New DataSet
        Dim sql_select As String
        Try
            cn.Open()

            sql_select = "select * from EmMaster where EmMaster_EmpCode ='" + empcode + "'"
            'sql_select = "select * from EmMaster"
            'cmd = New SqlClient.SqlCommand(sql_select, cn)

            'reader = cmd.ExecuteReader
            '  da.Fill(ds, "EmMaster")


            da = New SqlDataAdapter(sql_select, cn)
            da.Fill(ds, "EmMaster")
            tbl = ds.Tables(0)

            cn.Close()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
        Return tbl
    End Function
     Private Sub HbaDetails_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded

        Dim cn As New SqlConnection("Data Source=HAARD-PARIKH\SQLEXPRESS;Initial Catalog=databasehba;Integrated Security=True")
        Dim strSQL As String = "select EmMaster_EmployId,EmMaster_EmpCode,EmMaster_EmpName from EmMaster"
        Dim da As New System.Data.SqlClient.SqlDataAdapter(strSQL, cn)
        Dim ds As New DataSet
        da.Fill(ds, "EmMaster")
        With Me.cmbName
            ' .ItemsSource
            .ItemsSource = ds.Tables(0).DefaultView
            .DisplayMemberPath = "EmMaster_EmpName"
            .SelectedValuePath = "EmMaster_EmployId"
            .SelectedIndex = 0
        End With

    End Sub
This article has been dead for over six months. Start a new discussion instead.