I have 1 Table Called "Menu" there are some textboxes and a combobox.
I want to fill data in the Textbox called "Menu_Rate" on Selection of combobox selected item & coressponding rate of the Menu shoud be displayed in the textbox.
This is my Code
con.ConnectionString = "Data Source=localhost;Integrated Security=true;Initial Catalog=Restaurant" cmd.CommandText = "select Menu_Rate from Menu where Menu_Name='" & cbMenu.SelectedItem & "'" cmd.Connection = con da.SelectCommand = cmd con.Open() da.Fill(ds, "Menu") con.Close() con.Dispose() cmd.Dispose() TxtRate.Text = ds End Sub
Edited by bhavan kamble: n/a