View Single Post
  #1 (permalink)  
Old September 17th, 2007, 06:21 AM
hendyhanusin hendyhanusin is offline
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to capture 2 SQL queries into 2 datatables

Dear friend,

i create one stored procedure with 2 sql statement like below :
.............................

SELECT Merek,COUNT(Merek) AS 'QtyMerek'
FROM SERTIFIKATUJITIPE A

SELECT Merek, Tipe, COUNT(Tipe) AS 'QtyTipe'
FROM SERTIFIKATUJITIPE A
.............................

in vb .net side, how we can capture these queries into 2 datatables ?

Tks,
hendy


Reply With Quote