I am passing the following three queries in a string in VS.NET C# class
string sql = "SELECT A FROM TABLEA; SELECT B FROM TABLEB; SELECT C FROM
TABLEC;";
OdbcAdapter thisAdapter = new OdbcAdapter(sql, conn); (conn is my
connection object)
DataSet ds = new DataSet;
thisAdapter.Fill(ds);
If the second query fails, the third query doesn't get executed. If the
first one fails (sql +100) the second and third will never be executed.
But i would like the later occuring queries to execute even if the prior
ones have an SQL +100. How do i accomplish this ?
Thanks,
Karthik