Hello there, I have got an error like 'the ConnnectionString property has not been initialized. Anybody has any idea. Here is my code...

SqlConnection myConn = new SqlConnection(ConfigurationManager.AppSettings["strConn"]);
        SqlCommand myCmd = new SqlCommand("sp_userValidation", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;

        SqlParameter objParamUser;
        SqlParameter objParamPwd;
        SqlParameter returnParam;

        objParamUser = myCmd.Parameters.Add("@UserName", SqlDbType.VarChar);
        objParamPwd = myCmd.Parameters.Add("@Password", SqlDbType.VarChar);
        returnParam = myCmd.Parameters.Add("@Num_of_User", SqlDbType.Int);

        objParamUser.Direction = ParameterDirection.Input;
        objParamPwd.Direction = ParameterDirection.Input;
        returnParam.Direction = ParameterDirection.ReturnValue;

        objParamUser.Value = txtEmail.Value;
        objParamPwd.Value = txtPassword.Value;

        try
        {
            if (myConn.State.Equals(ConnectionState.Closed))
            {
                myConn.Open();
                myCmd.ExecuteNonQuery();
            }
            if ((int)returnParam.Value < 1)
            {
                lblMessage.Text = "Invalid Login!";
                return false;
            }
            else
            {
                myConn.Close();
                return true;
            }
        }
        catch (Exception ex)
        {
            lblMessage.Text = ex + "Error Connecting to the database";
            return false;
        }

    }

Well the first thing to test is whether ConfigurationManager.AppSettings["strConn"] is returning anything by outputting it somewhere.

--

Joe (Microsoft MVP - XML)

Thanks Joe, sometimes small thing make us mad.

Great!