skip to Main Content

currently i am working a one project and i got this type of error.
i excuted the procedure and in debugging mode prcedure pass the data to entity file but when i go back to aspx page so that time i got this null exception.
how can i resolve.
any one help me?.

UserDAL file

this is a prcedure

public UserENT PR_IP_User_LoginUser(SqlInt32 UserID)
{
   using (SqlConnection objconn = new SqlConnection(ConnectionString))
   {
      objconn.Open();
      using (SqlCommand objcmd = objconn.CreateCommand())
      {
         try
         {
            #region Prepaed Command
            objcmd.CommandType = CommandType.StoredProcedure;
            objcmd.CommandText = "PR_IP_User_LoginUser";
            objcmd.Parameters.AddWithValue("@UserID", UserID);
            #endregion

             UserENT entuser = new UserENT();
             #region Read and set controls
             using (SqlDataReader objSDR = objcmd.ExecuteReader())
             {
                while (objSDR.Read())
                {
                   if (!objSDR["User_Name"].Equals(DBNull.Value))
                   {
                      entuser.User_Name = Convert.ToString(objSDR["User_Name"].ToString().Trim());
                   }

                   if (!objSDR["Password"].Equals(DBNull.Value))
                   {
                      entuser.Password = Convert.ToString(objSDR["Password"].ToString().Trim());
                   }

                   if (!objSDR["User_ID"].Equals(DBNull.Value))
                   {
                        entuser.User_ID = Convert.ToInt32(objSDR["User_ID"]);
                   }

                   if (!objSDR["ContactNo"].Equals(DBNull.Value))
                   {
                        entuser.ContactNo = Convert.ToString(objSDR["ContactNo"]);
                   }

                   if (!objSDR["Email_ID"].Equals(DBNull.Value))
                   {
                       entuser.Email_ID = Convert.ToString(objSDR["Email_ID"]);
                   }

                   if (!objSDR["Is_Admin"].Equals(DBNull.Value))
                   {
                       entuser.Is_Admin = Convert.ToBoolean(objSDR["Is_Admin"]);
                   }

              }

           return entuser;
        }
        #endregion

        }
        catch (Exception e)
        {
            Message = e.InnerException.Message;
            return null;
         }
         finally
         {
             objconn.Close();
         }
      }
    }
 }
        #endregion

on client side or can say aspx page

on button click event

protected void btnLogin_Click(object sender, EventArgs e)
{ 
     #region Server Side Validation
    String strerr = "";

    if (txtusername.Text.Trim() == "")
    {
        strerr += "Enter UserName";
    }

    if (txtpassword.Text.Trim() == "")
    {
        strerr += "Enter Password";
    }

    if (strerr != "")
    {
        lblMessage.EnableViewState = true;
        lblMessage.Text = strerr;
    }
     #endregion

     #region Gather Data

     SqlString Username, userpass;

     if (txtusername.Text.Trim() != "")
     {
        Username = txtusername.Text.Trim();
     }

     if (txtpassword.Text.Trim() != "")
     {
        userpass = txtusername.Text.Trim();
     }

      #endregion

      UserBAL baluser = new UserBAL();
      UserENT entuser = new UserENT();
      SqlInt32 UserID_Res;
      SqlString User_name_res, User_Password_res;
      SqlInt32 userid = Convert.ToInt32(txtuserid.Text.Trim());
      if (Request.QueryString["User_ID"] == null)
      {
          if (baluser.Login(userid) != null)
          {
              User_name_res = entuser.User_Name.Value.ToString().Trim();
              UserID_Res = Convert.ToInt32(entuser.User_ID.Value);
              User_Password_res = entuser.Password.Value.ToString().Trim();

               if (User_name_res == txtusername.Text.Trim() || User_Password_res == txtpassword.Text.Trim())
               {
                  Response.Redirect("AddSubject.aspx");
               }
               else
               {
                   Response.Redirect("AddTopic.aspx");
               }
           }
       }
        
    #endregion

2

Answers


  1. Chosen as BEST ANSWER

    Thanks every one who help to solve my error. now i resolve my error. i Just pass the data to procure and check the data in procedure and return Boolean value. Thanks Again :)


  2. The C# code associated with a ".aspx" page (or code behind) is executed on the server side.

    I assume that UserBAL.Login() function returns the user’s data once logged in. It may be necessary to get the returned object.

    On button click event :

    protected void btnLogin_Click(object sender, EventArgs e)
    {
        ...
        
        UserENT entuser = baluser.Login(userid);
        if (entuser  != null)
        {
            ...
    
    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search