使用函数传递参数来执行数据库操作

usingsystem;

usingsystem.configuration;

usingsystem.data.sqlclient;

usingsystem.data;

usingsystem.collections;

比如：

//打开数据库

转自：动态网制作指南www.knowsky.com

publicstaticsqlconnectionopenconnection()

{

sqlconnectionmysqlconn=newsqlconnection(configurationsettings.appsettings["connstring"]);

try

mysqlconn.open();

}

catch(exceptione)

//rethrowthisexception

throwe;

returnmysqlconn;

//执行sql返回dataset

publicstaticdatasetgetdataset(stringsqlquery)

sqlconnectioncn=dbobject.openconnection();

sqldataadapterda=newsqldataadapter(sqlquery,cn);

datasetds=newdataset();

da.fill(ds);

//releaseresources

da.dispose();

da=null;

cn.close();

cn=null;

returnds;

//执行sql语句

publicstaticvoidexecuteupdatequery(stringsqlquery)

sqlcommandcmd=newsqlcommand();

cmd.commandtext=sqlquery;

cmd.commandtype=commandtype.text;

cmd.connection=cn;

cmd.executenonquery();