i want to show messagebox sum row/record with messagebox private void bsave_Click(object sender, EventArgs e) { string save = string.Format("Insert into ShippingCompany([ShippingCompanyCode],[ShippingCompanyName],[CurenccyCode],[ActiveStatus],[CreateBy],[CreateDate],[modifiedBy],[modifiedDate])values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", t1.Text, t2.Text, t3.Text, t4.Text, t5.Text, DateTime.Now.ToString("yyyy-mm-DD" + "HH:mm:ss"), t7.Text, DateTime.Now.ToString("yyyy-mm-DD" + "HH:mm:ss")); SqlConnection con = new SqlConnection(dikonek); con.Open(); SqlCommand cmd = new SqlCommand(save, con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("?");

how to create messagebox if save record success with sum record exemple string save=string.format("insert into quantity([input])values('{0}')",texbox1.tex); sqlconection con new sqlconection(); con.open(); sqlcommend cmd = new sqlcommend(); cmd.excutenonQuery(); con.close(); i want to show message=> messagebox.show"(Rcord 10 Item ");

Exemple stetment foreach (DataGridViewRow row in gridControl1.Rows)can't Rows { mailbody += "<tr>"; foreach (DataGridViewCell cell in row.Cells) { mailbody += "<td>" + cell.Value + "</td>";

PrintDocument printdocument1 = new PrintDocument(); String koneksidatabase = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\DatabaseMDB\\DBSALES.mdb"; public Form1() { InitializeComponent(); printDocument1.PrintPage += printDocument1_PrintPage; private void button2_Click(object sender, EventArgs e) { if (TXTBAYAR.Text == "") { MessageBox.Show("Please insert Buy"); return; } for (int i = 0; i < dataGridView2.Rows.Count; i++) { OleDbConnection con = new OleDbConnection(koneksidatabase); OleDbCommand cmd = new OleDbCommand("insert into Sales ([Kode],[Nama Barang],[Harga],[Quantity],[Satuan],[Subtotal]) values (@Column1,@Column2,@Column3,@Column4,@Column5,@Column6)", con); cmd.Parameters.AddWithValue("@Kode", dataGridView2.Rows[i].Cells[0].Value); cmd.Parameters.AddWithValue("@Column2", dataGridView2.Rows[i].Cells[1].Value); cmd.Parameters.AddWithValue("@Column3", dataGridView2.Rows[i].Cells[2].Value); cmd.Parameters.AddWithValue("@Column4", dataGridView2.Rows[i].Cells[3].Value); cmd.Parameters.AddWithValue("@Column5", dataGridView2.Rows[i].Cells[4].Value); cmd.Parameters.AddWithValue("@Column6", dataGridView2.Rows[i].Cells[5].Value); OleDbConnection con1 = new OleDbConnection(koneksidatabase); OleDbCommand cmd1 = new OleDbCommand("insert into DetailSales ([Kode],[Nama Barang],[Harga],[Quantity],[Satuan],[Subtotal],[Total],[Bayar],[Kembalian],[DateTime]) values (@Column1,@Column2,@Column3,@Column4,@Column5,@Column6,@Total,@Bayar,@Kembalian,@DateTime)", con); cmd1.Parameters.AddWithValue("@Kode", dataGridView2.Rows[i].Cells[0].Value); cmd1.Parameters.AddWithValue("@Column2", dataGridView2.Rows[i].Cells[1].Value); cmd1.Parameters.AddWithValue("@Column3", dataGridView2.Rows[i].Cells[2].Value); cmd1.Parameters.AddWithValue("@Column4", dataGridView2.Rows[i].Cells[3].Value); cmd1.Parameters.AddWithValue("@Column5", dataGridView2.Rows[i].Cells[4].Value); cmd1.Parameters.AddWithValue("@Column6", dataGridView2.Rows[i].Cells[5].Value); cmd1.Parameters.AddWithValue("@Total", txttotal1.Text); cmd1.Par

ihave problem when print datagridview this coding me public partial class Form1 : Form { PrintDocument dokprint = new PrintDocument(); String koneksidatabase = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\DatabaseMDB\\DBSALES.mdb"; public Form1() { InitializeComponent(); printDocument1.PrintPage += printDocument1_PrintPage; ---------------------------------------------------------------------------------- private void button2_Click(object sender, EventArgs e) { if (TXTBAYAR.Text == "") { MessageBox.Show("Please insert Buy"); return; } for (int i = 0; i < dataGridView2.Rows.Count; i++) { OleDbConnection con = new OleDbConnection(koneksidatabase); OleDbCommand cmd = new OleDbCommand("insert into Sales ([Kode],[Nama Barang],[Harga],[Quantity],[Satuan],[Subtotal]) values (@Column1,@Column2,@Column3,@Column4,@Column5,@Column6)", con); cmd.Parameters.AddWithValue("@Kode", dataGridView2.Rows[i].Cells[0].Value); cmd.Parameters.AddWithValue("@Column2", dataGridView2.Rows[i].Cells[1].Value); cmd.Parameters.AddWithValue("@Column3", dataGridView2.Rows[i].Cells[2].Value); cmd.Parameters.AddWithValue("@Column4", dataGridView2.Rows[i].Cells[3].Value); cmd.Parameters.AddWithValue("@Column5", dataGridView2.Rows[i].Cells[4].Value); cmd.Parameters.AddWithValue("@Column6", dataGridView2.Rows[i].Cells[5].Value); OleDbConnection con1 = new OleDbConnection(koneksidatabase); OleDbCommand cmd1 = new OleDbCommand("insert into DetailSales ([Kode],[Nama Barang],[Harga],[Quantity],[Satuan],[Subtotal],[Total],[Bayar],[Kembalian],[DateTime]) values (@Column1,@Column2,@Column3,@Column4,@Column5,@Column6,@Total,@Bayar,@Kembalian,@DateTime)", con); cmd1.Parameters.AddWithValue("@Kode", dataGridView2.Rows[i].Cells[0].Value); cmd1.Parameters.AddWithValue("@Column2", dataGridView2.Rows[i].Cells[1].Value); cmd1.Parameters.AddWithValue("@Column3", dataGridView2.Rows[i].Cells[2].Value); cmd1.Parameters.AddWithValue("@Column4", dataGridView2.Rows[i].Cells[3].Value); cmd1.Parameters.AddWithValue("@Column5", dataGridView2.Rows[i].Cells[4].Value); cmd1.Parameters.AddWi