index out of range. error in last line.i want to change the value of last row of cell "Total_Amount_Debit" after loading data in gridview. help me with this. thanx

Question

1.00/5 (1 vote)

See more:

C#

int r=tr.dtsender.Rows.Count-1;
                            int i=dt.Rows.Count-1;
                            tr.txtsbefore.Text=dt.Rows[i]["Total_Amount_Debit"].ToString();
                            double total=Convert.ToDouble(dt.Rows[i]["Total_Amount_Debit"]);
                            double bal=Convert.ToDouble(txtamount.Text);
                            Double diff=total-bal;
                            tr.txtsafter.Text=diff.ToString();
                            for (int j = 0; j <= dt.Rows.Count - 1; j++)
                            {
                                int newRowIndex = tr.dtsender.Rows.Add();
                                tr.dtsender.Rows[newRowIndex].Cells["Account_No"].Value = dt.Rows[j]["Account_No"].ToString();
                                tr.dtsender.Rows[newRowIndex].Cells["Transaction_no"].Value = dt.Rows[j]["Transaction_no"].ToString();
                                tr.dtsender.Rows[newRowIndex].Cells["Amount_Debit"].Value = dt.Rows[j]["Amount_Debit"].ToString();
                                tr.dtsender.Rows[newRowIndex].Cells["Debit_Date"].Value = dt.Rows[j]["Debit_Date"].ToString();
                                tr.dtsender.Rows[newRowIndex].Cells["Total_Amount_Debit"].Value = dt.Rows[j]["Total_Amount_Debit"].ToString();
                            }
                            tr.dtsender.Rows[r].Cells["Total_Amount_Debit"].Value=diff.ToString();

Posted 16-Jan-13 3:23am

zeshanazam

Add a Solution

Comments

Sandeep Mewara 16-Jan-13 9:52am

Error is clear that the index is more than number of rows. But, I don't see it currently in the code you share. What do you see when you debugged it?

zeshanazam 16-Jan-13 9:57am

index was out of range. when i comment this line,data is loading in grid view but i want to change value of last row of cell Total_Amount_Debit

Sandeep Mewara 16-Jan-13 10:03am

When you debug, what is the index?

zeshanazam 16-Jan-13 9:59am

error is "Index was out of range. Must be non-negative and less than the size of the collection."

Sandeep Mewara 16-Jan-13 10:03am

You say error in this line:
tr.dtsender.Rows[r].Cells["Total_Amount_Debit"].Value=diff.ToString();

zeshanazam 16-Jan-13 10:11am

yup.

3 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)

Valery Possoz · Answer 1 · 2013-01-16T11:29:00

Hello,

Don't do:

C#

tr.dtsender.Rows[r].Cells["Total_Amount_Debit"].Value=diff.ToString();

Basically you initialise at the beginning of the code your variable r to the number of rows -1, then later in your loop you are adding news rows:

C#

int newRowIndex = tr.dtsender.Rows.Add();

So if at the beginning you have 0 rows r will be negative, and as you do not recalculate it the exception "Index was out of range. Must be non-negative and less than the size of the collection." will be throws as r is -1.

So... recalculated r before using it as the number of rows as changed:

C#

r=tr.dtsender.Rows.Count-1;
tr.dtsender.Rows[r].Cells["Total_Amount_Debit"].Value=diff.ToString();

Valery.

prashant patil 4987 · Answer 2 · 2013-01-16T16:25:00

Solution 2

try to check Row number is correct or not: means u check below underline code's row number like what is "r".

C#

tr.dtsender.<big>Rows[r]</big>.Cells["Total_Amount_Debit"].Value=diff.ToString();

Posted 16-Jan-13 16:25pm

prashant patil 4987

milenalukic · Answer 3 · 2013-01-20T13:04:00

Solution 3

Hi,

If your grid is set to allow user to add there is always an extra row. Check for that and either do not allow edit or use row count -2.

Posted 20-Jan-13 13:04pm

milenalukic