Cannot Fine Table (0)

Question

0.00/5 (No votes)

See more:

Hi i have made an web application asp.net

Sometime when i open the application which is hosted on the server
and i try to login i get the error message
Cannot find table 0.

Again when i refresh the login page and again try to log in i don't receive that error

same error is coming in the another error can u tell me what might be the problem

When i run the application on the local host it is running fine

Posted 22-Aug-13 1:23am

rocky_em

Add a Solution

Comments

CodeBlack 22-Aug-13 7:33am

can you please improve your question with code sample and show where exactly you are getting error ?

Nandakishore G N 22-Aug-13 8:36am

please paste the code what have you done so far?

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

thatraja · Answer 1 · 2013-08-22T01:35:00

Solution 1

and i try to login i get the error message
Cannot find table 0.

You're not getting any data in the dataset.
Check the table for records. If records exists then make sure records exists for login user.

Posted 22-Aug-13 1:35am

thatraja

Comments

rocky_em 22-Aug-13 7:54am

yes there are records in that table

ErBhati · Answer 2 · 2013-08-22T01:36:00

Solution 2

C#

Hi Rocky
          Cannot find table 0.is error occurs becouse ur dataset or datatables does'nt have any value at that time.
         I think ur database has some problem ...i think u get value from database in to dataset and then you provide the value to some variable like

 ds is datasetname

 cmd=da.fill(ds);
int a=ds.tables[0].rows[0]["ID"].tostring();

use 

if(ds.tables[0].rows.count !=0)
{
int a=ds.tables[0].rows[0]["ID"].tostring();
}
else
{
//print message
}
you see here in your dataset or datatable no rows found ...check it


it helps you...select as answer..

Posted 22-Aug-13 1:36am

ErBhati

Updated 22-Aug-13 1:37am

v2

Comments

rocky_em 22-Aug-13 7:55am

heok i will try this now :)

rocky_em 22-Aug-13 8:12am

Hey i have changed the code
like this if (ds.Tables[0].Rows.Count != 0)
{
#region
lblMessage.Text += "ds.tables[0].rows.count";
intEmpId = Convert.ToString(ds.Tables[0].Rows[0]["usrEmployeeCode"].ToString());
Session["EmpId"] = Convert.ToString(ds.Tables[0].Rows[0]["usrEmployeeCode"].ToString());
Session["EmpName"] = ds.Tables[0].Rows[0]["UserName"].ToString();
Session["EmpCode"] = ds.Tables[0].Rows[0]["usrEmployeeCode"].ToString();
Session["Role"] = ds.Tables[0].Rows[0]["Role"].ToString();
#endregion
}
else
{
lblMessage.Visible = true;
lblMessage.Text+= "DataCounlnot be retrived from the database";
}

Still the same error is coming
Cannot find table 0 as soon as i refreshed the login page and then again login
then i am not receving any error