//method to get datasource
public Dataset ViewDetails()
{ SqlConnection cn =new SqlConnection(connstring);
SqlDataAdapter adp =new SqlDataAdapter(“view”, cn);
adp.SelectCommand.CommandType =CommandType.StoredProcedure;
cn.Open();
Dataset dt =new Dataset();
adp.Fill(dt);
cn.Close();
return dt;
}
//
//to load combo box with values
private void NewForm_Load(object sender, EventArgs e)
{
DataSet ds = db.ViewDetails();
Combobox1.DataSource = ds;
Combobox1.DisplayMember =“Table.Id”;
Combobox1.ValueMember =“Table.Id”;
}