Code

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