How To Get Row Index Value Of Gridview , Here I Am Trying To Get Row Index Value But Getting Some Error Please Help Me

Question

0.00/5 (No votes)

See more:

I am writing this code to update data in data base from gridviewupdat button but i am gettin some error.

C#

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow row = GridView1.Rows[e.RowIndex];
       
        TextBox txtname = (TextBox)row.FindControl("txtname");
        TextBox txtage = (TextBox)row.FindControl("txtage");


        int userid = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());

        string name = txtname.Text;
        decimal age = Decimal.Parse(txtage.Text);


        UpdateProduct(userid, name, age);
    }

-----------------
Error is :

SQL

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Posted 5-Jan-14 3:30am

Alok.singh1166

Updated 5-Jan-14 3:35am

Karthik_Mahalingam

v2

Add a Solution

Comments

Alok.singh1166 5-Jan-14 9:54am

still i am getting same error ( actuly it is showing row index value =0

David Dekanozishvili 5-Jan-14 10:30am

Ok, solution provided was not the solution when I checked, I got it wrong sorry. First problem was DataKeyNames property was not set. Now Post the markup correctly please and I will analyze. :)
P.S. Added new solution...

Alok.singh1166 5-Jan-14 11:12am

hi David Please check solution 4 for markup

and do the needfull.

David Dekanozishvili 5-Jan-14 11:18am

Check Solution 3 and tell me if the error occurs again...

Alok.singh1166 5-Jan-14 11:33am

for solution 3 this error is coming

in this code for var age = e.newValues["age"] as decimal .Error is coming like the as operator must be use with reference type or null type decimal is not null type

David Dekanozishvili 5-Jan-14 11:35am

I fixed solution 3 15 minutes ago and posted there. :)
fixed line: var age = e.NewValues["age"] as decimal?;

Alok.singh1166 5-Jan-14 11:40am

Thank you so much David actuly i am getting some casting error can you please help me here. My method is
private void UpdateProduct(int userid, string name, decimal age)

for fixed line i am getting error.

David Dekanozishvili 5-Jan-14 11:41am

aha ok then:

Solution 3 updated

Alok.singh1166 5-Jan-14 11:45am

Specified cast is not valid.

This error is coming

David Dekanozishvili 5-Jan-14 11:47am

can you write down the exact model you are using... Names and datatypes of the model properties you are binding to grid... You have to prevent entering nothing into age field if it's not nullable...

David Dekanozishvili 5-Jan-14 11:55am

Updated again... I think it's ok now...

Alok.singh1166 5-Jan-14 11:59am

Thank You So much David. :)
Actuly there was castig problem i solved that thank you so much :)

David Dekanozishvili 5-Jan-14 12:02pm

You are welcome. :)

P.S. I tried to be quick and made some crazy mistakes... :)

Alok.singh1166 5-Jan-14 12:23pm

:) NP Thank you did finaly.

3 solutions

Solution 2

Start by checking the value of RowIndex at the start of the method:

C#

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
   {
   if (e.RowIndex >= 0 && e.RowIndex < GridView1 > Rows.Count)
      {
      GridViewRow row = GridView1.Rows[e.RowIndex];
      ...
      }
   }

Certainly with other events, you can get a negative value at the start to indicate "no row" - it may be the same with this event.

Posted 5-Jan-14 4:45am

OriginalGriff

Solution 4

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowcancelingEdit" OnRowUpdating="GridView1_RowUpdating" DataKeyNames="userid" OnRowEditing="GridView1_RowEditing" >
           <Columns>
               <asp:BoundField DataField="userid" HeaderText="userid" ReadOnly="true" />
               <asp:TemplateField HeaderText="name">
               <ItemTemplate>
           <%# Eval("name")%>
         </ItemTemplate>
         <EditItemTemplate>
           <asp:TextBox runat="server" ID="txtname" Text='<%# Eval("name")%>' />
         </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="age">
               <ItemTemplate>
             <%# Eval("age")%>
         </ItemTemplate>
         <EditItemTemplate>
             <asp:TextBox runat="server" ID="txtage" Text='<%# Eval("age")%>' />
         </EditItemTemplate>
               </asp:TemplateField>
               <asp:CommandField ShowEditButton="True" ButtonType="Button" />
           </Columns>
       </asp:GridView>

Posted 5-Jan-14 5:04am

Alok.singh1166

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)

David Dekanozishvili · Accepted Answer · 2014-01-05T04:53:00

Set DataKeyNames property to "userid", use bind on textboxes and rewrite code like this.

C#

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    var name = e.NewValues["name"] as string;
    var age = e.NewValues["age"] as string;

    var userid = (string)e.Keys[0];

    UpdateProduct(userid, name, age);
}

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowcancelingEdit" OnRowUpdating="GridView1_RowUpdating" DataKeyNames="userid" OnRowEditing="GridView1_RowEditing" >
           <Columns>
               <asp:BoundField DataField="userid" HeaderText="userid" ReadOnly="true" />
               <asp:TemplateField HeaderText="name">
               <ItemTemplate>
           <%# Eval("name")%>
         </ItemTemplate>
         <EditItemTemplate>
           <asp:TextBox runat="server" ID="txtname" Text='<%# Bind("name")%>' />
         </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="age">
               <ItemTemplate>
             <%# Eval("age")%>
         </ItemTemplate>
         <EditItemTemplate>
             <asp:TextBox runat="server" ID="txtage" Text='<%# Bind("age")%>' />
         </EditItemTemplate>
               </asp:TemplateField>
               <asp:CommandField ShowEditButton="True" ButtonType="Button" />
           </Columns>
       </asp:GridView>