private void button1_Click(object sender, EventArgs e) { if (dataGridView1.SelectedCells.Count >= 1) { OleDbCommand cmdBillClear = new OleDbCommand("update bill set billprint='N'", con); cmdBillClear.Parameters.Add("@billno", OleDbType.VarChar, 100).Value = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[0].Value.ToString(); if (con.State == ConnectionState.Closed) { con.Open(); } cmdBillClear.ExecuteNonQuery(); cmdBillClear.Parameters.Clear(); cmdBillClear.Dispose(); OleDbCommand cmdBillYes = new OleDbCommand("update bill set billprint='Y' WHERE billno=@billno", con); cmdBillYes.Parameters.Add("@billno", OleDbType.Integer).Value = Convert.ToInt32(dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[0].Value); if (con.State == ConnectionState.Closed) { con.Open(); } cmdBillYes.ExecuteNonQuery(); cmdBillYes.Parameters.Clear(); cmdBillYes.Dispose(); con.Close(); Form cffrmReports = new frmReports(); cffrmReports.Show(); } else { MessageBox.Show("Select Any Record"); } }
private void button4_Click(object sender, EventArgs e) { if (dataGridView1.SelectedCells.Count >= 1) { try { OleDbCommand cmdBillClear = new OleDbCommand("update bill set billprint='N'", con); //cmdBillClear.Parameters.Add("@billno", OleDbType.VarChar, 100).Value = "441818"; if (con.State == ConnectionState.Closed) { con.Open(); } cmdBillClear.ExecuteNonQuery(); cmdBillClear.Parameters.Clear(); cmdBillClear.Dispose(); //OleDbDataAdapter adcount = new OleDbDataAdapter("Select * from bill where billno=@billno and billtype=@billtype", con); //adcount.SelectCommand.Parameters.Add("@billno", OleDbType.Integer).Value = Convert.ToInt32(textBox1.Text); //adcount.SelectCommand.Parameters.Add("@billtype", OleDbType.VarChar, 100).Value = "final"; //DataSet dscount = new DataSet(); //adcount.Fill(dscount); //String count = dscount.Tables[0].Rows.Count.ToString(); //count = (23 - Convert.ToInt32(count)).ToString(); ////MessageBox.Show(count); //OleDbCommand cmdupdatebillno = new OleDbCommand("update bill set billno=@billno where cname='AAA' and discount<=@discount", con); //cmdupdatebillno.Parameters.Add("@billno", OleDbType.VarChar, 100).Value = textBox1.Text; //cmdupdatebillno.Parameters.Add("@discount", OleDbType.Integer).Value = Convert.ToInt32(count); //if (con.State == ConnectionState.Closed) //{ // con.Open(); //} //cmdupdatebillno.ExecuteNonQuery(); //cmdupdatebillno.Parameters.Clear(); //cmdupdatebillno.Dispose(); OleDbCommand cmdBillYes = new OleDbCommand("update bill set billprint='Y' WHERE billno=@billno", con); cmdBillYes.Parameters.Add("@Billno", OleDbType.Integer).Value = Convert.ToInt32(0 + textBox1.Text); if (con.State == ConnectionState.Closed) { con.Open(); } cmdBillYes.ExecuteNonQuery(); cmdBillYes.Parameters.Clear(); cmdBillYes.Dispose(); con.Close(); Form cffrmReports = new frmReports(); cffrmReports.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void button3_Click(object sender, EventArgs e) { try { String str = Microsoft.VisualBasic.Interaction.InputBox("Enter Bill No.", "Print Bill", "61", 500, 300); if (str != "") { OleDbCommand cmdBillClear = new OleDbCommand("update bill set billprint='N'", con); cmdBillClear.Parameters.Add("@billno", OleDbType.VarChar, 100).Value = str; if (con.State == ConnectionState.Closed) { con.Open(); } cmdBillClear.ExecuteNonQuery(); cmdBillClear.Parameters.Clear(); cmdBillClear.Dispose(); OleDbCommand cmdBillYes = new OleDbCommand("update bill set billprint='Y' WHERE billno=@billno", con); cmdBillYes.Parameters.Add("@billno", OleDbType.VarChar, 100).Value = str; if (con.State == ConnectionState.Closed) { con.Open(); } cmdBillYes.ExecuteNonQuery(); cmdBillYes.Parameters.Clear(); cmdBillYes.Dispose(); con.Close(); Form cffrmReports = new frmReports(); cffrmReports.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }