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
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