مثال بایند کردن کمبو:
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|datadirector y|\DB.mdf;Integrated Security=True;Connect Timeout=30");
DataTable dt_city = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
try
{
if (con.State == ConnectionState.Closed)
con.Open();
da = new SqlDataAdapter("SELECT code_city , city_name FROM tbl_city", con);
da.Fill(dt_city);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}
cmb_city.DataSource = dt_city;
cmb_city.ValueMember = "code_city";
cmb_city.DisplayMember = "city_name";