private void cmdSave_Click(object sender, EventArgs e)
{
//dbcon.Open();
try
{
dbcon.Open();
SqlCommand chkID = new SqlCommand("Select ReceiveID from PolicyReceive where ReceiveID='" + txtRID.Text + "'", dbcon);
string result = (string)chkID.ExecuteScalar();
dbcon.Close();
if (txtRID.Text == "")
{
MessageBox.Show("Information Empty", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == txtRID.Text)
{//update data
for (int item = 0; item <= dataGridView.Rows.Count - 1; item++)
{
cmd = new SqlCommand("UPDATE PolicyReceive SET ReceiveDate=@ReceiveDate,ReceiveType=@ReceiveType,ReceiveFrom=@ReceiveFrom,MobileNo=@MobileNo,FromZone=@FromZone,PolicyNo=@PolicyNo,PolicyType=@PolicyType,Remarks=@Remarks WHERE ReceiveID=@ReceiveID", dbcon);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@PolicyNo", dataGridView.Rows[item].Cells[1].Value);
cmd.Parameters.AddWithValue("@PolicyType", dataGridView.Rows[item].Cells[2].Value);
cmd.Parameters.AddWithValue("@ReceiveID", txtRID.Text);
cmd.Parameters.AddWithValue("@ReceiveDate", txtRDate.Text);
cmd.Parameters.AddWithValue("@ReceiveType", cmbRType.Text);
cmd.Parameters.AddWithValue("@ReceiveFrom", txtRByName.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtMobile.Text);
cmd.Parameters.AddWithValue("@FromZone", cmbFZone.Text);
cmd.Parameters.AddWithValue("@Remarks", txtRemarks.Text);
dbcon.Open();
cmd.ExecuteNonQuery();
dbcon.Close();
dbcon.Close();
}
MessageBox.Show("Update DATA OK");
//dbcon.Close();
listView.Items.Clear();
dataView();
dbcon.Close();
}
else
{
if (txtRID.Text == "")
{
MessageBox.Show("Plese Given Information", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtPolicyNo.Focus();
}
else
{//Insert Data
for (int item = 0; item <= dataGridView.Rows.Count - 1; item++)
{
cmd = new SqlCommand("INSERT INTO PolicyReceive(ReceiveID,ReceiveDate,ReceiveType,ReceiveFrom,MobileNo,FromZone,PolicyNo,PolicyType,Remarks) values (@ReceiveID,@ReceiveDate,@ReceiveType,@ReceiveFrom,@MobileNo,@FromZone,@PolicyNo,@PolicyType,@Remarks)", dbcon);
cmd.Parameters.AddWithValue("@PolicyNo", dataGridView.Rows[item].Cells[1].Value);
cmd.Parameters.AddWithValue("@PolicyType", dataGridView.Rows[item].Cells[2].Value);
cmd.Parameters.AddWithValue("@ReceiveID", txtRID.Text);
cmd.Parameters.AddWithValue("@ReceiveDate", txtRDate.Text);
cmd.Parameters.AddWithValue("@ReceiveType", cmbRType.Text);
cmd.Parameters.AddWithValue("@ReceiveFrom", txtRByName.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtMobile.Text);
cmd.Parameters.AddWithValue("@FromZone", cmbFZone.Text);
cmd.Parameters.AddWithValue("@Remarks", txtRemarks.Text);
dbcon.Open();
cmd.ExecuteNonQuery();
dbcon.Close();
}
MessageBox.Show("INSER DATA OK");
//dbcon.Close();
listView.Items.Clear();
dataView();
dbcon.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dbcon.Close();
}
I am facing the problem:
There is no problem in inserting new data, but the data edit and edit state, if you insert new data, the previous data becomes the new data.
what I want to do,
1. First, it will check through the ID, if the ID is the same, then it will edit and if it is a new ID, it will insert the data.
2. I inserted the data whose id is 7. This ID 7 has many policies and types. In this way I inserted more Kisu data. Now I will edit the policy on ID 7 and add some more policies. How do I do this?
Nahid HasanPosted Apr 26, 2023, 6:27 PM
Thank you very much SIR,
Now I am facing some problem, when I edit a policy and save it, the old policy remains and the edited policy is also added.
For example, IDNo: PD-08 has these 3 policies 13600007854, 1360000985, 1360000652, now I edited 1360000985 and gave this policy as 1360004521 and after saving then I see total 4 policies in ID No: PD-08, 1360000854, 1360000985, 1360000652 And 1360004521. Please help me sir
Amit MohantyPosted Apr 26, 2023, 4:42 AM
Try this.