i am getting this exception:Code: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()
please help




Reply With Quote