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

Question

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();

Raja T · 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 existing column 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 jangir · Answer

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 T · Answer

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 jangir · Answer

hi raja int Amount = Amount + Convert.ToInt32(txtAmut.Text) ; where Amount is unassigned local variable. what can i do??

Raja T · Answer

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(UpdateQuerycon); cmd1.ExecuteNonQuery();