01.try
02. {
03. using (SqlConnection con = new SqlConnection(Conns))
04. {
05. string sql = "SELECT * FROM Product";
06. SqlDataAdapter da = new SqlDataAdapter(sql, con);
07. DataSet ds = new DataSet();
08. da.Fill(ds, "Pro");
09. cmbProduct.DataSource = ds.Tables["Pro"];
10. cmbProduct.DisplayMember = "ProductName";
11. cmbProduct.ValueMember = "ProductID";
12. }
13. }
14. catch (Exception Ex)
15. {
16.
17. MessageBox.Show(Ex.Message);
18. }
