Update values from one column in same table

Guest User

5y696

THis Is My Code Please Edite This Code

3 Replies

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

Arnab Mukherjee5y ago
Replace the below query with your insert statement in 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
0
Guest User5y ago
1 id = 20 than replace to 10 any value replace 1 coulums need not new one
0
Arnab Mukherjee5y ago
Hi, Can you please explain what is the issue here ? Is your existing row value is updated with new value instade of adding a new row ? Please delete your table and create again and try with the below code.
SqlConnection sqlcon = new SqlConnection();
           SqlCommand cmd = null;
           sqlcon.ConnectionString = @"Data Source=DESKTOP-HGN1TR4\SQLEXPRESS;Initial Catalog=ExampleDB;Integrated Security=True";  //Replace your data source here
           cmd = new SqlCommand("insert into tbl_sinking(CHARG) values (@charg)", sqlcon);
           sqlcon.Open();
           cmd.Parameters.AddWithValue("@charg",value);
           cmd.ExecuteNonQuery();
           sqlcon.Close();
The output will be like below.
0