the name 'dr' doesnot exist in the current context

Question

0.00/5 (No votes)

See more:

i'm designing a login page using 3tier architecture

In business access layer :

public SqlDataReader login()
{
ob.getcon();

SqlDataReader dr = ob.exdr("select client_pwd from Register where email='" + email + "'");
return dr;

}

In login page :

C#

protected void Button1_Click(object sender, EventArgs e)
       {
           string email = TextBox3.Text;
           ba.login();

           if (!dr.Read())
       {
          Label4.Text="Invalid User";
       }
       else
       {
           if (dr[0].ToString() == TextBox2.Text)
           {
               Response.Redirect("~/mainPage.aspx");
           }
           else
           {
              Label4.Text="Wrong Password";

           }


       }

here it is showing that dr doesnot exist in current context.how to solve this

Posted 2-Apr-14 0:13am

sruthyjoseph

Add a Solution

Comments

R-a-v-i-k-u-m-a-r 2-Apr-14 6:18am

Did you add the business layer project reference to presentatio layer?
Did you import the namespace of bll into your login page?

sruthyjoseph 2-Apr-14 6:26am

no..how to do it? thank you

4 solutions

Solution 1

if (dr[0].ToString() == TextBox2.Text)
You have not defined dr in this class.

In general the UI should not know about the data reader.
Let the BC handle this and return the result to the UI as a data model.

Posted 2-Apr-14 0:18am

Abhinav S

Comments

sruthyjoseph 2-Apr-14 6:22am

so u mean i need to write dat code in Business layer itself.but wen i write it there it is showing that TextBox and Labels doesnot exist in current context..
Thank you

Solution 2

error is because you are reading a variable which is declared in class.
improve your solution, pass email to Login() function. Instead of returning a DataReader. return a table or row. eg.

C#

public static DataTable GetTable(SqlCommand cmd)
        {
            DataTable tbl = null;
            SqlConnection conn = null;
            try
            {
                conn = //your connection;
                cmd.Connection = conn;
                tbl = new DataTable();
                SqlDataReader dr = cmd.ExecuteReader();
                tbl.Load(dr);

                dr.Close();
                dr.Dispose();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
            return tbl;
        }

protected void Button1_Click(object sender, EventArgs e)
       {
           string email = TextBox3.Text;
SqlCommand cmd = new SqlCommand();
cmd="select client_pwd from Register where email='" + email + "'"
          DataTable tbl = ba.GetTable(cmd)

           if (tbl == null && tbl.Rows.Count == 0)
       {
          Label4.Text="Invalid User";
       }
       else
       {
          //your code


       }

Posted 2-Apr-14 0:26am

Schatak

Updated 2-Apr-14 0:28am

v3

Solution 3

Chexk this link
http://msdn.microsoft.com/en-us/library/f3st0d45(v=vs.100).aspx[^]
after that import your bll name into yourpage

And write the code as

C#

protected void Button1_Click(object sender, EventArgs e)
       {
           string email = TextBox3.Text;
           SqlDataReader dr=ba.login();

           if (!dr.Read())
       {
          Label4.Text=&quot;Invalid User&quot;;
       }
       else
       {
           if (dr[0].ToString() == TextBox2.Text)
           {
               Response.Redirect(&quot;~/mainPage.aspx&quot;);
           }
           else
           {
              Label4.Text=&quot;Wrong Password&quot;;

           }


       }</pre>

=

Posted 2-Apr-14 0:36am

R-a-v-i-k-u-m-a-r

Updated 2-Apr-14 0:47am

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)

sankarsan parida · Accepted Answer · 2014-04-02T00:57:00

Solution 4

You are missing only SqlDataReader value

.....
  SqlDataReader dr=ba.login();

Posted 2-Apr-14 0:57am

sankarsan parida

Comments

sruthyjoseph 2-Apr-14 9:14am

u r right..i missed that..thanku so much :)