Help for this array solve

Question

0.00/5 (No votes)

See more:

C#

Server Error in '/wwwroot' Application.

There is no row at position 1.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.IndexOutOfRangeException: There is no row at position 1.

Source Error: 


Line 135:            for (int j = 0; j < b; j++)
Line 136:            {
Line 137:                pp[i] += con.QueryEx().Rows[i][j].ToString();
Line 138:                if (j == b - 1)
Line 139:                {

Source File: c:\inetpub\wwwroot\Gujarati_sms.aspx.cs    Line: 137 

Stack Trace:

for this code
run

C#

int p = con.QueryEx().Rows.Count;
       int b = con.QueryEx().Columns.Count;
       for (int i = 0; i < p; i++)
       {
           for (int j = 0; j < b; j++)
           {
               pp[i] += con.QueryEx().Rows[i][j].ToString();
               if (j == b - 1)
               {
                  // TextBox3.Text += pp[i];
                  con.SqlQuery("insert into Sms_Genrate(Message) values ('" + pp[i] + "')");
                   con.NonQueryEx();
               }
           }
           TextBox3.Text += tt + "\r\n";
       }

What I have tried:

please help all type use i array , simple string but all rows not insert only first rows are insert after above error

Posted 1-Aug-16 20:48pm

paras patel

Updated 1-Aug-16 22:00pm

Add a Solution

1 solution

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)

Suvendu Shekhar Giri · Answer 1 · 2016-08-01T22:00:00

Is your method returning a DataTable object?
If no, your whole logic may got fail.

If yes, you haven't put any check on wheather that datatable really contains a row or not. So, following line of code will raise error when there is an empty datatable.

C#

pp[i] += con.QueryEx().Rows[i][j].ToString();
//will be evaluated to following
pp[0] += con.QueryEx().Rows[0][0].ToString();

It pass previos steps as the rows and columns count is 0 but will throw error in the above line.

Try putting some validation like-

C#

int p = con.QueryEx().Rows.Count;
int b = con.QueryEx().Columns.Count;
if(p>0)
{
   for (int i = 0; i < p; i++)
   {
      //rest of the logic here
   }
}

Hope, it helps :)