We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,127 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

How to bind two combobox and next how to fill textbox using combobox

Dim mm As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=Integrated Security=True;Connect Timeout=30;User Instance=True")
        mm.Open()
        Dim mm1 As New SqlDataAdapter("select * from Area_type order by Area_name", mm)
        Dim ds As New DataSet
        mmm1.Fill(ds)
        With ComboBox1
            .DataSource = ds.Tables(0)
            .DisplayMember = "Area_name"
            .ValueMember = "Area_name"
            .SelectedIndex = 0
        End With
        mm.Close()

        'hi i am student and  what do i now for bind other combobox1 with combobbox2 help of above code????'
        'below code fill textbox to combobox3 Selected item what i do plz give full code with detail thanx'

        Dim mm1 As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=;Integrated Security=True;Connect Timeout=30;User Instance=True")
        mm.Open()
        Dim mm2 As New SqlDataAdapter("select * from Add_Book order by Book_name", mm)
        Dim ds1 As New DataSet
        mm2.Fill(ds1)
        With ComboBox3
            .DataSource = ds1.Tables(0)
            .DisplayMember = "Book_name"
            .ValueMember = "Book_id"
            .SelectedIndex = 0
        End With

 Private Sub ComboBox3_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox3.SelectedIndexChanged
        Dim mm3 As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=;Integrated Security=True;Connect Timeout=30;User Instance=True")
        Dim da As New SqlDataAdapter
        Dim dq As New DataSet
        Dim dt As DataTable
        Try
            da = New SqlDataAdapter("select * from Add_Book where Book_price = " & ComboBox1.SelectedItem & "", mm3)
            da.Fill(dq, "Add_Book")
            dt = dq.Tables("Add_Book")
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
        TextBox1.Text = dt.Rows.Item(0).Item(0)
    End Sub       
1
Contributor
0
Replies
1
View
Maulikpra
Newbie Poster
3 posts since Jul 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
View similar articles that have also been tagged:
 
© 2013 DaniWeb® LLC
Page rendered in 0.0572 seconds using 2.67MB