//Click Confirm button for insert data into database private void btnConfirm_Click(object sender, EventArgs e) { try { if (CheckBarcode() && CheckEmpty() && checkcustomer() && checkcodeasset() && checkdatecode() && checklinecode()) { string recDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt.Clear(); cmd.Clear(); cmd.Append("insert into t_barcode_rec(barcode, model, line, lot, rec_date) "); cmd.Append("values('").Append(txtBarcode.Text).Append("','"); cmd.Append(txtModel.Text).Append("','").Append(txtLine.Text).Append("','"); cmd.Append(txtLot.Text).Append("','").Append(recDate).Append("')"); switch (SQL.sqlExecuteNonQueryState(cmd.ToString(), false)) { case 0: StatusState("Fail", 2); break; case 1: counter++; GetTable(false); StatusState("OK", 0); lbCounter.Text = counter.ToString(); break; case 2: StatusState("Duplicate", 1); MessageBox.Show("Barcode Duplicate", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Warning); break; } } } catch (Exception ex) { StatusState(ex.Message, 2); MessageBox.Show(ex.Message, "Warring"); } txtBarcode.Clear(); txtBarcode.Focus(); }