2,537
社区成员
发帖
与我相关
我的任务
分享
void Start()
{
//连接SQL
string s = @String.Format("server = {0};database = {1};uid = {2};pwd = {3};", host, databaseName, ID, pwd); ;
connection = new SqlConnection(s);
connection.Open();
}
//查询结果以DataSet类返回
public DataSet sqlCheck(string something,string tablename)
{
string sentense = " select "+something+" from "+tablename;
SqlDataAdapter _adapter = new SqlDataAdapter(sentense, connection);
DataSet ds = new DataSet();
_adapter.Fill(ds, tablename);
return ds;
}
public DataSet sqlInsert(string values,string tablename)
{
string sentense = " insert into " + tablename + " values (" + values + ")";
SqlDataAdapter _adapter = new SqlDataAdapter(sentense, connection);
DataSet ds = new DataSet();
_adapter.Fill(ds, tablename);
return ds;
}
connection = new SqlConnection(s);
connection.Open();
这段代码封装到sqlCheck()、sqlInsert()那些方法里面,也就是每次调用sql的增删改查方法都要重新声明一个sqlConnection对象,不这样做的话,就会报空指针。
希望对你还有帮助!