The previous general class has been written. Next, call and test it in different ways.
Code Mysqlhelp MH = New Mysqlhelp ();
// Clear Data
Mh. runsql ( " Delete from t_user " );
// SQL
Mysqlparameter [] parms = {
New Mysqlparameter ( " ? UID " , Mysqldbtype. varchar, 50 ),
New Mysqlparameter ( " ? PWD " , Mysqldbtype. varchar, 50 ),
New Mysqlparameter ( " ? Name " , Mysqldbtype. varchar, 20 )};
Parms [ 0 ]. Value = " Admin11 " ;
Parms [ 1 ]. Value = " 123 " ;
Parms [ 2 ]. Value = " Bb11 " ;
Mh. runsql ( " Insert into t_user (u_uid, u_pwd, u_name) values (? UID ,? PWD ,? Name) " , Parms );
// Add in Proc Mode
Mysqlparameter [] pparms = {
New Mysqlparameter ( " ? UID " , Mysqldbtype. varchar, 50 ),
New Mysqlparameter ( " ? PWD " , Mysqldbtype. varchar, 20 ),
New Mysqlparameter ( " ? Name " , Mysqldbtype. varchar, 20 )
};
Pparms [ 0 ]. Value = " Admin22 " ;
Pparms [ 1 ]. Value = " 123 " ;
Pparms [ 2 ]. Value = " Bb22 " ;
Mh. runprc ( " Proc_add " , Pparms );
// User Login
Mysqlparameter [] parss = {
New Mysqlparameter ( " ? UID " , Mysqldbtype. varchar, 50 ),
New Mysqlparameter ( " ? PWD " , Mysqldbtype. varchar, 20 ),
New Mysqlparameter ( " ? Back " , Mysqldbtype. int16)
};
Parss [ 2 ]. Direction = Parameterdirection. output;
Parss [ 0 ]. Value = " Admin11 " ;
Parss [ 1 ]. Value = " 123 " ;
Mh. runprc ( " Proc_login " , Parss );
String Back = Parss [ 2 ]. Value. tostring (); // Output Value: 1 is successfully logged on.
// Obtains the user list.
This . Gridview1.datasource = Mh. getdatabyprc ( " Getalluser " );
This . Gridview1.databind ();
What is the difference between MSSQL and MSSQL? Replace @. Of course, different connection drivers may be written differently.