求教一个问题DBHelper类的问题 高手赐教
以下DBHelper的Dispose()方法怎么写 高手帮下忙谢谢
public static class DataBaseOperate
{
public static string ConnectDateBase = "server=.\\admin;database=CompanyMessage;uid=sa;pwd=";
public static int Excute(string sql) {
int i = 0;
using (SqlConnection con = new SqlConnection(ConnectDateBase)) {
con.Open();
SqlCommand cmd = new SqlCommand(sql,con);
i = cmd.ExecuteNonQuery();
}
return i;
}
public static SqlDataReader Search(string sql)
{
SqlConnection con = new SqlConnection(ConnectDateBase);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
public static Object Excutescalar(string sql) {
Object i = 0;
using (SqlConnection con = new SqlConnection(ConnectDateBase))
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
i = cmd.ExecuteScalar();
}
return i;
}