Replace Query Data Save Help Me?

Guest User

5y826

if (msf.Text != "")

{

cmd = new SqlCommand("insert into tbl_sinking(CHARG) values(@charg)", sqlcon);

sqlcon.Open();

cmd.Parameters.AddWithValue("@charg", msf.Text);

cmd.ExecuteNonQuery();

sqlcon.Close();

MessageBox.Show("Record Inserted Successfully");

DisplayData();

ClearData();

}

else

{

MessageBox.Show("Please Provide Details!");

}

this query work 2 insert and replace value in same column

1 column 10 value than replace any value replace For Example 20 than replace to 10

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arnab Mukherjee5y ago
Accepted answer
1. private void btnmonthlysinkingfund_Click(object sender, EventArgs e)
2. {
3. if (msf.Text != "")
4. {
5. cmd = new SqlCommand(@"IF (SELECT COUNT(CHARG) FROM [DBO].[TBL_SINKING]) >0
6. BEGIN
7. UPDATE TBL_SINKING SET CHARG = @charg
8. END
9. ELSE
10. BEGIN
11. INSERT INTO TBL_SINKING(CHARG) VALUES (@charg)
12. END", sqlcon);
13. sqlcon.Open();
14. cmd.Parameters.AddWithValue("@charg", msf.Text);
15. cmd.ExecuteNonQuery();
16. sqlcon.Close();
17. MessageBox.Show("Record Inserted Successfully");
18. DisplayData();
19. ClearData();
20. }
21. else
22. {
23. MessageBox.Show("Please Provide Details!");
24. }
25. }
+2

Arnab Mukherjee5y ago

No problem.

Guest User5y ago

Arnab Mukherjee Thank You Bro You Save My Life

Guest User5y ago

private void btnmonthlysinkingfund_Click(object sender, EventArgs e)
{
if (msf.Text != "")
{
cmd = new SqlCommand("insert into tbl_sinking(CHARG) values(@charg)", sqlcon);
sqlcon.Open();
cmd.Parameters.AddWithValue("@charg", msf.Text);
cmd.ExecuteNonQuery();
sqlcon.Close();
MessageBox.Show("Record Inserted Successfully");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Provide Details!");
}

Use query in this Code

IF (SELECT COUNT(CHARG) FROM [DBO].[TBL_SINKING]) >0
BEGIN
UPDATE TBL_SINKING SET CHARG = @charg
END
ELSE
BEGIN
INSERT INTO TBL_SINKING(C

Guest User5y ago

i want code form USe C# Visual Studio

Arnab Mukherjee5y ago

Just replace your insert statement with below query in your code.

IF (SELECT COUNT(CHARG) FROM [DBO].[TBL_SINKING]) >0
BEGIN
UPDATE TBL_SINKING SET CHARG = @charg
END
ELSE
BEGIN
INSERT INTO TBL_SINKING(CHARG) VALUES (@charg)
END

Guest User5y ago

1 textbox 1 save button

Can U edit in my Query

i will provide my code can u edit this please

iam new here i am try learn this software

if you can help me thankfull to you

private void btnmonthlysinkingfund_Click(object sender, EventArgs e)

{

if (msf.Text != "")

{

cmd = new SqlCommand("insert into tbl_sinking(CHARG) values(@charg)", sqlcon);

sqlcon.Open();

cmd.Parameters.AddWithValue("@charg", msf.Text);

cmd.ExecuteNonQuery();

sqlcon.Close();

MessageBox.Show("Record Inserted Successfully");

DisplayData();

ClearData();

}

else

{

MessageBox.Show("Please Provide Details!");

}

Vinay Singh5y ago

Check for the column value and the apply update query. In your code you have written the update query code to update the value