NextResult()问题
string strcnn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\vsio\\mydata.mdb ";
string sql= "select xuehao,score from score;select num,xuehao,name from student ";
OleDbConnection connection=new OleDbConnection(strcnn);
try
{
connection.Open();
Console.WriteLine( "The Access data is {0} ",connection.State);
OleDbCommand command=connection.CreateCommand();
command.CommandText=sql;
OleDbDataReader reader=command.ExecuteReader();
while(reader.Read())
{
Console.WriteLine( "\t{0}\t{1} ",reader[ "xuehao "],reader[ "score "]);
}
Console.WriteLine( "The data in \ "student.mdb\ " is read completely ");
reader.NextResult();
int num=reader.FieldCount;
for(int i=0;i <num;i++)
{
Console.WriteLine( "\t{0}\t{1} ",reader[ "xuehao "],reader[ "name "]);
}
Console.WriteLine( "The data in \ "score.mdb\ " is read completely ");
reader.Close();
}
写上string sql= "select xuehao,score from score;select num,xuehao,name from student ";这句之后,就一个数据库的内容也显示不了了,但单写任何一个都没问题
[解决办法]
reader.NextResult();
之后你还是要用
while(reader.Read())
{
}
来读取数据
即
reader.NextResult();
int num=reader.FieldCount;
for(int i=0;i <num;i++)
{
while(reader.Read())
{
Console.WriteLine( "\t{0}\t{1} ",reader[ "xuehao "],reader[ "name "]);
}
}
[解决办法]
up
[解决办法]
看MSDN
