.net sql2000 存储过程 后台调取列表 失效 高分,急~!

问题:
数据库是从sql2005导出的sql2000脚本,导入到sql2000数据库后,后台调用信息的列表显示为空.
数据库换回sql2005以后又正常显示了,
现在因必须使用sql2000数据库,所以如何从程序上或者存储过程上处理这个问题?

sql2000不支持GridView?还是什么原因,如何从程序上或者存储过程上解决呢?

存储过程:
USE [sql2000]
GO

DECLARE @return_value int,
@Total int,
@SQLstr varchar(4000)

SELECT @Total = 30

EXEC @return_value = [dbo].[SqlDataPaging]
@tbName = N'D_News',
@tbFields = N'Title',
@keyFields = N'ID',
@OrderType = '',
@PageSize = 20,
@PageIndex = 5,
@Total = @Total OUTPUT,
@SQLstr = @SQLstr OUTPUT

SELECT @Total as N'@Total',
@SQLstr as N'@SQLstr'

SELECT 'Return Value' = @return_value

GO


调用控件:

<asp:GridView ID="gridView" runat="server" Width="100%" AutoGenerateColumns="False"
                            OnRowCommand="gridView_RowCommand" CellPadding="0" CssClass="ListStyle" DataKeyNames="ID"
                            PageSize="15" OnRowDataBound="gridView_RowDataBound" AllowSorting="True">
                            <Columns>
                                <asp:TemplateField>
                                    <HeaderTemplate>
                                        <input id="chkSelAll" name="chkSelAll" onclick="javascript:CheckAll();" type="checkbox">全选
                                    </HeaderTemplate>
                                    <HeaderStyle Width="50px" />
                                    <ItemTemplate>
                                        <asp:CheckBox ID="chkSel" runat="server" />
                                        <asp:Label ID="lbid" runat="server" Text='<%# Bind("ID") %>' Visible="false"> </asp:Label>
                                    </ItemTemplate>
                                    <HeaderStyle CssClass="ListHead_Center" />
                                    <ItemStyle CssClass="ListItem_Center" Width="50px" />
                                </asp:TemplateField>
                                <asp:BoundField DataField="Title" HeaderText="标题" SortExpression="Title">
                                    <HeaderStyle CssClass="ListHead_left" />
                                    <ItemStyle CssClass="ListItem_left" Width="250px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="Type" HeaderText="类别" SortExpression="Type">
                                    <HeaderStyle CssClass="ListHead_left" />
                                    <ItemStyle CssClass="ListItem_left" />
                                </asp:BoundField>
                                <asp:BoundField DataField="TCreateBy" HeaderText="创建人" SortExpression="TCreateBy">
                                    <HeaderStyle CssClass="ListHead_Center" />
                                    <ItemStyle CssClass="ListItem_Center" Width="100px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="TCreateTime" HeaderText="创建时间" SortExpression="TCreateTime">
                                    <HeaderStyle CssClass="ListHead_Center" />
                                    <ItemStyle CssClass="ListItem_Center" Width="120px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="orderBy" HeaderText="排序号" SortExpression="orderBy">
                                    <HeaderStyle CssClass="ListHead_Center" />
                                    <ItemStyle CssClass="ListItem_Center" Width="120px" />
                                </asp:BoundField>
                           </Columns>
                        </asp:GridView>


--------------------编程问答-------------------- 脚本导入时，导入到SQL2000中的这张表中该ID字段已经不在是主键了，你需要手动到SQL2000数据库中重新设置下ID为主键即可。 --------------------编程问答-------------------- 1楼的果然细心，建议楼主把你的SQL拼一个执行一下，可确定问题所在。 --------------------编程问答-------------------- 问题补充:我查了一下说是 sql2000不支持AspNetPager控件,这玩意怎么处理 --------------------编程问答-------------------- ID是主键, --------------------编程问答--------------------  protected override AspNetPager MyAspNetPager
    {
        get { return thisAspNetPager; }
    }

补充：.NET技术 ,  C#