AST.NET2005连接SQL2008数据库的连库类怎么写
AST.NET2005连接SQL2008数据库的连库类怎么写
我一直用SQL2000的库
public class DBAccess
{
private SqlConnection conn = null;
private string connstring = "server=.;uid=sa;pwd=;database=xlrz";
public DBAccess() { }
public DBAccess(string connstring)
{
this.connstring = connstring;
}
private void openConn()
{
conn = new SqlConnection(connstring);
}
public void closeConn()
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
public int executeSql(string sql)
{
this.openConn();
conn.Open();
int i = 0;
SqlCommand cmd = new SqlCommand(sql, conn);
i = cmd.ExecuteNonQuery();
this.closeConn();
return i;
}
public DataTable searchSql(string sql)
{
this.openConn();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(ds);
return ds.Tables[0];
}
}
怎么编写谢谢