473,503 Members | 2,082 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Typed Dataset with multiple tables

Hi,

I have generated a typed dataset containing two tables in vs2005. Tables
have one to many relationship. I would like to populate both the tables
using preferably just one call to stored procedures which return data for
both the tables. What is the best way to do it? Do I need to write custom
code using generic untyped dataset or is there any simpler/faster/better
way?

Thanks
SG
Jun 24 '07 #1
2 5989
Hi,
Check the following Links:
http://weblogs.asp.net/scottgu/archi...15/435498.aspx

http://www.devsource.com/article2/0,1895,1834300,00.asp
Husam Al-aƔraj
www.aaraj.net
"Gugale at Lincoln" wrote:
Hi,

I have generated a typed dataset containing two tables in vs2005. Tables
have one to many relationship. I would like to populate both the tables
using preferably just one call to stored procedures which return data for
both the tables. What is the best way to do it? Do I need to write custom
code using generic untyped dataset or is there any simpler/faster/better
way?

Thanks
SG
Jun 24 '07 #2

I show a custom (strong typed) dataset example here:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!139.entry
1 db call, multiple tables populated.


"Gugale at Lincoln" <gu**************@gmail.comwrote in message
news:9s*****************@newssvr25.news.prodigy.ne t...
Hi,

I have generated a typed dataset containing two tables in vs2005. Tables
have one to many relationship. I would like to populate both the tables
using preferably just one call to stored procedures which return data for
both the tables. What is the best way to do it? Do I need to write custom
code using generic untyped dataset or is there any simpler/faster/better
way?

Thanks
SG


Jun 25 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1676
by: Natehop | last post by:
I've been attempting to design an n-tiered framework leveraging .NET's strongly typed Dataset. My Framework will serve as the foundation to several client apps from Windows applications to web...
1
1701
by: Nedu N | last post by:
Hi All, I am facing problem in copying content of table from a untyped dataset into to a table inside the typed dataset. I wanted to copy the data into typed dataset in order to ease the further...
1
1490
by: Andre Ranieri | last post by:
I'm designing an extranet web site that customers will use to log in and see their account history, make payments against their balance, etc. I've declared a strongly typed DataSet as a public...
1
287
by: Mythran | last post by:
Which would be the better solution? 1.) 20 Tables In 1 DataSet, no relationships. 2.) 20 DataSet's with 1 Table each. The tables have no relationship with each other (although they...
3
2419
by: Chris Thunell | last post by:
I have 2 forms, on 1 form i use the wizards to create a strong typed dataset with tables from an SQL database... and from that i can do stuff like: me.daEmployee.fill(me.dataset11.tblEmployee) ...
4
2594
by: Dave Taylor | last post by:
I've been using the dataset designer in Visual Studio to create typed datasets for my application by dragging over tables from the Server Explorer and dropping them into the designer. The problem...
8
6868
by: Dot Net Newbie | last post by:
New to DOTNET so please be gentle: I have an in-memory dataset that I want move to a SQL Server database. The XML schema with which the dataset was built matches exactly the table schema in SQL...
21
2390
by: Peter Bradley | last post by:
Hi all, This post is sort of tangentially related to my earlier posts on configuration files for DLLs. Does anyone know how to create typed DataSets using VS2005's new DataSet designer, but...
4
3091
by: Rachana | last post by:
Hi, I have understood Data Sets but what is meant by typed/untyped/ strongly typed datasets. Can any one explain me or suggest any site/ article, to get these concepts (and their ...
0
7205
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7093
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7287
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
7353
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...
1
7011
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...
1
5023
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3180
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3170
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
401
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.