IDC资讯中心
public class dbmanage
{
public dbmanage()
{
//
// todo: 在此处添加构造函数逻辑
//
}
public sqlconnection getconnection()//建立数据库连接
{
sqlconnection cn=new sqlconnection();
cn.connectionstring=system.configuration.configurationsettings.appsettings["conn"];
cn.open();
return cn;
}
public void delid(int intid ,string strtable,sqlconnection cn)
{
sqlcommand deletecmd=new sqlcommand ("delete from "+strtable+" where id="+intid,cn);
deletecmd.executenonquery();
}
public void executesql(string strsql,sqlconnection cn) //执行无返回值的sql命令
{
sqlcommand executecmd=new sqlcommand (strsql,cn);
executecmd.executenonquery();
executecmd.dispose();
}
public void updatetb(string strtbname, string strfieldsname,string strvalue,int intid, sqlconnection cn)
{
sqlcommand updatecmd=new sqlcommand ("update strtbname set "+strfieldsname+"="+strvalue+" where id="+intid.tostring(),cn);
updatecmd.executenonquery();
}
public dataset fillds(string strsql, sqlconnection cn)
{
sqldataadapter filldsadapter=new sqldataadapter(strsql,cn);
filldsadapter.selectcommand.commandtype=commandtype.text ;
dataset ds =new dataset();
filldsadapter.fill(ds);
filldsadapter.dispose();
return ds;
}
public dataset fillds(string strsql, sqlconnection cn,string srctable)
{
sqldataadapter filldsadapter=new sqldataadapter(strsql,cn);
filldsadapter.selectcommand.commandtype=commandtype.text ;
dataset ds =new dataset();
filldsadapter.fill(ds,srctable);
filldsadapter.dispose();
return ds;
}
public string getstring(string strsql,sqlconnection cn)//获取字符串
{
string strgetstring="";
sqldataadapter filldsadapter=new sqldataadapter(strsql,cn);
filldsadapter.selectcommand.commandtype=commandtype.text ;
dataset ds =new dataset();
filldsadapter.fill(ds);
if(ds.tables[0].rows.count==1)
{
strgetstring=ds.tables[0].rows[0][0].tostring();
}
else
{
strgetstring=null;
}
filldsadapter.dispose();
ds.dispose();
return strgetstring;
}
}
