filling listCheckBox with table data

Gabriel olayinka

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cynthia Sathuragiri8y ago
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 olayinka8y ago
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
Amit Gupta8y ago
Where did you stuck? Share your code of tried something. Also mention which technology you are woeking with.