private void btnprint_Click(object sender, EventArgs e) { try { Printing prndata = new Printing(); if (LVclient.Items.Count > 0) { prndata.execute("delete from printing"); DataTable dt1 = con1.getdataset("select * from company WHERE isactive=1"); int j = 1; for (int i = 0; i < LVclient.Items.Count; i++) { string itemname = "", CompanyName = "", GroupName = "", Unit = "", SalePrice = "", MRP = "", PurchasePrice = ""; itemname = LVclient.Items[i].SubItems[1].Text; CompanyName = LVclient.Items[i].SubItems[2].Text; GroupName = LVclient.Items[i].SubItems[3].Text; Unit = LVclient.Items[i].SubItems[4].Text; SalePrice = LVclient.Items[i].SubItems[5].Text; MRP = LVclient.Items[i].SubItems[6].Text; PurchasePrice = LVclient.Items[i].SubItems[7].Text; string qry = "INSERT INTO Printing(T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22)VALUES"; qry += "('" + j++ + "','" + dt1.Rows[0][0].ToString() + "','" + dt1.Rows[0][1].ToString() + "','" + dt1.Rows[0][2].ToString() + "','" + dt1.Rows[0][3].ToString() + "','" + dt1.Rows[0][4].ToString() + "','" + dt1.Rows[0][5].ToString() + "','" + dt1.Rows[0][6].ToString() + "','" + dt1.Rows[0][7].ToString() + "','" + dt1.Rows[0][8].ToString() + "','" + dt1.Rows[0][9].ToString() + "','" + dt1.Rows[0][10].ToString() + "','" + dt1.Rows[0][11].ToString() + "','" + dt1.Rows[0][12].ToString() + "','" + dt1.Rows[0][13].ToString() + "','" + itemname + "','" + CompanyName + "','" + GroupName + "','" + Unit + "','" + SalePrice + "','" + MRP + "','" + PurchasePrice + "')"; prndata.execute(qry); } Print popup = new Print("ItemReport"); popup.ShowDialog(); popup.Dispose(); } else { MessageBox.Show("No Records For Printing.."); } } catch (Exception excp) { } }