datareader related issue

Question

0.00/5 (No votes)

See more: (untagged)

Respected Sir,

my following code is not working .

SqlConnection con = new SqlConnection("data source=Abhishek-PC;integrated security=true;initial catalog=easyschool;");
SqlCommand com = new  SqlCommand("select * from LoginUser", con);
con.Open();
if (con.State == ConnectionState.Open)
{
   SqlDataReader dtr;
    dtr = com.ExecuteReader();
    while (dtr.Read())
    {
        Session["UserId"] = TextBox1.Text;

        if(dtr[0].ToString().Equals(TextBox1.Text) && dtr[1].ToString().Equals(TextBox2.Text) && dtr[2].ToString().Equals(DropDownList1.SelectedValue))
        {
            //flag = 1;

            Response.Redirect("Home.aspx");
            //break;
        }
    }

In this code If loop of datareader is not executing.
Means if if condition would be true then only we will be redirected to the Home page.
But when we enter user name ,password and Role and while we click button we are on same page(means it does not redirect anywhere).

Before sometime it was working fine all of sudden it stopped working.

Pls help me out.

Thanks
Abhishek

[edit]Code block added, "Ignore HTML..." option disabled - OriginalGriff[/edit]

Posted 17-Jul-11 4:43am

abhiamity86

Updated 17-Jul-11 4:50am

OriginalGriff

v2

Add a Solution

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)

Espen Harlinn · Answer 1 · 2011-07-17T04:53:00

Solution 1

Run it through the debugger.
My guesses are that either you do not have the correct connection string causing con.Open(); to throw an exception - in that case if (con.State == ConnectionState.Open) will never be executed; or something strange has happened to your database.

Best regards
Espen Harlinn

Posted 17-Jul-11 4:53am

Espen Harlinn

Comments

abhiamity86 17-Jul-11 11:01am

Thanks For reply..
But sir it was working fine before somedays

Espen Harlinn 17-Jul-11 11:07am

That's why I'm making these guesses - try wrapping the code in a:
try
{
<your code goes here>
}
catch(Exception exc)
{
<Log exception to file here >
}

block ...

mhamad zarif · Answer 2 · 2011-07-17T05:04:00

Solution 2

My friend.Try to debug your code first,or try to put a try catch statement.I see no error in your code,so maybe it is a connection issue.

Posted 17-Jul-11 5:04am

mhamad zarif