By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,871 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,871 IT Pros & Developers. It's quick & easy.

ADO.NET DataSet woes

P: n/a
Tim
Joe,

If the two tables have a relation, then join the two
tables in a query and populate your dataset with the
query, instead of with the data from the tables. Good
luck.

Tim
-----Original Message-----
This is probably really simple, I just haven't figured
out how ADO.NET does it yet.

I have created 2 DataAdapters in Visual Studios .NET C#
from 2 tables in SQL Server related to one another, and
created a DataSet from these 2 tables.

For example:
Table 1: staff_id, type_id
Table 2: type_id, type_name

I want to show the type_name of the currently selected
staff_id.

I have 2 textboxes on a form, one bound to the type_id in
the first table, and the other bound to type_name in the
second.

Is there any way within the Dataset to "bind" these 2
tables together so that moving to the next record in
Table 1 moves to the correct record in Table 2, or do I
have to code this in when the next record is selected?

Thanks for your help,
Joe

.

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.