RSS

set combo box datasourse in code in windows form application

19 Feb

//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”;

}

 
Leave a comment

Posted by on February 19, 2013 in c#.net

 

Leave a comment