c# - Submit button not Firing -


i have webform app has submit button store sql server. here code it.

try         {             sqlconnection insc = new sqlconnection(@"data source=2011-goa-rcc3\sqlexpress;initial catalog=s.i.-dbase-web;integrated security=true");             insc.open();             sqlcommand cmnd = new sqlcommand();             cmnd.connection = insc;             cmnd.commandtext = "insert global_dcr(sr_no, comp_id, br_code, br_name, region, node, comp_date, comp_time, wan_ip, network_type, circuit_type, ciruit_id, mlln_id, cbs_atm_tba, link_stat, call_cat, problem_des, backup_work, status, resolved_date, resolved_time, total_downtime, bsnl_details, docket_id, action_owner, remark) values(@sr_no, @comp_id, @br_code, @br_name, @region, @node, @comp_date, @comp_time, @wan_ip, @network_type, @circuit_type, @ciruit_id, @mlln_id, @cbs_atm_tba, @link_stat, @call_cat, @problem_des, @backup_work, @status, @resolved_date, @resolved_time, @total_downtime, @bsnl_details, @docket_id, @action_owner, @remark)";             cmnd.parameters.addwithvalue("@sr_no", label2.text);             cmnd.parameters.addwithvalue("@comp_id", label4.text);             cmnd.parameters.addwithvalue("@comp_date", textbox1.text);             cmnd.parameters.addwithvalue("@comp_time", textbox2.text);             cmnd.parameters.addwithvalue("@br_code", textbox3.text);             cmnd.parameters.addwithvalue("@br_name", textbox4.text);                             cmnd.parameters.addwithvalue("@node", textbox6.text);             cmnd.parameters.addwithvalue("@wan_ip", textbox7.text);             cmnd.parameters.addwithvalue("@network_type", dropdownlist1.selecteditem);             cmnd.parameters.addwithvalue("@circuit_type", dropdownlist2.selecteditem);             cmnd.parameters.addwithvalue("@circuit_id", textbox10.text);             cmnd.parameters.addwithvalue("@mlln_id", textbox11.text);             cmnd.parameters.addwithvalue("@cbs_atm_tba", textbox12.text);             cmnd.parameters.addwithvalue("@link_stat", textbox13.text);             cmnd.parameters.addwithvalue("@call_cat", textbox14.text);             cmnd.parameters.addwithvalue("@problem_des", textbox15.text);                            cmnd.parameters.addwithvalue("@docket_id", textbox18.text);             cmnd.parameters.addwithvalue("@bsnl_details", textbox19.text);             cmnd.parameters.addwithvalue("@action_owner", textbox20.text);             cmnd.parameters.addwithvalue("@remarks", textbox21.text);              if (request.cookies["region"] != null)             {                 textbox5.text = server.htmlencode(request.cookies["region"].value);//read cookie              }              //{             //    string a3 = "not happening bro1";             //    clientscript.registerstartupscript(this.gettype(), "myalert", "alert('" + a3 + "');", true);             //}            // button execution breaks @ step. no error thrown              //to set backup             if (radiobuttonlist1.selectedvalue == "yes")             {                 string yes = "yes";                 cmnd.parameters.addwithvalue("@backup_work", yes);             }             if (radiobuttonlist1.selectedvalue == "no")             {                 string no = "no";                 cmnd.parameters.addwithvalue("@backup_work", no);             }             //{             //    string a2 = "not happening bro2";             //    clientscript.registerstartupscript(this.gettype(), "myalert", "alert('" + a2 + "');", true);             //}              //status             if (radiobuttonlist2.selectedvalue == "resolved")             {                 string res = "resolved";                 cmnd.parameters.addwithvalue("@status", res);                 cmnd.parameters.addwithvalue("@resolved_date", textbox16.text);                 cmnd.parameters.addwithvalue("@resolved_time", textbox17.text);                 cmnd.parameters.addwithvalue("@total_downtime", label25.text + ":" + label26.text + ":" + label27.text);//store 3 values in single table              }             if (radiobuttonlist2.selectedvalue == "pending")             {                 string pen = "pending";                 cmnd.parameters.addwithvalue("@status", pen);                 cmnd.parameters.addwithvalue("@resolved_date", pen);                 cmnd.parameters.addwithvalue("@resolved_time", pen);                 cmnd.parameters.addwithvalue("@total_downtime", pen);             }             //session["comp_id"] = label4.text;              int mn = cmnd.executenonquery();             if (mn > 0)             {                 string ab = "incident incident id";                 string abc = convert.tostring(label4.text);                 clientscript.registerstartupscript(this.gettype(), "myalert", "alert('" + ab + abc + "');", true);              }             else             {                 string sw = "unable create incident";                 clientscript.registerstartupscript(this.gettype(), "myalert", "alert('" + sw + "');", true);             }            }         catch (exception s)         {             clientscript.registerstartupscript(this.gettype(), "myalert", "alert('" + s  + "');", true);         }     } 

the problem code doesnot work. once fill relevant data on page, , click submit button not save database. help.

problem : if region cookie null not inserting default value.

solution : need add default value if region cookie becomes null. need add else block store default value asbelow

try this:

if (request.cookies["region"] != null) {     textbox5.text = server.htmlencode(request.cookies["region"].value);//read cookie } else{     textbox5.text = string.empty; } 

edit:

try this:

if (radiobuttonlist2.selectedvalue.tostring().trim().equals("pending")) 

Comments

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

javascript - jQuery show full size image on click -