Write the following method to return the number of rows affected by the data operation:
CopyCode The Code is as follows: Private int getreturnvalue (string SSTR, string conn ){
Oledbconnection odbconn = accesshelp (conn );
Oledbcommand odbcmd = new oledbcommand (SSTR, odbconn );
Return odbcmd. executenonquery ();
}
Use the following method to call this class:Copy codeThe Code is as follows: public int wsbm (string [] Str ){
Stringbuilder sb = new stringbuilder ();
SB. append ("insert into"). append ("wsbm (ZY, studentname, parentname )");
SB. append ("values (");
SB. append ("'" + STR [0] + "', '" + STR [1] + "', '" + STR [2] + "'");
SB. append (")");
Return getreturnvalue (sb. tostring (), "odbconn ");
}
Send data in this event:Copy codeThe Code is as follows: protected void bttj_click (Object sender, eventargs e ){
String [] SSTR = new string [] {
This. ddlzy. selecteditem. Text,
This. tbname. Text,
This. tbbb. Text,
};
If (Ad. wsbm (SSTR)> 0 ){
Response. Write ("<SCRIPT> alert ('inserted successfully! ') </SCRIPT> ");
}
}
The execution result is as follows. Why ???
How can this benefit be solved ?????