c# - Update table record from sqlcommand -

i have situation: in dataentryform have dropdownlist, user selects letter number, , according inserts other related data.

i plan change letter's status in other table choosing in dropdownlist automatically.

i using code:

sqlparameter answertoparam = new sqlparameter("answerto", ansto);  string commandtext = "update incomeletters set incomeletters.docstate_id ='2' income_number=('" + ansto + "' )";  sqlcommand findincomelett = new sqlcommand(commandtext, conn); comm.parameters.add(answertoparam); conn.open();  findincomelett.executenonquery(); comm.executenonquery(); 

unfortunately, result nothing.

server not giving error, , refreshes page it.

in posted code, passing sqlparameter passing value raw data. either of 1 , preferably pass sqlparameter like

        sqlparameter answertoparam = new sqlparameter("answertoparam", ansto);         string commandtext = "update incomeletters set incomeletters.docstate_id = '2' income_number = @answertoparam";         sqlcommand findincomelett = new sqlcommand(commandtext, conn);         findincomelett.parameters.add(answertoparam);         conn.open();         findincomelett.executenonquery(); 

moreover, have 2 sqlcommand object in place , calling 2 executenonquery() on them. correct ... see below

        sqlcommand findincomelett = new sqlcommand(commandtext, conn); --1         comm.parameters.add(answertoparam); --2          conn.open();          findincomelett.executenonquery(); --1         comm.executenonquery(); --2