USING NEXTRESULT with MS ACCESS DATABASE

[Aashish Upadhyay]

Hi friends, I am trying to use NextResult method while Connecting my console based application with MS Access database but there is an error generated at run timeit says "Syntax error in from Clause" ? help me to figure out the solution please

here is my code

using System;
using System.Data.Ole Db;

class OleDbTest{

public static void Main()
{
OleDbConnection aConnection = new OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=E:\\db2. MDB");


String stry="SELECT * FROM pets"+"SELECT * FROM emp_test";
OleDbCommand aCommand = new OleDbCommand(st ry, aConnection);
try
{
aConnection.Ope n();

OleDbDataReader aReader = aCommand.Execut eReader();

Console.WriteLi ne("This is the returned data from pets table");

do
{
while(aReader.R ead())
{
Console.WriteLi ne("{0}\t{1}\t{ 2}",aReader.Get Int32(0),aReade r.GetString(1), aReader.GetStri ng(2));
}
Console.WriteLi ne("{0}\t{1}\t{ 2}",aReader.Get Int32(0),aReade r.GetString(1), aReader.GetStri ng(2));
}
while(aReader.N extResult());





aReader.Close() ;


aConnection.Clo se();
}


catch(OleDbExce ption e)
{
Console.WriteLi ne("Error: {0}", e.Errors[0].Message);//select * from emp_test
}
}
}