Hello Team, In my window application, tried updating data from the window form into the database and this is the error that is poping up, kindly assist.
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Please confirm if you want to update item bought on credit?", "UPDATE", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
con.Open();
cmd = new SqlCommand("update tblOnCredit SET CDate=@Cdate,CDescription=@Cdescription,Qty=@Cqty,CSellingPrice=@CsellingPrice, CAmountPaid=@CamountPaid, CBalance=@Cbalance,CustomersName=@customername,Phone=@phone where CreditId like '" + id + "'", con);
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@Cdate", dtStockInDate.Value.ToString("dd-MM-yyyy"));
cmd.Parameters.AddWithValue("@Cdescription", txtProduct.Text);
cmd.Parameters.AddWithValue("@Cqty", txtQuantity.Text);
cmd.Parameters.AddWithValue("@CsellingPrice", txtSellingPrice);
cmd.Parameters.AddWithValue("@CamountPaid", txtAmountPaid.Text);
cmd.Parameters.AddWithValue("@Cbalance", txtBalance.Text);
cmd.Parameters.AddWithValue("@customername", txtCustomersName.Text);
cmd.Parameters.AddWithValue("@phone", txtPhoneNo.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("This record has been successfully updated!", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
}
}
catch (Exception ex)
{
con.Close();
MessageBox.Show(ex.Message);
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.CurrentCell.OwningColumn.Name == "dgvEdit")
{
frmOnCreditSalesAdd frm = new frmOnCreditSalesAdd();
frm.btnAdd.Enabled = false;
frm.btnUpdate.Enabled = true;
frm.id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["dgvID"].Value);
frm.dtStockInDate.Text = Convert.ToString(dataGridView1.CurrentRow.Cells["dgvDate"].Value);
frm.txtProduct.Text = Convert.ToString(dataGridView1.CurrentRow.Cells["dgvDescription"].Value);
frm.txtSellingPrice.Text = Convert.ToDecimal(dataGridView1.CurrentRow.Cells["dgvSellingPrice"].Value).ToString("#0.00");
frm.txtQuantity.Text = Convert.ToInt32(dataGridView1.CurrentRow.Cells["dgvQty"].Value).ToString();
frm.txtAmountPaid.Text = Convert.ToDecimal(dataGridView1.CurrentRow.Cells["dgvAmountPaid"].Value).ToString("#0.00");
frm.txtBalance.Text = Convert.ToString(dataGridView1.CurrentRow.Cells["dgvBalance"].Value);
frm.txtCustomersName.Text = Convert.ToString(dataGridView1.CurrentRow.Cells["dgvCustomerName"].Value);
frm.txtPhoneNo.Text = Convert.ToString(dataGridView1.CurrentRow.Cells["dgvPhoneNo"].Value);
MainClass.BlurBackground(frm);
LoadBoughtOnCreditRecord();
}
else if (dataGridView1.CurrentCell.OwningColumn.Name == "dgvDelete")
{
if (MessageBox.Show("Please confirm if you want to Delete this record?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
con.Open();
cmd = new SqlCommand("delete from tblOnCredit where CreditId like '" + dataGridView1.Rows[e.RowIndex].Cells["dgvID"].Value.ToString() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("This record has been successfully deleted!", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadBoughtOnCreditRecord();
}
}
}