filling listCheckBox with table data

Question

i have a database table that consist of ID(int) , NAME(varchar) , ADDRESSING, STATUS(int) ..... I want to Populate a listCheckBox with the table data and check every row where the STATUS ==1..... I'm really getting stuck. I need help on how to do this

Amit Gupta · Answer

Where did you stuck? Share your code of tried something. Also mention which technology you are woeking with.

Cynthia Sathuragiri · Answer

Hi Gabriel, Here am sharing my code to bind the data to Checklist. Hope it helps! using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager .ConnectionStrings["connstring"].ConnectionString; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "select * from Detail"; cmd.Connection = conn; conn.Open(); using (SqlDataReader sdr = cmd.ExecuteReader()) { while (sdr.Read()) { ListItem item = new ListItem(); item.Text = sdr["Text"].ToString(); item.Value = sdr["Value"].ToString(); item.Selected = Convert.ToBoolean(sdr["Status"]); chklist.Items.Add(item); } } conn.Close(); } }

Gabriel olayinka · Answer

here is my code.... i'm working with c# winform void fillChecklist() { try { con.Open(); string ct = "select * FROM Detail"; cmd = new SqlCommand(ct); cmd.Connection = con; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) //fill the checkListBox with all the table record { checkedListBox1.Items.Add(rdr.GetString(1)); if (rdr.GetString(1)==1) { //check every row in the checkListbox where STATUS =1 //this is where I’m having major issue }//end if }//end while }//end try finally { con.Close(); } }//end fillChecklist method