Asp.Net------------sqlparameter

分页列表使用

前台代码：
 <div>
            <asp:Repeater ID="rptUserList" runat="server">
                <HeaderTemplate>
                    <table>
                        <tr>
                            <td>
                                <input type="checkbox" id="chkAll" runat="server" name="全选/不选" onclick="checkAll(this);" /></td>
                            <td>
                                用户id</td>
                            <td>
                                用户名</td>
                            <td>
                                用户性别</td>
                            <td>
                                用户权限组
                            </td>
                            <td>
                                删除状态
                            </td>
                            <td>
                                删除用户</td>
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        <td>
                            <asp:CheckBox ID="chkSel" runat="server" /></td>
                        <td>
                            <%# Eval("Id") %>
                        </td>
                        <td>
                            <%# Eval("UserName") %>
                        </td>
                        <td>
                            <%# Eval("Gender") %>
                        </td>
                        <td>
                            <%# Eval("GroupId") %>
                        </td>
                        <td>
                            <%# Eval("IsDelete") %>
                        </td>
                        <td>
                            <asp:ImageButton ID="btnToWishList" runat="server" AlternateText="Move to wish list"
                                CausesValidation="false" CommandArgument='<%# Eval("Id") %>' CommandName="del"
                                ImageUrl="~/Comm_Images/button-wishlist.gif"  ToolTip="Deltet sh list" />
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            <webdiyer:AspNetPager ID="AspNetPager2" runat="server" Width="100%" UrlPaging="True"
                SubmitButtonText="跳 转" AlwaysShow="True" ShowCustomInfoSection="Left" NumericButtonTextFormatString="[{0}]"
                PagingButtonSpacing="4px" SubmitButtonStyle="border:1px solid #000000;height:20px;width:50px"
                InputBoxStyle="border:1px #000000 solid;text-align:center" HorizontalAlign="Right"
                TextAfterInputBox="页 " TextBeforeInputBox="第" ShowInputBox="Always" PrevPageText="上一页 "
                NumericButtonCount="5" NextPageText=" 下一页" FirstPageText="首页 " LastPageText=" 尾页"
                BorderColor="#FFFFC0" OnPageChanged="AspNetPager1_PageChanged"></webdiyer:AspNetPager>
        </div>
后台代码：
 protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!Page.IsPostBack)
        ...{
            AspNetPager2.CurrentPageIndex = 1;
            AspNetPager2.PageSize = 3;
            BindRptUserList();
        }
    }
    private void BindRptUserList()
    ...{
        int RecordCount = 0;
        this.rptUserList.DataSource = GetUserList(AspNetPager2.CurrentPageIndex, AspNetPager2.PageSize, out RecordCount);
        this.rptUserList.DataBind();
        AspNetPager2.RecordCount = RecordCount;
        Response.Write(RecordCount);
    }
    private DataTable GetUserList(int pageIndex, int pageSize, out int recordCount)
    ...{
        recordCount = 0;
        SqlParameter[] myparams = new SqlParameter[]...{
                new SqlParameter("@PageIndex",SqlDbType.Int),
                new SqlParameter("@PageSize",SqlDbType.Int),
                new SqlParameter("@RecordCount",SqlDbType.Int)
        };
        myparams[0].Value = pageIndex;
        myparams[1].Value = pageSize;
        myparams[2].Direction = ParameterDirection.Output;
        DataTable dt = SqlHelper.ExecuteTable(SqlHelper.CONN_STRING_Agriculture, CommandType.StoredProcedure, "p_User_GetUserListPager", myparams);
        if (dt.Rows.Count > 0)
        ...{
            recordCount = Convert.ToInt32(myparams[2].Value.ToString());
        }
        return dt;

    }
    protected void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
    ...{
        AspNetPager2.CurrentPageIndex=e.NewPageIndex;
    }

昨天晚上遇到一个问题： 在分页控件 返回总记录时 。总是为Null让我非常的郁闷，怎么找都找不到原因, 

最后单步 发现，问题出现在 sqlhelper 中 把

  public static SqlDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
    {
        SqlDataReader reader;
        SqlCommand cmd = new SqlCommand();
        SqlConnection conn = new SqlConnection(connectionString);
        try
        {
            PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
            SqlDataReader reader2 = cmd.ExecuteReader(CommandBehavior.CloseConnection);
           // cmd.Parameters.Clear();
            reader = reader2;
        }
        catch
        {
            conn.Close();
            throw;
        }
        return reader;
    }

总结下： 学习一样东西，不能心急，要慢慢来，才能看明白问题，只有冷静才能很好的解决问题