## 1、sql語句返回DataTable ``` /// <summary> /// 返回靜態DataTable /// </summary> /// <param name="sql">sql語句</param> /// <returns>返回dataTable</returns> public static DataTable ExecuteDataTable(string sql) { return SqlHelper.ExecuteDataset(connString, CommandType.Text, sql).Tables[0]; } ``` ## 用法 ``` DataTable dt = SqlEasy.ExecuteDataTable("select * from sys_users"); ``` ## 2、sql語句參數化返回DataTable ``` /// <summary> /// sql參數化查詢 /// </summary> /// <param name="sql">sql語句帶如KeyId等參數</param> /// <param name="para">sql參數如new SqlParameter("@KeyId", "9"),</param> /// <returns>返回datatable</returns> public static DataTable ExecuteDataTable(string sql, params SqlParameter[] para) { return SqlHelper.ExecuteDataset(connString, CommandType.Text, sql, para).Tables[0]; } public static DataTable ExecuteDataTable(string connectionString, string sql, params SqlParameter[] para) { return SqlHelper.ExecuteDataset(connectionString, CommandType.Text, sql, para).Tables[0]; } ``` ## 用法 ``` //sql參數化查詢 SqlParameter[] paras = new SqlParameter[]{ new SqlParameter("@KeyId", "9"), new SqlParameter("@username", "admin"), }; dt = SqlEasy.ExecuteDataTable("select * from sys_users where keyid=@KeyId", paras); Response.Write(JSONhelper.DataTableToJSON(dt)); ``` ## 3、執行SQL語句返回影響的行數 ``` /// <summary> /// 執行Sql語句 /// </summary> /// <param name="sql">sql語句</param> /// <returns>返回影響的行數</returns> public static int ExecuteNonQuery(string sql) { return SqlHelper.ExecuteNonQuery(connString, CommandType.Text, sql); } ``` ## 用法 ``` int k = SqlEasy.ExecuteNonQuery("update sys_users set qq='1000999' "); Response.Write(k); ``` ## 4、參數化執行sql語句返回影響的行數 ``` /// <summary> /// 參數化執行SQL語句返回影響的函數 /// </summary> /// <param name="sql"></param> /// <param name="para"></param> /// <returns></returns> public static int ExecuteNonQuery(string sql, params SqlParameter[] para) { return SqlHelper.ExecuteNonQuery(connString, CommandType.Text, sql, para); } ``` ## 用法 ``` //sql參數化查詢 SqlParameter[] paras = new SqlParameter[]{ new SqlParameter("@KeyId", "9"), new SqlParameter("@username", "admin"), new SqlParameter("@qq", "229229"), }; int k = SqlEasy.ExecuteNonQuery("update sys_users set qq=@qq", paras); Response.Write(k); ``` ## 5、自建數據庫連接 參數化執行SQL語句返回影響的行數 ``` /// <summary> /// 自建數據庫連接 參數化執行SQL語句返回影響的行數 /// </summary> /// <param name="connectionString">數據庫連接</param> /// <param name="sql">sql語句</param> /// <param name="para">sql參數</param> /// <returns>返回int影響的行數</returns> public static int ExecuteNonQuery(string connectionString, string sql, params SqlParameter[] para) { return SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql, para); } ``` ## 用法 ``` SqlParameter[] paras = new SqlParameter[]{ new SqlParameter("@KeyId", "9"), new SqlParameter("@username", "admin"), new SqlParameter("@qq", "229229"), }; string connectionString = "server=.;uid=sa;pwd=sa12we34;database=No1";//自建的數據庫連接 int k = SqlEasy.ExecuteNonQuery(connectionString,"update sys_users set qq=@qq", paras); Response.Write(k); ```