private readonly static string strConn = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
/// <summary>
/// 有参数的添加、删除、修改
/// </summary>
/// <returns></returns>
public static int MyExecuteNonQuery(string sql, SqlParameter[] sqlpara)
{
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand sqlCom = new SqlCommand(sql, conn))
{
sqlCom.Parameters.AddRange(sqlpara);
conn.Open();
int i = sqlCom.ExecuteNonQuery();
return i;
}
}
}
/// <summary>
/// 有参数查询、无参数查询
/// </summary>
/// <param name="sql"></param>
/// <param name="sqlpara"></param>
/// <returns></returns>
public static DataTable MySelect(string sql, SqlParameter[] sqlpara)
{
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlDataAdapter sqlCom = new SqlDataAdapter(sql, conn))
{
sqlCom.SelectCommand.Parameters.AddRange(sqlpara);
DataTable dt = new DataTable();
sqlCom.Fill(dt);
return dt;
}
}
}
public static DataTable MySelect(string sql)
{
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlDataAdapter sqlCom = new SqlDataAdapter(sql, conn))
{
DataTable dt = new DataTable();
sqlCom.Fill(dt);
return dt;
}
}
}