Dataset error. Why?

S

Shapper

Hello,



I have a dataset in an ASP.NET/VB web site.



Here is the aspx code:



Function dsContent(ByVal page As String, ByVal name As String) As
System.Data.DataSet

Dim connectionString As String =
System.Configuration.ConfigurationSettings.AppSettings.Get("connectionString");


Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString)

Dim queryString As String = "SELECT [t_content].* FROM [t_content]
WHERE (([t_content].[page] = @page) AND ([t_content].[name] = @name))"

Dim dbCommand As System.Data.IDbCommand = New
System.Data.OleDb.OleDbCommand

dbCommand.CommandText = queryString

dbCommand.Connection = dbConnection



Dim dbParam_page As System.Data.IDataParameter = New
System.Data.OleDb.OleDbParameter

dbParam_page.ParameterName = "@page"

dbParam_page.Value = page

dbParam_page.DbType = System.Data.DbType.String

dbCommand.Parameters.Add(dbParam_page)

Dim dbParam_name As System.Data.IDataParameter = New
System.Data.OleDb.OleDbParameter

dbParam_name.ParameterName = "@name"

dbParam_name.Value = name

dbParam_name.DbType = System.Data.DbType.String

dbCommand.Parameters.Add(dbParam_name)



Dim dataAdapter As System.Data.IDbDataAdapter = New
System.Data.OleDb.OleDbDataAdapter

dataAdapter.SelectCommand = dbCommand

Dim dataSet As System.Data.DataSet = New System.Data.DataSet

dataAdapter.Fill(dataSet)

Return dataSet



Here is my web.config file:



<appSettings>

<add key="connectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;
Ole DB Services=-4; Data Source=C:\_database\myDatabase.mdb" />

</appSettings>



The error I got is in this line:

Dim connectionString As String =
System.Configuration.ConfigurationSettings.AppSettings.Get("connectionString");



And the error is: BC30037: Character is not valid.



Can someone tell me what is wrong here?



Thanks,

Miguel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,065
Latest member
OrderGreenAcreCBD

Latest Threads

Top