473,399 Members | 2,278 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,399 software developers and data experts.

which dataset to use?

I am working on a simple three table project to get started with web
services. The first two tables are essentially string lookup tables,
and the third has foreign keys to the primary keys in the first two
tables. Here's the layout (more or less):

table color
int uid [pkey]
string color

table boxsize
int uid [pkey]
string boxsize

table box
int uid [pkey]
int cuid [fkey to color.uid]
int bsuid [fkey to boxsize.uid]
string serialnumber

So my service looks like this:

GetColor
UpdateColor
GetBoxsize
UpdateBoxsize
GetBox
UpdateBox

GetColor returns a dataset with one table in it and GetBoxsize returns
a dataset with one table in it. I just added GetBox, and because of
the foreign key relations, it has all three tables in it.

So in the web client I have access to:

color.color
boxsize.boxsize
box.color
box.boxsize
box.box

So, my question is: should I use box.color or color.color to access
color? I have been using color.color, but now I have access to
box.color, and thus I have a choice. Will the code function
differently based on the one I pick? If I change box.color,
box.boxsize, and box.box, then call UpdateBox, will all three tables
update correctly?

Nov 23 '05 #1
0 809

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

Similar topics

1
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
by: | last post by:
Consider the following: I have a socket server that converts the incoming data to astring. Each reception of data is to be stored in a new row ofa dataset. Is it cheaper (in the sense of...
2
by: Nedu N | last post by:
Hi Techies, 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...
3
by: Mark | last post by:
Hi - when working with datasets, is it quicker to loop through the dataset, comparing some column values with predetermined values, or should I apply a filter on the dataset to retrieve the values...
1
by: ad | last post by:
I have a dataset with a datatable, which data is select from to table like SELECT Categories.CategoryID, Categories.CategoryName, Products.ProductID, Products.ProductName FROM ...
7
by: sameer | last post by:
Hi all, Application environment : VB.Net desktop application,.NET 1.1 Framework, VS 2003. communicates between the database and the application is done over webservices using ADO.NEt Datasets....
0
by: JP2006 | last post by:
I'm having an issue with a control I'm writing to consume RSS feeds. It gets a feed via a querystring parameter and sticks it in a dataset. I then use the dataset to write out the feed title and...
6
by: alexia.bee | last post by:
Hi all, I am new to C# so please bear me :). I have an app which uses datagridview. it has 8 columns. I also have struct which has 8 members(the same as the datagridview). when I add row to...
2
by: Edwin Smith | last post by:
Hello: I have a form which I would like to fill with data from one row of an ODBC database table. I have created the Table adapter and I have a query: SELECT PATIENT.Name, PATIENT.address...
4
by: Jimmy | last post by:
Hi, The other day, my boss corrected me to use "explicit qualification" instead of using "using directive". she asked me to use : "System.Data.DataSet ds = new System.Data.DataSet();" ...
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
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
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
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
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...

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.