How to set property of paging in gridview in asp.net?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I have set property of paging in gridview. But when i click on next button , i get error, i.e.

There is no row at position 0.

That error occurs in event of row command. I didn't get why this error has occurred. Can u plz help me to solve the problem?

Posted 2-Dec-12 19:22pm

mona_12

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pradiprenushe · Answer 1 · 2012-12-02T19:31:00

Solution 1

Try this

C#

<asp:gridview id="myGridView" runat="server" >
 AllowPaging="True" 
 OnPageIndexChanging="myGridView_PageIndexChanging"
 PageSize="5" ></asp:gridview>

C#

protected void myGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {     

        myGridView.PageIndex = e.NewPageIndex;
        myGridView.DataBind();
    }

Posted 2-Dec-12 19:31pm

pradiprenushe

Updated 2-Dec-12 19:39pm

v2

Comments

mona_12 3-Dec-12 1:53am

I have tried wat u said...
but stil error is coming...

pradiprenushe 3-Dec-12 2:07am

Can you give flow of what are you doing? means paging click select click like that in sequence & give the line where you are getting this exception. I think this is not paging issue.

mona_12 · Answer 2 · 2012-12-02T20:46:00

My code is

XML

<asp:GridView ID="GridView_Inbox" runat="server" AutoGenerateColumns="False"
                         onrowcommand="GridView_Inbox_RowCommand" AllowPaging="true" PageSize="1" OnPageIndexChanging="GridView_Inbox_PageIndexChanging">
                         <PagerSettings Mode="NumericFirstLast" PageButtonCount="2"  FirstPageText="First" LastPageText="Last"/>
                    <Columns>
                        <asp:BoundField DataField="MESSAGE_ID" HeaderText="Message ID" Visible="false"  />
                        <asp:BoundField DataField="FIRST_NAME" HeaderText="First Name"  />
                        <asp:BoundField DataField="LAST_NAME" HeaderText="Last Name" />
                        <asp:BoundField DataField="MESSAGE_SUBJECT" HeaderText="Subject" />
                        <asp:BoundField DataField="MESSAGE_CONTENT" HeaderText="Message" >
                            <HeaderStyle HorizontalAlign="Center" Width="400px" />
                        </asp:BoundField>
                        <asp:TemplateField>
                            <ItemTemplate>
                                <asp:LinkButton ID="LinkButton_Inbox_Read" runat="server" CommandArgument='<%# Eval("MESSAGE_ID") %>'>Read</asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                   </asp:GridView>

My .cs code is

C#

protected void GridView_Inbox_RowCommand(object sender, GridViewCommandEventArgs e)
   {
       int MSG_ID = Convert.ToInt32(e.CommandArgument);
       SysATGlobal.DB.ExecuteDMLCommand("UPDATE DSMailBox.HDR_MESSAGES SET READ_STATUS=1 WHERE MESSAGE_ID= " + MSG_ID + " ");
       dt = SysATGlobal.DB.ExecuteSelectQuery("SELECT [INBOX].MESSAGE_CONTENT  from DSMailBox.HDR_MESSAGES [INBOX] INNER JOIN DSProfile.HDR_PROFILE [SENDER] ON [SENDER].[PROFILE_ID] = [INBOX].[SENDER_ID] WHERE [INBOX].[RECEIVER_ID] = " + SysATGlobal.DB.MyProfile.ProfileID + "  AND [INBOX].[MESSAGE_ID]=" + MSG_ID + "", false);
       msg = dt.Rows[0].ItemArray.GetValue(0).ToString();  //Here i get that exception
       TextBox_Inbox.Text = msg;


   }