show data of both queries at runtime in a grid view

Hey,
it's possible create temporary Datatable add 4 columns with appropriate name
and add rows from both tables in temp table and finally set as datasourse of that gridview.
Best luck

You can create one stored procedure and in same stored procedure you can declare one table variable, you can insert result sets of both queries into this table variable.
After inserting data to your table variable you can select record from table variable.
Code snippet for declaring and inserting data to table variable is as below

DECLARE @ProductTotals TABLE
(
--Change your column name and type as per your need
  ProductID int,
  Revenue money
)
--Insert results of your first table
INSERT INTO @ProductTotals (ProductID, Revenue)
SELECT ProductID, SUM(UnitPrice * Quantity)
FROM OrderDetails1
GROUP BY ProductID
--Insert results of your second table 
INSERT INTO @ProductTotals (ProductID, Revenue)
SELECT ProductID, SUM(UnitPrice * Quantity)
FROM OrderDetails2
GROUP BY ProductID

--Last step to select data
SELECT * FROM @ProductTotals

This T-SQL code snippet is for your reference only, change your datatype and column name of table variable as per your need

Hope this will help you. If it works fine accept the solution otherwise revert back to me with your queries.
Thanks

By using Union ALL Operator it will fine..!
here i have to do some changes in the queary because there are some rules when we combine 2 queries using Union keywords..!

Rules to union data:

•Each query must have the same number of columns
•Each column must have compatible data types
•Column names for the final result set are taken from the first query
•ORDER BY and COMPUTE clauses can only be issued for the overall result set and not within each individual result set
•GROUP BY and HAVING clauses can only be issued for each individual result set and not for the overall result set...!



select t2.tableName as 'Table Name',t2.gametype as 'Limit',Convert(varchar,Convert(numeric(18,2),t2.smallblind)) + '/' + Convert(varchar,Convert(numeric(18,2),t2.bigblind)) as 'Stakes',t3.GameName as 'Game Name'
from tblgameinfo t1 join tblGameTables t2 on (t1.tableid=t2.tableid) join tblGames t3 on (t3.gameid = t1.gameid)
where (t2.skinid= 6 or t2.skinid= 0) and t1.nickname = 'Player1' --order by nickname


union all


Select t2.tablename as'Table Name',t1.TableID as 'Limit',t1.TournamentID as 'Stakes',t3.TournamentName'Game Name'
from tblRegistration t1 join tblGameTables_TRMNT t2 on t1.TableID=t2.TableID join tblTournaments t3 on t3.tournamentID=t1.TournamentID
where t3.skinid= 6 and t1.nickname='Player1' AND t1.Eliminated='N' and t1.TableID >-1 and t3.State='P' and t3.TournamentType='S'