以下DBhelper类的Dispose()方法怎么写
public static class DataBaseOperate
{
public static string ConnectDateBase = "server=.\\adcs;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;
}
}