coming error in my connection

Question

0.00/5 (No votes)

See more:

public static SqlConnection OpenConnection()
        {
            try
            {
                if (HttpContext.Current.Session["DATABASE"] != null && HttpContext.Current.Session["USERNAME"] != null && HttpContext.Current.Session["PASSWORD"] != null && HttpContext.Current.Session["SERVERNAME"] != null)
                {
                    cn = new SqlConnection("uid=" + HttpContext.Current.Session["USERNAME"].ToString() + ";pwd=" + HttpContext.Current.Session["PASSWORD"].ToString() + ";server=" + HttpContext.Current.Session["SERVERNAME"].ToString() + ";database=" + HttpContext.Current.Session["DATABASE"].ToString() + "");
                    if (cn.State == ConnectionState.Closed)
                    {
                        cn.Open();
                    }

                }
                else
                {
                    HttpContext.Current.Response.Redirect("~/Login.aspx");

                }
                return cn;

            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

I have connected It through class file. When my session expire it is coming to else part but in else part it showing error and directly go to catch block.

Is there any solution.....

Posted 15-Nov-11 19:04pm

JBSAHU

Updated 15-Nov-11 19:05pm

hitech_s

v2

Add a Solution

Comments

hitech_s 16-Nov-11 1:05am

added pre tags

hitech_s 16-Nov-11 1:06am

can u post the error

JBSAHU 16-Nov-11 2:57am

Exception was unhandled by user code

Thread was being abroted

This error is coming

Mehdi Gholam 16-Nov-11 1:15am

What is the exception that you are getting?

JBSAHU 16-Nov-11 2:57am

Exception was unhandled by user code

Thread was being abroted

This error is coming

Mehdi Gholam 16-Nov-11 3:50am

What is the inner exception?

Prince Antony G 16-Nov-11 1:22am

which error u got?

JBSAHU 16-Nov-11 2:57am

Exception was unhandled by user code

Thread was being abroted

This error is coming

sriman.ch 16-Nov-11 1:23am

CAn you post what the error you are getting ?

JBSAHU 16-Nov-11 2:58am

Exception was unhandled by user code

Thread was being abroted

This error is coming

shashikanth 2011 16-Nov-11 1:53am

Keep Break point and check for Session Expiration and What is the Exception..

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)

hitech_s · Answer 1 · 2011-11-17T18:49:00

Solution 2

try replace this line

HttpContext.Current.Response.Redirect("~/Login.aspx");

with this

HttpContext.Current.Response.Redirect("~/Login.aspx",false);

Posted 17-Nov-11 18:49pm

hitech_s

Comments

RaisKazi 18-Nov-11 2:09am

Correct. 5ed. By default endResponse property is true, which cusses "ThreadAbort" Exception.

hitech_s 18-Nov-11 3:53am

thanq

dinidusoft123 · Answer 2 · 2011-11-15T19:20:00

I assume in true time, your connection will open with out any matter.
and

cn

is always return value.

If so this error occurs one of "DATABASE", "PASSWORD" or "SERVERNAME" throws and exception. you can check it and populate it by using three if blocks instead of one if block for all conditions. keep the debug point before the first if block and check the code..

if(HttpContext.Current.Session["DATABASE"] != null) 
if(HttpContext.Current.Session["PASSWORD"] != null)
 HttpContext.Current.Session["SERVERNAME"] != null
{
///your code goes here
}

Hope this will help to find out the real exception...

coming error in my connection

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us