See the Error,why it comes guys? : The Official Microsoft ASP.NET Forums

Reply

See the Error,why it comes guys?

Nov 23, 2011 05:00 AM|LINK

Exception was unhandled by the user code

System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)

hi guys,

This is the Error i am getting when i execute a stored procedure with giving all parameter as null values.,

Wts the problem actually, I created my stored proc to allow null value but i got this error why?

Be what u want to be...Do wat u want to do...

Mark as answer,if it helped U!

Reply

Re: See the Error,why it comes guys?

Nov 23, 2011 05:16 AM|LINK

Hello,

Are you executing the SP from application or SSMS?

Java Exam

Reply

Re: See the Error,why it comes guys?

Nov 23, 2011 05:17 AM|LINK

from application.....

I am calling that procedure from code behind file.,

Be what u want to be...Do wat u want to do...

Mark as answer,if it helped U!

Reply

Re: See the Error,why it comes guys?

Nov 23, 2011 06:34 AM|LINK

Can you please post the code from where you are calling SP? since it is thread aboart exception most likely it is from C# part.

Please mark this post as Answered if it solves the problem :).

Nilay Kothari

Reply

Re: See the Error,why it comes guys?

Nov 23, 2011 08:32 AM|LINK

This is my code for calling the SP.....

protected void btn_SubmitClub_Click(object sender, EventArgs e)
        {
            DbSqlParameterCollection pCollection = new DbSqlParameterCollection();

            if (string.IsNullOrEmpty(txtClubName.Text))
            {
                DbSqlParameter pClubName = new DbSqlParameter("@ClubName", SqlDbType.VarChar, 200);
                pClubName.Value = string.Empty;
                pCollection.Add(pClubName);
            }
            else
            {
                DbSqlParameter pClubName = new DbSqlParameter("@ClubName", SqlDbType.VarChar, 200);
                pClubName.Value = txtClubName.Text;
                pCollection.Add(pClubName);
            }
            if (string.IsNullOrEmpty(txtClubNumber.Text))
            {
                DbSqlParameter pClubNumber = new DbSqlParameter("@ClubNumber", SqlDbType.VarChar, 50);
                pClubNumber.Value = string.Empty;
                pCollection.Add(pClubNumber);
            }
            else
            {
                DbSqlParameter pClubNumber = new DbSqlParameter("@ClubNumber", SqlDbType.VarChar, 50);
                pClubNumber.Value = txtClubNumber.Text;
                pCollection.Add(pClubNumber);
            }
            if (ddlDistrict.SelectedIndex == 0)
            {
                DbSqlParameter pDistrictName = new DbSqlParameter("@DistrictName", SqlDbType.VarChar, 150);
                pDistrictName.Value = DBNull.Value;
                pCollection.Add(pDistrictName);
            }
            else
            {
                DbSqlParameter pDistrictName = new DbSqlParameter("@DistrictName", SqlDbType.VarChar, 150);
                pDistrictName.Value = ddlDistrict.SelectedValue.ToString();
                pCollection.Add(pDistrictName);
            }
            if (ddlZone.SelectedIndex == 0)
            {
                DbSqlParameter pZone = new DbSqlParameter("@Zone", SqlDbType.VarChar, 150);
                pZone.Value = DBNull.Value;
                pCollection.Add(pZone);
            }
            else
            {
                DbSqlParameter pZone = new DbSqlParameter("@Zone", SqlDbType.VarChar, 150);
                pZone.Value = ddlZone.SelectedValue.ToString();
                pCollection.Add(pZone);
            }
           
            if (string.IsNullOrEmpty(txtInstallationDate.Text))
            {
                DbSqlParameter pInstallationDate = new DbSqlParameter("@InstallationDate", SqlDbType.DateTime);
                //IFormatProvider Provider1 = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB").DateTimeFormat;
                pInstallationDate.Value = DBNull.Value;
                pCollection.Add(pInstallationDate);
            }
            else
            {
                DbSqlParameter pInstallationDate = new DbSqlParameter("@InstallationDate", SqlDbType.DateTime);
                IFormatProvider Provider1 = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB").DateTimeFormat;
                pInstallationDate.Value = Convert.ToDateTime(txtInstallationDate.Text, Provider1);
                pCollection.Add(pInstallationDate);
            }
           
           
           
           
            if (string.IsNullOrEmpty(txtName.Text))
            {
                DbSqlParameter pName = new DbSqlParameter("@Name", SqlDbType.VarChar, 150);
                pName.Value = string.Empty;
                pCollection.Add(pName);
            }
            else
            {
                DbSqlParameter pName = new DbSqlParameter("@Name", SqlDbType.VarChar, 150);
                pName.Value = txtName.Text;
                pCollection.Add(pName);
            }
            if (string.IsNullOrEmpty(txtEmail.Text))
            {
                DbSqlParameter pEmail = new DbSqlParameter("@Email", SqlDbType.VarChar, 150);
                pEmail.Value = string.Empty;
                pCollection.Add(pEmail);
            }
            else
            {
                DbSqlParameter pEmail = new DbSqlParameter("@Email", SqlDbType.VarChar, 150);
                pEmail.Value = txtEmail.Text;
                pCollection.Add(pEmail);
            }
           
            try
            {
                DatabaseConnection.DoStored("SP_CLUBREGISTRATION", pCollection);
                Response.Redirect("AddClubMember.aspx");
            }
            catch (Exception ex)
            {
                throw new Exception(ex.ToString());
            }
            finally
            {
                Response.Write("SUCCESSFULLY EXECUTED");
            }
        }

Be what u want to be...Do wat u want to do...

Mark as answer,if it helped U!

Reply

Re: Exception was unhandled by the user code

Nov 23, 2011 09:15 AM|LINK

It's nothing to do with passing null parameteres. I think you SQL server instance is running out of memory.

See the below link to manage memory in SQL.

http://blogs.msdn.com/b/sqlclr/archive/2006/03/24/560154.aspx

Please 'Mark as Answer' if this post helps you.

My Tech blog | My YouTube Channel

Reply

Re: Exception was unhandled by the user code

Nov 23, 2011 09:18 AM|LINK

Please post the code

Regards
Sree

Mark as Answer if it helps

Reply

Re: Exception was unhandled by the user code

Nov 23, 2011 09:20 AM|LINK

this is becausee of your Response.Redirect Code, pass second parameter as a false in response.redirect.

Response.Redirect("~/Default.aspx",false)

MARK AS ANSWER IF IT HELPS

Marked as answer by ssjGanesh on Nov 24, 2011 04:28 AM

Reply

Re: Exception was unhandled by the user code

Nov 24, 2011 04:30 AM|LINK

Thanks., that problem got clear,

But why we should give "false" as a 2nd parameter.

whatwill happen if we give "true" and whatwill happen if we give "false" .-

Be what u want to be...Do wat u want to do...

Mark as answer,if it helped U!

Reply

Re: Exception was unhandled by the user code

Nov 24, 2011 05:55 AM|LINK

if you give true(defalut is true) it will immediate redirects to your new page.
example:
void MyMethod(int i)
{
     Response.Redirect("~/default.aspx",true);
     //The code here will not execute, as it will throw the error and come out of the function....
}

if you give false it will execute your whole method code, even its after response.redirect.
void MyMethod(int i)
{
     Response.Redirect("~/default.aspx",false);
     //The code here will execute.
}

MARK AS ANSWER IF IT HELPS

Marked as answer by ssjGanesh on Nov 24, 2011 06:01 AM

See the Error,why it comes guys? RSS

10 replies

ssjGanesh

See the Error,why it comes guys?

jassi_singh

Re: See the Error,why it comes guys?

ssjGanesh

Re: See the Error,why it comes guys?

nilay.kothar...

Re: See the Error,why it comes guys?

ssjGanesh

Re: See the Error,why it comes guys?

Ruchira

Re: Exception was unhandled by the user code

sendtosree

Re: Exception was unhandled by the user code

patricgreat

Re: Exception was unhandled by the user code

ssjGanesh

Re: Exception was unhandled by the user code

patricgreat

Re: Exception was unhandled by the user code

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft