y is it my connection could not be establish?

[pandapatin]

Dim conMyData = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString")) cmdSelect = New SqlCommand("DBAuthenticate", conMyData) cmdSelect.CommandType = CommandType.StoredProcedure paramReturnValue = cmdSelect.Parameters.Add("RETURN_VALUE", SqlDbType.Int) paramReturnValue.Direction = ParameterDirection.ReturnValue cmdSelect.Parameters.AddWithValue("@NoPekerja", noPekerja) cmdSelect.Parameters.AddWithValue("@pWord", pWord) conMyData.open() there is my code.But it i try to debug it,the conMyData is not working? any help plizz.

[Guffa]

Standard question #1: What do you mean by "not working"? --- b { font-weight: normal; }

[pandapatin]

when i try to run it exception apper.InvalidOperationException. it highlighted the conMydata.open() and said ==> The ConnectionString property has not been initialized. how could i solve it?

[Guffa]

You have forgotten to put the connection string in the configuration file. --- b { font-weight: normal; }

[pandapatin]

i've put the connection string in the webconfig file.but the same error still appear.Is there any place else should i put it?pliz man help me.how should i initialize the connection string?

[Dave Kreskowiak]

Set a breakpoint on the line that grabs the connection string from the config file and VERIFY that it indeed does return what you think it does. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome