SqlDataAdapter da = new SqlDataAdapter("Select ID,DrugName,PurchasePrice,SellPrice,Stock from AddProduct where DrugName ='" + comboBox1.SelectedItems + "'", conn); DataTable dt = new DataTable(); da.Fill(dt); textBox1.Text = (dt.Rows[0]["ID"].ToString()); textBox2.Text = dt.Rows[1]["DrugName"].ToString(); textBox3.Text = (dt.Rows[2]["PurchasePrice"].ToString()); textBox4.Text = (dt.Rows[3]["SellPrice"].ToString()); textBox6.Text = (dt.Rows[4]["Stock"].ToString());
SqlDataAdapter da = new SqlDataAdapter("Select ID,DrugName,PurchasePrice,SellPrice,Stock from AddProduct where DrugName ='" + comboBox1.SelectedText + "'", conn);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)