{
public static string connString = "server=阳;database=11;Integrated Secrity=ture";
public static SqlConnection conn = null;
public static void Initconnection()
{
conn = new SqlConnection(connString);
conn.Open();
}
public static DataSet GetDataSet(string sqlstring)
{
Initconnection();
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sqlstring, conn);
adapter.Fill(ds);
conn.Close();
conn.Dispose();
return ds;
}
public static SqlDataReader GetSqlDataReader(string sqlstring)
{
Initconnection();
SqlCommand cmd = new SqlCommand(sqlstring, conn);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
public static bool ExecuteNonQuery(string sqlStr)
{
Initconnection();
SqlCommand cmd = new SqlCommand(sqlStr,conn);
int result=cmd.ExecuteNonQuery();
conn.Close();
return result >0;
}
public static object ExecuteScalar(string sqlStr)
{
Initconnection();
SqlCommand cmd = new SqlCommand(sqlStr, conn);
object result = cmd.ExecuteScalar();
conn.Close();
return result;
}
}