Server Error in '/' Application.

Question

0.00/5 (No votes)

See more:

ASP.NET

How to slove this error

There is no row at position 0.

My code
LblCountryName.Text = dat.Rows[0][0].ToString();

Posted 8-Jan-13 17:39pm

Hasiya

Add a Solution

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

Mr. Mahesh Patel · Answer 1 · 2013-01-08T17:45:00

Solution 1

Hi Dear,

Please make sure that your DataTable is not null.

Please use below condition for check

C#

If(dat != null && dat.Rows.Count>0)
{
     LblCountryName.Text = dat.Rows[0][0].ToString(); 
}
else
{
     LblCountryName.Text = "DataTable is null or Not Contain Any Row(s).";
}

Thanks

Posted 8-Jan-13 17:45pm

Mr. Mahesh Patel

Comments

Hasiya 8-Jan-13 23:52pm

it's working ..Tnx dear tnx a lot.

Mr. Mahesh Patel 8-Jan-13 23:58pm

If this is helpful then accept this solution by clicking of accept button so other developers can take reference of this solution.
Thanks dear

prashant patil 4987 · Answer 2 · 2013-01-08T17:48:00

Solution 3

Check below Condition

C#

if(dat!= null)
{ 
    LblCountryName.Text = dat.Rows[0][0].ToString();
}

Posted 8-Jan-13 17:48pm

prashant patil 4987

Hasiya · Answer 3 · 2013-01-08T17:51:00

Solution 4

it's working ..Tnx dear tnx a lot.

Posted 8-Jan-13 17:51pm

Hasiya

Christian Graus · Answer 4 · 2013-01-08T17:47:00

Solution 2

The other poster is correct. To add two things:

1 - the error means what it says. You should understand what that error means, or you should not be writing code.

2 - You should never access an object in an array without first checking if it exists.

Posted 8-Jan-13 17:47pm

Christian Graus