Code

Question

Hi sir, I take an checked listbox then I want to show checked checkedlistbox items in datagridview in window application. thank u.

Abhijit Patil · Answer

hey vibhu int i = checkedListBox1.CheckedItems.Count; for (int s = 0; s <= i - 1; s++) { SqlCommand cmd = new SqlCommand("select pdate,invoice,firmname,first_amount from purchase_list where invoice=@inv", con); cmd.Parameters.AddWithValue("@inv", int.Parse(checkedListBox1.CheckedItems[s].ToString())); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); if (dr.HasRows) { dt.Load(dr); } dataGridView1.Rows.Add(); dataGridView1.Rows[s].Cells[0].Value = ds.Tables[0].Rows[s].ItemArray[0]; dataGridView1.Rows[s].Cells[1].Value = ds.Tables[0].Rows[s].ItemArray[1]; dataGridView1.Rows[s].Cells[2].Value = ds.Tables[0].Rows[s].ItemArray[2]; dataGridView1.Rows[s].Cells[3].Value = ds.Tables[0].Rows[s].ItemArray[3]; } } hope it helps

Kailash Chandra Behera · Answer

Hi vibhu visit the link may help you http://social.msdn.microsoft.com/Forums/en-US/6d5b2a42-2f1c-46b8-b3f0-5414e14b3374/place-checklistbox-inside-datagridview?forum=vblanguage please accept if it helpful to you

Code

Answers (2)