cannot find table 0 in login form

Question

0.00/5 (No votes)

See more:

hey all

i have 1 login form for 2 users one is admin and second is simple user

when i login from theri password then its fine and working but when ienter worng password it gives me error CANNOT FIND TABLE 0

CODE

C#

public int Loginuser1(string UserName, string Password)
       {
           // return the values if Admin then 1 else 2 for User
          int a = Convert.ToInt32( db.ExecuteDataSet("splogin3", new object[] { UserName, Password }).Tables[0].Rows[0][0].ToString());

          return a;



       }

AND login button code is

C#

protected void Button1_Click(object sender, EventArgs e)
        {
            if (cd.Loginuser1(UserName.Text, Password.Text)==1)
            {
                Session["UserID2"] = cd.Loginuser1(UserName.Text, Password.Text);
                Session["Login4"] = UserName.Text;
                Session["Login5"] = Password.Text;
                Lgin.Text = ("Login Successfully");
                Response.Redirect("DocUpload.aspx");



                Lgin.Text = ("Incorrect Passsword");
            }

            else if (cd.Loginuser1(UserName.Text, Password.Text)==2)
            {
                Session["UserID"] = cd.Loginuser1(UserName.Text, Password.Text);
                Session["Login2"] = UserName.Text;
                Session["Login3"] = Password.Text;
                Lgin.Text = ("Login Successfully");
                Response.Redirect("InfoDoc.aspx");

                Lgin.Text = ("Incorrect Passsword");
            }
        }

HOW TO SOLVE THIS ANY HELP PLEASE

Posted 26-Jul-13 7:23am

Diya Ayesa

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)

ZurdoDev · Answer 1 · 2013-07-26T07:29:00

Solution 1

C#

DataSet ds = db.ExecuteDataSet("splogin3", new object[] { UserName, Password })
if (ds.Tables.Count>0)
{
  // then do your checking
}

Posted 26-Jul-13 7:29am

ZurdoDev

Comments

Diya Ayesa 26-Jul-13 13:33pm

this code is in button coding or in above funtion ..???the error in above funtion

public int Loginuser1(string UserName, string Password)
{
// return the values if Admin then 1 else 2 for User
int a = Convert.ToInt32( db.ExecuteDataSet("splogin3", new object[] { UserName, Password }).Tables[0].Rows[0][0].ToString());

return a;

}

IN THIS FUNTION ERROR OCCUR

ZurdoDev 26-Jul-13 13:37pm

Perhaps you should break up that line of code. The error is very clear. You are trying to access Tables[0] and it does not exist. You are trying to do too much in a single line of code. That is why you need to break it up, check if Tables[0] even exists and then continue on.

Diya Ayesa 26-Jul-13 13:58pm

if i do this code

Collapse | Copy Code

public bool Loginuser1(string UserName, string Password)
{
DataSet ds = db.ExecuteDataSet("splogin3", new object[] { UserName, Password });
if(ds.Tables.Count>0)
{
return true;
}
return false;
}

then error in button code that i s

Operator '==' cannot be applied to operands of type 'bool' and 'int'

in this funtion
Collapse | Copy Code

protected void Button1_Click(object sender, EventArgs e)
{
if (cd.Loginuser1(UserName.Text, Password.Text)==1)
{
Session["UserID2"] = cd.Loginuser1(UserName.Text, Password.Text);
Session["Login4"] = UserName.Text;
Session["Login5"] = Password.Text;
Lgin.Text = ("Login Successfully");
Response.Redirect("DocUpload.aspx");

Lgin.Text = ("Incorrect Passsword");
}

else if (cd.Loginuser1(UserName.Text, Password.Text)==2)
{
Session["UserID"] = cd.Loginuser1(UserName.Text, Password.Text);
Session["Login2"] = UserName.Text;
Session["Login3"] = Password.Text;
Lgin.Text = ("Login Successfully");
Response.Redirect("InfoDoc.aspx");

Lgin.Text = ("Incorrect Passsword");
}
}

then hwo to solve this

Diya Ayesa 26-Jul-13 13:58pm

NOW FINE....

ZurdoDev 26-Jul-13 14:00pm

Good to hear.

ZurdoDev 26-Jul-13 14:04pm

What problem? You said it is fine.

Diya Ayesa 26-Jul-13 14:02pm

NOW can u tell me how i resolve this problem

Diya Ayesa 26-Jul-13 14:34pm

i mean that i paste my question here thats y i tell fine.. ;)

problem still not solvee

ZurdoDev 26-Jul-13 14:48pm

Your code is wrong. I did not give you the complete code but fixed the issue you were on. Just checking to see if there is a table, is not valid. You still want to check and see IF there is a table then checks rows[0][0].