Exemple #1
0
        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");
                }
            }
        }