Why this exception?

[HowTo]

con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=db1.mdb")
02	con.Open()
03	cmd = New OleDbCommand("Select * from Table1 where Name='gautam';" & "Select * from Table1 where Name='arijit';" & "Select * from Table1 where Name='muah'", con)
04	Dim dr As OleDbDataReader
05	dr = cmd.ExecuteReader()
06	dr.Read()
07	textBox1.Text = dr(0).ToString()
08	textBox2.Text = dr(1).ToString()
09	textBox3.Text = dr(2).ToString()
10	textBox4.Text = dr(3).ToString()
11	dr.NextResult()
12	dr.Read()
13	textBox5.Text = dr(0).ToString()
14	textBox6.Text = dr(1).ToString()
15	textBox7.Text = dr(2).ToString()
16	textBox8.Text = dr(3).ToString()
17	dr.NextResult()
18	dr.Read()
19	textBox9.Text = dr(0).ToString()
20	textBox10.Text = dr(1).ToString()
21	textBox11.Text = dr(2).ToString()
22	textBox12.Text = dr(3).ToString()
23	dr.Close()
24	cmd.Dispose()
25	con.Close()

i am getting this exception:


please help

[stlaural]

I don't think this is valid, you concatenated 3 select statement, which I've never seen before, where you should only be using one

cmd = New OleDbCommand("Select * from Table1 where Name='gautam';" & "Select * from Table1 where Name='arijit';" & "Select * from Table1 where Name='muah'", con)

You should be using something like :

Select * from Table1 where Name='gautam' OR Name = 'arijit' OR Name = 'muah';

[HowTo]

nope........you changed the entire meaning of my sql statement

first i select the entire row where Name ='gautam' ,then i select entire row where name='arijit' and last i select entire row where name='much'

Then i populate the datareader with these three sql statements one aftre another using the nextresult() and populate the corresponding textbox.......

[Pradeep1210]

As far as I know Microsoft.Jet.Oledb doesn't support multiple queries in single query statement.

[stlaural]

nope........you changed the entire meaning of my sql statement

first i select the entire row where Name ='gautam' ,then i select entire row where name='arijit' and last i select entire row where name='much'

Then i populate the datareader with these three sql statements one aftre another using the nextresult() and populate the corresponding textbox.......

I understand that, but what I'm actually wondering is can you really use 3 select statement within the same OleDbCommand ?

[HowTo]

As far as I know Microsoft.Jet.Oledb doesn't support multiple queries in single query statement.

then it means i cant use the nextResult() of the datareader when i am using the oledb?

[Pradeep1210]

then it means i cant use the nextResult() of the datareader when i am using the oledb?

Atleast not with the Microsoft.Jet.Oledb provider as far as I know.

[stlaural]

then it means i cant use the nextResult() of the datareader when i am using the oledb?

Looks like you could do it using the SqlCommand instead of the OleDbCommand as you can see here.

[Tommy.net]

Looks like you could do it using the SqlCommand instead of the OleDbCommand as you can see here.

ya actually i was also trying to do it by having a look at the same page of the msdn.Anyways,nice to know that oledb cant handle these kinds of sql queries......

may i know what are these sql queries called(which contains more than 1 select statement as shown in the code)?

[Pradeep1210]

It is not limited to SELECT type queries only. It can be any valid sql query.