private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { string colName = dataGridView1.Columns[e.ColumnIndex].Name; if (colName == "colSelect") { if (slist.txtRefNo.Text == string.Empty) { MessageBox.Show("Please enter reference no", stitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); slist.txtRefNo.Focus(); return; } if (slist.txtBy.Text == string.Empty) { MessageBox.Show("Please enter stock in by", stitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); slist.txtRefNo.Focus(); return; } if (MessageBox.Show("Add this item?", stitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { cn.Open(); cm = new SQLiteCommand("insert into tblstockin (refno, pcode, qty, sdate, stockinby) values (@refno, @pcode, @qty, @sdate, @stockinby)", cn); cm.Parameters.AddWithValue("@refno", slist.txtRefNo.Text); cm.Parameters.AddWithValue("@pcode", dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()); cm.Parameters.AddWithValue("@qty", Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[3].Value)); cm.Parameters.AddWithValue("@sdate", slist.dt1.Value.ToString("yyyy-MM-dd HH:mm:ss")); cm.Parameters.AddWithValue("@stockinby", slist.txtBy.Text); cm.ExecuteNonQuery(); cn.Close(); MessageBox.Show("Successfully added!", stitle, MessageBoxButtons.OK, MessageBoxIcon.Information); slist.LoadStockIn(); } } }
private void btnStockIn_Click(object sender, System.EventArgs e) { frmStockIn frm = new frmStockIn(); frm.TopLevel = false; panel4.Controls.Add(frm); frm.BringToFront(); frm.Show(); frm.LoadStockIn(); }