hello guys i need help how can u get the data in to two tables in one form. This code works but the problem is like in combobox2.text the data is display twice and also in inEmployee.text the data is display 4 time both are combobox so when u click the combobox u can see that the data is display twice or 4 times.....
i need help please
Dim sqlquery = "SELECT * FROM facilitydata, customerdata, employeedata"
Dim myCommand As New MySqlCommand()
myCommand.Connection = conn
myCommand.CommandText = sqlquery
'start query
myAdapter.SelectCommand = myCommand
Dim myData As MySqlDataReader
myData = myCommand.ExecuteReader()
Try
While myData.Read
Try
ComboBox2.Text = "Select"
ComboBox3.Text = "None"
Me.ComboBox2.Items.Add(myData.Item("facname"))
Me.ComboBox3.Items.Add(myData.Item("amenity"))
Me.Textbox1.Items.Add(myData.Item("custname"))
Me.inEmployee.Items.Add(myData.Item("empname"))
Catch ex As Exception
MsgBox("!ERROR!")
End Try
End While