doest work!!!

[pandapatin]

this is my code for login but it has an error.it stuck when comes to Myconn.open(). the error is : The ConnectionString property has not been initialized. this is the code : Function DBAuthenticate(ByVal strUsername As String, ByVal strPassword As String) As Integer Dim conMyData As SqlConnection Dim cmdSelect As SqlCommand Dim parmReturnValue As SqlParameter Dim intResult As Integer conMyData = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString")) cmdSelect = New SqlCommand("sp_ValidateUser", conMyData) cmdSelect.CommandType = CommandType.StoredProcedure parmReturnValue = cmdSelect.Parameters.Add("RETURN_VALUE", SqlDbType.Int) parmReturnValue.Direction = ParameterDirection.Input cmdSelect.Parameters.Add("@noPekerja", SqlDbType.VarChar) cmdSelect.Parameters.Add("@pWord", SqlDbType.VarChar) conMyData.Open() cmdSelect.ExecuteNonQuery() intResult = cmdSelect.Parameters("RETURN_VALUE").Value conMyData.Close() If intResult < 0 Then If intResult = -1 Then lblMessage.Text = "Username Not Registered!" Else lblMessage.Text = "Invalid Password!" End If End If End Function pliz anybody can help me.

[Colin Angus Mackay]

pandapatin wrote:

ConfigurationManager.AppSettings("psmConnectionString")

This is not returning a value because the config file is not set up properly. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?