Loading

how can update my column valu with add new vale in old value

how can update my column valu with add new vale in old value

vinod jangir

11y873Visual Basic .NET

i update Amount = Amount + txtAmut.Text

how can do?????

if (con.State == ConnectionState.Closed)

con.Open();

string UpdateQuery = "UPDATE Student SET DueDate= '" + txtNewDat.Text + "' WHERE Admission_ID= " + labstuid.Text + Environment.NewLine +

"UPDATE FeeDeposit SET Amount= '" + txtAmut.Text + "' WHERE Admission_ID= " + labstuid.Text;

SqlCommand cmd1 = new SqlCommand(UpdateQuery,con);

cmd1.ExecuteNonQuery();

5 Replies

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

Raja T11y ago
Accepted answer
Hi Vinodh,

int Amount = Amount + Convert.ToInt32(txtAmut.Text);
Amount is existing column i update the value.
like Amount=200 i add 100 then update Amount=300

Here Amount is existingcolumn you means amount 200 in table right ? So you can get amount column value from db/table and after that you can add like

Amount = Amount + Convert.ToInt32(txtAmut.Text);
Then update data

Amount = Amount + Convert.ToInt32(txtAmut.Text);
vinod jangir11y ago
hi raja

int Amount = Amount + Convert.ToInt32(txtAmut.Text);
Amount is existing column i update the value.
like Amount=200 i add 100 then update Amount=300
what can i do
Raja T11y ago
Hi vinod, Please tel me which one column value and which one new value Please confirm in your code?

int Amount = Amount1 + Convert.ToInt32(txtAmut.Text);
Here Amount1 -> is one column value
Convert.ToInt32(txtAmut.Text)-> is one new value
vinod jangir11y ago
hi raja

int Amount = Amount + Convert.ToInt32(txtAmut.Text);
where Amount is unassigned local variable.
what can i do??
Raja T11y ago
Hi Vinodh, Try like

int Amount = Amount + Convert.ToInt32(txtAmut.Text);

if (con.State == ConnectionState.Closed)
con.Open();
string UpdateQuery = "UPDATE Student SET DueDate= '" + txtNewDat.Text + "' WHERE Admission_ID= " + labstuid.Text + Environment.NewLine +
"UPDATE FeeDeposit SET Amount= '" + Amount "' WHERE Admission_ID= " + labstuid.Text;
SqlCommand cmd1 = new SqlCommand(UpdateQuery,con);
cmd1.ExecuteNonQuery();