Retrieve database values into checked list box in c#

Question

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.

Sakthivel Sambandam · Answer

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);

Pavithra L · Answer

Ok i will use it and if it will give the answer means i will definitely accept your answer. Thanks for your reply.

Raja T · Answer

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

Pavithra L · Answer

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.

Raja T · Answer

Please send me what error you got?

Pavithra L · Answer

Hai Am not getting answer till now.

Raja T · Answer

Hi If your finding new/correct the your answer... please accept the answer.

Raja T · Answer

Please check let me know

Pavithra L · Answer

Now am I searching another one question  I want to finish that first then only I move to this topic . Thanks for your reply.

Raja T · Answer

Please check let me know

Raja T · Answer

Please check let me know

Raja T · Answer

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]; }

Raja T · Answer

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]; }

Raja T · Answer

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]; }

Pavithra L · Answer

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.

Raja T · Answer

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]; }

Pavithra L · Answer

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.

Raja T · Answer

Are you getting any error? What you tried pls share the code...

Pavithra L · Answer

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.

Raja T · Answer

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/