"There is no row at position 0." what is the problem?

Question

4.00/5 (1 vote)

See more:

C#

protected void btnView_Click(object sender, EventArgs e)
       {

               BA.DeptNo = int.Parse(txtno.Text);
              BA.option = "select";
               DataTable dt = BA.viewRecords();

                 txtname.Text = Convert.ToString( dt.Rows[0]["dname"]);
                 
                txtloc.Text = Convert.ToString(dt.Rows[0]["loc"]);

                if (dt != null)
                {
                    Response.Write("The Records are:");
            }
           else
           {
               Response.Write("The deptno is invalid");
           }

       }

Posted 23-May-14 22:26pm

Member 10532069

Updated 28-May-14 3:18am

Nirav Prabtani

v3

Add a Solution

5 solutions

Solution 1

I suspect your code doesn't look like that - Visual studio would have tidied up the indentation for you - so it will really depend on what your real, executing code looks like: I don't think you have the

C#

dt.Rows.Count>0

test in the "live" code, as the only way it should get to the row access is if there is a row at position 0.

So start by checking you code, and if you think it's all correct, use VS to auto tidy the indentation using CTRL+K CTRL+D - if it compiles ok then it will work - and show us that code,
or use the debugger to examine the DataTable immediately prior to the if test.

Posted 23-May-14 22:59pm

OriginalGriff

Comments

Member 10532069 24-May-14 5:44am

Above I changed the code even though its giving me the error.

Solution 2

Add validations as below

C#

protected void btnView_Click(object sender, EventArgs e)
{

    BA.DeptNo = int.Parse(txtno.Text);
    BA.option = "select";
    DataTable dt = BA.viewRecords();
    if (dt!=null && dt.Rows.Count >0)
    {
        txtname.Text = Convert.ToString(dt.Rows[0]["dname"]);

        txtloc.Text = Convert.ToString(dt.Rows[0]["loc"]);

    }
    else
    {
        Response.Write("The deptno is invalid");
    }

}

Posted 24-May-14 0:54am

DamithSL

Solution 3

use below validation before your line which is throw error :
if (dt!=null && dt.Rows.Count >0)

Posted 24-May-14 1:29am

Member 9444634

Solution 5

C#

protected void btnView_Click(object sender, EventArgs e)
{
 
    BA.DeptNo = int.Parse(txtno.Text);
    BA.option = "select";
    DataTable dt = BA.viewRecords();
    // Before using table object, should check of null reference
    if (dt != null && dt.Rows.Count >0)
    {
        Response.Write("The Records are:");
   //While converting object, there should be check of null reference.
        txtname.Text = (!string.IsNullOrWhiteSpace(dt.Rows[0]["dname"]))?     Convert.ToString(dt.Rows[0]["dname"]) : String.Empty;
 
        txtloc.Text = (!string.IsNullOrWhiteSpace(dt.Rows[0]["loc"]))?Convert.ToString(dt.Rows[0]["loc"]): String.Empty;
 
    }
    else
    {
        Response.Write("The deptno is invalid");
    }
 
}

Posted 28-May-14 3:00am

swati0725

Updated 28-May-14 3:18am

v2

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)

Volynsky Alex · Accepted Answer · 2014-05-24T10:05:00

Please read these things here:
http://social.msdn.microsoft.com/Forums/en-US/d9df1e7f-0fdb-4cf0-afad-5dd2f8d66d7b/there-is-no-row-at-position-0-error[^]
http://stackoverflow.com/questions/19530733/there-is-no-row-at-position-0-error[^]
http://forums.asp.net/t/1028324.aspx?Error+There+is+no+row+at+position+0[^]

This will be helpful (even if you already knew that the cause of the error...)
Good luck!