<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ## 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); ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看