.net - Return 2 tables from a store procedure in MySQL -

.net - Return 2 tables from a store procedure in MySQL -

i have sp create 2 temporary tables, fill them data, , need homecoming them can show them in .net application.

in .net create next phone call sp:

dim sentencias mysqlcommand dim tabla datatable = new datatable sentencias = new mysqlcommand(sp, me.getcon()) sentencias.commandtype = commandtype.storedprocedure sentencias.parameters.add("@param", mysqldbtype.int32).value = value sentencias.commandtimeout = 600000 dim myreader mysqldatareader myreader = sentencias.executereader() tabla.load(myreader) datagrid.datasource = tabla myreader.close()

how can phone call sp , homecoming both tables?

this sp cpu & i/o intensive, since has 2 cursors reading enormous tables (it expected lastly 15 minutes). there no way can split sp in order homecoming 1 table each.

thanks!

mysql .net stored-procedures