Last post Feb 07, 2013 04:28 AM by rambhopalreddy
Feb 07, 2013 04:25 AM|junmoney83|LINK
I need to run 3 multi sql.
below is my source code and there is an error because oracle database does not acccept ";".
How can i run multi sql and put result to dataset?
sQueryString, ="select * from people; select * from megi2;"
Dim SQLConn As New OleDbConnection '//데이타베이스 연결
Dim adapter As OleDbDataAdapter = New OleDbDataAdapter
adapter = New OleDbDataAdapter(sQueryString, SQLConn)
Dim return_dt As DataSet = New DataSet
Feb 07, 2013 04:28 AM|rambhopalreddy|LINK
Write Procedure for multiple queries and oldbDataReader for that and Read.NextResult() will give you second slection result.