source code to fetch data from database to combobox using databinding in c#.net

[bharathk27]

SqlConnection con1 = new SqlConnection("Data Source =(local); Initial Catalog=cyberstations; Integrated Security=sspi;");
con1.Open();
string str1 = "select systemname from terminals where systemstatus='0'";
SqlCommand cmd1 = new SqlCommand(str1, con1);
SqlDataAdapter adp1 = new SqlDataAdapter();
DataSet ds1 = new DataSet();
adp1.SelectCommand = cmd1;
adp1.SelectCommand.ExecuteNonQuery();
adp1.Fill(ds1);
combobox1.DataSource = ds1.Tables[0];
combobox1.DisplayMember = "systemname";
combobox1.ValueMember = "systemname";
con1.Close();

here systemstatus used to check the condition. and systemname is the column which must be displayed in combobox.

this code works fine in microsoft visual studio 2005
edit reply report

[Curtis Rutland]

I've moved this thread to the "Writing Room" area. There are a few issues you need to work out before I move this back to the Insights section.

There are two existing insights on using Databases in your .NET programs.

http://bytes.com/topic/net/insights/635615-how-use-database-your-program

http://bytes.com/topic/net/insights/817960-how-use-database-your-program-part-ii

If you feel that you have something to add to them, please edit this post with the extra information.