Retrieve database values into checked list box in c#

Pavithra L

11y4.9k.NET

In my project am I using checkedlistbox for retrieve the database values of one field. and I can pass this checkedlistbox checked values to another form listbox . using c# windows application .How can I do this ????? It's urgent please reply me quickly.

20 Replies

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

Sakthivel Sambandam8y ago
index = Co_Activity_chklst.Items.IndexOf(Co_Activity_chklst.Items.FindByValue(word));
t = Co_Activity_chklst.Items[index].Text;
v = Co_Activity_chklst.Items[index].Value;
Co_Activity_chklst.Items.RemoveAt(index);
l=new ListItem(t, v);
l.Selected=true;
Co_Activity_chklst.Items.Insert(index, l);
+1
Pavithra L11y ago
Ok i will use it and if it will give the answer means i will definitely accept your answer.
Thanks for your reply.
+1
Raja T11y ago
Hi, are you tried bellow code

private void display3()
{
ds1 = new SqlDataAdapter("Select str from Goods_Inward GROUP BY str ", con);
DataSet ds= new DataSet();
ds1.Fill(ds);

listBox1.DisplayMember=" str";
listBox1.ValueMember="str";
listBox1.DataSource = ds.Tables[0];

}

Please check before select query contains records or not
+1
Pavithra L11y ago
Hai,
string s1 = DateTime.Now.ToString("yyyy");
label1.Text = s1;
con1.Open();
SqlCommand cmd = new SqlCommand("Select * from Sample where Year='" + label1.Text + "'", con1);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
textBox1.Text = Convert.ToString(idgeneration());

con1.Close();
}
else
{
textBox1.Text = Convert.ToString(idgeneration());

}
dr.Close();

am using this code in form load but the serial number was not loaded in textbox. It does not show any error.
+1
Raja T11y ago
Please send me what error you got?
+1
Pavithra L11y ago
Hai,

Am not getting answer till now.
0
Raja T11y ago
Hi, If your finding new/correct the your answer... please accept the answer.
0
Raja T11y ago
Please check let me know
0
Pavithra L11y ago
Now am I searching another one question , I want to finish that first then only I move to this topic .

Thanks for your reply.
0
Raja T11y ago
Please check let me know
0
Raja T11y ago
Please check let me know
0
Raja T11y ago
Hi Pavithra, Try like

private void display3()
{
ds1 = new SqlDataAdapter("Select str from Goods_Inward GROUP BY str ", con);
DataSet ds= new DataSet();
ds1.Fill(ds);

listBox1.DisplayMember=" str";
listBox1.ValueMember="str";
listBox1.DataSource = ds.Tables[0];

}
0
Raja T11y ago
Hi Pavithra, Try like

private void display3()
{
ds1 = new SqlDataAdapter("Select str from Goods_Inward GROUP BY str ", con);
DataSet ds= new DataSet();
ds1.Fill(ds);

listBox1.DisplayMember=" str";

listBox1.DataSource = ds.Tables[0];

}
0
Raja T11y ago
Hi Pavithra, Try like

private void display3()
{
ds1 = new SqlDataAdapter("Select str from Goods_Inward GROUP BY str ", con);
DataSet ds= new DataSet();
ds1.Fill(ds);

listBox1.DisplayMember=" str";

listBox1.DataSource = ds.Tables[0];

}
0
Pavithra L11y ago
Hai Raja,

Your code showing this message only in that listbox.
System.Data.DataRow.

What can I do.

Thanks for your reply. Please help me on another question I had posted now how to reset the auto increment number in textbox based on the year.

Please help me for this now. I want to solve this first then only i move on to the checked list box concept.
0
Raja T11y ago
Hi Pavithra, Try like

private void display3()
{
ds1 = new SqlDataAdapter("Select str from Goods_Inward GROUP BY str ", con);
DataSet ds= new DataSet();
ds1.Fill(ds);

listBox1.DisplayMember=" str";

listBox1.DataSource = ds.Tables[0];

}
0
Pavithra L11y ago
Hai Raja,
This is my code. I call this in form load event. But still am not getting correct code. Is there any possibilities to solve this.

private void display3()
{
ds1 = new SqlDataAdapter("Select str from Goods_Inward GROUP BY str ", con);
dt1 = new DataTable();
ds1.Fill(dt1);
// listBox1.Text = dt1.Rows[0][0].ToString();
// textBox3.Text = dt1.Rows[0][0].ToString();
listBox1.DataSource = dt1;
listBox1.DisplayMember = "str";
}

Thanks for your reply. Please help me to find the answer.
0
Raja T11y ago
Are you getting any error? What you tried pls share the code...
0
Pavithra L11y ago
Hai Raja,

Thans for your reply. I already go through this but its not working. Will you please tell me any other solution for my query.
Its urgent will you please reply me quickly.
0
Raja T11y ago
Hi Pavithra, please check out bellow URLs

http://www.encodedna.com/2014/04/windows-forms-checkedlistbox-csharp-vb.htm

http://www.aspforums.net/Threads/926291/Populate-CheckedListBox-from-database-in-Windows-Forms-WinForms-application-using-C-Net/
0