<%@ Page Language="C#" Debug="True" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
DataSet voteItem() {
string connectionString = "Provider=Microsoft.Jet.4.0; Ole DB Services=-4; Data Source=D:\\BegASPNET11\\" +
"vote.mdb";
IDbConnection dbConnection = new OleDbConnection(connectionString); string queryString = "SELECT [voteMaster].[voteID], [voteMaster].[voteItem] FROM [voteMaster]";
IDbCommand dbCommand = new OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection; IDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet); 问题出现在这里!! return dataSet;
}语句有错误吗?我用web matrix编码向导得到下面代码 ,后来添了命名空间就把 System.Data.和 System.Data.OleDb.都删掉了
但是运行到 dataAdapter.Fill(dataSet); 出问题了,提示中没有提到什么错误。
多谢多谢!!!
System.Data.DataSet voteItem() {
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=D:\\BegASPNET11\\" +
"vote.mdb";
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
string queryString = "SELECT [voteMaster].[voteID], [voteMaster].[voteItem] FROM [voteMaster]";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);
return dataSet;
}
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
DataSet voteItem() {
string connectionString = "Provider=Microsoft.Jet.4.0; Ole DB Services=-4; Data Source=D:\\BegASPNET11\\" +
"vote.mdb";
IDbConnection dbConnection = new OleDbConnection(connectionString); string queryString = "SELECT [voteMaster].[voteID], [voteMaster].[voteItem] FROM [voteMaster]";
IDbCommand dbCommand = new OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection; IDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet); 问题出现在这里!! return dataSet;
}语句有错误吗?我用web matrix编码向导得到下面代码 ,后来添了命名空间就把 System.Data.和 System.Data.OleDb.都删掉了
但是运行到 dataAdapter.Fill(dataSet); 出问题了,提示中没有提到什么错误。
多谢多谢!!!
System.Data.DataSet voteItem() {
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=D:\\BegASPNET11\\" +
"vote.mdb";
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
string queryString = "SELECT [voteMaster].[voteID], [voteMaster].[voteItem] FROM [voteMaster]";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);
return dataSet;
}
string queryString = "SELECT [voteMaster].[voteID], [voteMaster].[voteItem] FROM [voteMaster]";改成:
string queryString = "SELECT [voteID],[voteItem] FROM [voteMaster]";前缀是数据表拥有者,如dbo,而不是表名。一般直接省略。