hi all,
i have 2 datasets from the results of 2 queries.
1st query :
Dim strSQL As String = "SELECT TblAuditTrail.TransID, TblTrans.TransItem AS summary, COUNT(TblAuditTrail.TransID) AS total FROM TblAuditTrail INNER JOIN TblTrans ON TblAuditTrail.TransID = TblTrans.TransID WHERE (TblAuditTrail.DateCreated BETWEEN '2012-10-11 00:00:00.000' AND '2012-10-18 00:00:00.000')GROUP BY TblAuditTrail.TransID, TblTrans.TransItem"
Dim sqlcmd As New SqlCommand(strSQL, sqlConn)
Dim da As New SqlDataAdapter(sqlcmd)
Dim ds As New DataSet()
da.Fill(ds, "total")
result :
ID | summary | total
-----------------------
1 a 88
2 b 5
3 c 2
4 d 4
5 e 2
6 f 6
7 g 43
8 h 61
2nd query:
Dim strSQL1 As String = "SELECT TblAuditTrail.TransID, TblTrans.TransItem AS summary, COUNT(TblAuditTrail.TransID) AS totalDate1 FROM TblAuditTrail INNER JOIN TblTrans ON TblAuditTrail.TransID = TblTrans.TransID WHERE (TblAuditTrail.DateCreated BETWEEN '2012-10-11 00:00:00.000' AND '2012-10-12 00:00:00.000') GROUP BY TblAuditTrail.TransID, TblTrans.TransItem"
Dim sqlcmd1 As New SqlCommand(strSQL1, sqlConn)
Dim da1 As New SqlDataAdapter(sqlcmd1)
'Dim ds As New DataSet()
da.Fill(ds, "date1")
result :
ID | summary | total
-----------------------
2 b 5
3 c 2
6 f 6
8 h 61
the question is how can i combine these datasets into 1 gridview?
i have 2 datasets from the results of 2 queries.
1st query :
Dim strSQL As String = "SELECT TblAuditTrail.TransID, TblTrans.TransItem AS summary, COUNT(TblAuditTrail.TransID) AS total FROM TblAuditTrail INNER JOIN TblTrans ON TblAuditTrail.TransID = TblTrans.TransID WHERE (TblAuditTrail.DateCreated BETWEEN '2012-10-11 00:00:00.000' AND '2012-10-18 00:00:00.000')GROUP BY TblAuditTrail.TransID, TblTrans.TransItem"
Dim sqlcmd As New SqlCommand(strSQL, sqlConn)
Dim da As New SqlDataAdapter(sqlcmd)
Dim ds As New DataSet()
da.Fill(ds, "total")
result :
ID | summary | total
-----------------------
1 a 88
2 b 5
3 c 2
4 d 4
5 e 2
6 f 6
7 g 43
8 h 61
2nd query:
Dim strSQL1 As String = "SELECT TblAuditTrail.TransID, TblTrans.TransItem AS summary, COUNT(TblAuditTrail.TransID) AS totalDate1 FROM TblAuditTrail INNER JOIN TblTrans ON TblAuditTrail.TransID = TblTrans.TransID WHERE (TblAuditTrail.DateCreated BETWEEN '2012-10-11 00:00:00.000' AND '2012-10-12 00:00:00.000') GROUP BY TblAuditTrail.TransID, TblTrans.TransItem"
Dim sqlcmd1 As New SqlCommand(strSQL1, sqlConn)
Dim da1 As New SqlDataAdapter(sqlcmd1)
'Dim ds As New DataSet()
da.Fill(ds, "date1")
result :
ID | summary | total
-----------------------
2 b 5
3 c 2
6 f 6
8 h 61
the question is how can i combine these datasets into 1 gridview?