The error says 'configurationSettings is not declared'! But it should because as you can see i have put in my webconfig:(right?):
i get a error under the word 'configuration' in the statment of 'configurationsettings.AppSettings("ConnectionString"). I think though there must be two problems.
What about me putting things in the right places- i put them in a vb file and a web config. I appreciate any more ideas, Paul regarding either your parameters or maybe you spot the problem of my coding. To me, i see as if i am trying to recall the the information by calling 'connectionstring' from my key i mde in my webconfig file (as below). They also do not mention any reasons to put in database parameters in)
#MAC MICROSOFT ERROR REPORTING APPEARS AND DOES NOTHIGN CODE#
(even though i have carefull checked it against the code from my book hat i have followed. Please can u have a look at the coding i have done, as i think it is likely i have made sme silly error, like spelling, or missing out a comma, etc. I looked at the examples you said to look at, but do not see anything that particular stands out to say that is the solution.Ĭan u see the particular solution from the examples u have asked me to have a look at? I do not understand why i should have a database parameter. Return ConfigurationSettings.AppSettings("connectionString")ĭim command As New SqlCommand("GetCategory", connection) Private Shared ReadOnly Property connectionString() As String Return Command.ExecuteReader(CommandBehavior.CloseConnection) Public Shared Function GetCategory() As SqlDataReaderĭim Connection As New SqlConnection(connectionString)ĭim Command As New SqlCommand("GetCategory", Connection)Ĭommand.CommandType = CommandType.StoredProcedure What have i done wrong, can anyone please help me. Line 7: command.CommandType = CommandType.StoredProcedure Line 6: Dim command As New SqlCommand("GetCategory", connection)
Line 5: Dim connection As New SqlConnection(connectionString) Line 4: Public Shared Function GetCategory() As SqlDataReader When i run it this error appears: Format of the initialization string does not conform to specification starting at index 0. I have saved the database connection string to a key named 'ConnectionString' allowing to access it by calling 'configurationSettings.AppSettings("ConnectionString")īut a red line comes under the configuration in the part of the : 'configurationSettings.AppSettings("ConnectionString")'.
0 kommentar(er)
