private void btnprint_Click(object sender, EventArgs e) { print(); if (txtsearch.Text.Length > 0) { if (dataGridView1.Rows.Count > 0) { for (int a = 0; a < dataGridView1.Rows.Count; a++) { string item = (dataGridView1.Rows[a].Cells[3].Value.ToString()); int quantity = Convert.ToInt32(dataGridView1.Rows[a].Cells[4].Value.ToString()); decimal total = Convert.ToDecimal(dataGridView1.Rows[a].Cells[5].Value.ToString()); string date = DateTime.Today.ToShortDateString(); int b = blod.addorder(item, quantity, total, Convert.ToDateTime(date)); } } else { lblmsg.Text = "No record found in database"; } int i = blod.deletefromtable(Convert.ToInt32(txtsearch.Text)); if (i > 0) { MessageBox.Show("Data has been save to database"); } } }