Implementing Paging on multiple grids

[Hamayun Khan]

Hi

I have Two Sql tables that hold jobs information. The field names are same but data types are different. I want to select to data from both tables using union into one query. but someone told me that this is not possible. That is why I populate the data from both tables into two different grids. Both the grids have pagers that works fine. Now I want to Navigate on both grids using one pager.

If someone has some idea then please help. Its very urgent. If it is not possibe then please suggest some alternate method.
Thanks

[Curtis Rutland]

Well, you could UNION them, if you cast their values properly. Say, if Column1 is an int in table1, and a varchar(20) in table2, you could cast column1 in table1 as nvarchar(20).

[Frinavale]

Well, you could UNION them, if you cast their values properly. Say, if Column1 is an int in table1, and a varchar(20) in table2, you could cast column1 in table1 as nvarchar(20).

Just watch out if you are using the GridView to update the tables. You don't want to try storing the wrong data type in the database tables.