private const string sql = "Data Source=.;Initial Catalog=auto;User=sa;Pwd=sasa";
SqlConnection con = null;
#region 得到command
public SqlCommand getcommand(string str)
{
con = new SqlConnection(sql);
con.Open();
SqlCommand com=new SqlCommand(str,con);
return com;
}
#endregion
#region 得到Datareader方法
public SqlDataReader getread(string str)
{
// SqlCommand com = getcommand(str);
// SqlDataReader read = com.ExecuteReader(CommandBehavior.CloseConnection);
return getcommand(str).ExecuteReader(CommandBehavior.CloseConnection);
}
#endregion
#region 得到ExecuteNonQuery方法
public int getnonquety(string str)
{
// SqlCommand com = getcommand(str);
//int result = com.ExecuteNonQuery();
return getcommand(str).ExecuteNonQuery();
}
#endregion
#region 得到ExecuteScalar方法
public int getscalar(string str)
{
// SqlCommand com = getcommand(str);
//int result = (int)com.ExecuteScalar();
return (int)getcommand(str).ExecuteScalar();
}
#endregion
