473,397 Members | 2,077 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Implementing Paging on multiple grids

106 100+
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
Sep 17 '08 #1
2 1130
Curtis Rutland
3,256 Expert 2GB
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).
Sep 17 '08 #2
Frinavale
9,735 Expert Mod 8TB
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.
Sep 17 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Mathana g | last post by:
Hello Friends, When we bind custom collection object (which is populated with objects of custom class) to a Datagrid, the paging links(or numbers) are disabled and only first page number is...
0
by: IGotYourDotNet | last post by:
I have a page and I need to put multiple grids on it, (10 to be exact). The issue i'm having is sometime some grids have 3 records and sometimes they can have 20 records and what happens is that the...
5
by: LDD | last post by:
Hi Folks I'm trying to determine a way to handle paging, filtering and sorting in a datagrid. If I choose to filter and sort, I'd like to return a subset. If that resultset has more records...
2
by: serge calderara | last post by:
Dear all, I have an asp net 1.1 application with a datagrid bind to a datasource I am using tablemappings features to display column grids name I am using paging features which shows 10 pages at...
3
by: Logu Krishnan | last post by:
in short, the question is "How do i do custom paging in my asp.net grids" in SQL 2000. if i use default paging and if my db has ~200000 records, then i have to select all the 2 lac records then...
2
by: rn5a | last post by:
In a shopping cart app, a ASPX page retrieves the order details & personal details of a user from a MS-Access database table depending upon the username of the user. The order details of a...
2
by: ami | last post by:
In my code, I need to implement x numbers of Gridviews dynamically based on user selection. Because I am unaware of the number of gridviews, this is done after the user enters input. I need to...
7
by: =?Utf-8?B?TG9zdEluTUQ=?= | last post by:
Hi All :) I'm converting VB6 using True DBGrid Pro 8.0 to VB2005 using DataGridView. True DBGrid has a MultipleLines property that controls whether individual records span multiple lines. Is...
8
tharden3
by: tharden3 | last post by:
Hey all, I need some help with PHP code for paging my products on my site. I posted questions asking for help in the past, and was directed to this tutorial for help. The code that the tutorial gives...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.