Retrieving Data

  • Thread starter Thread starter Sammy
  • Start date Start date
S

Sammy

Hi,

I am having problem designing my business objects to retrieve data from a
SQL Server. The data structure is very similar to Northwind (Order-Order
Details...) however much more complex. I was looking at using inner joins
in a complex SQL Select statement however there are too many parent-child
relationships to handle. So, I decided to break up it up into multiple
select statements. I have a few questions:

1) I allow the user to search by Order Number, Serial Number and Customer
Name. I display the results in a datagrid. My question is it a good design
to select only the order details info (which I display in the datagrid) and
wait to retrieve the rest of the data when the user selects that info?

2) Any other suggestions on how to retrieve data would be appreciated!

Thanks
 
Do this with dataRelations, it will be a LOT easier !

http://www.knowdotnet.com/articles/datarelation.html

Once you have this in place, you can bind a combobox or similar control to
the parent table, when a record is selected, the corresponding other info
will automatically appear in the bindings. Also, at the same site i have a
bunch of stuff on Filtering, Finding and Sorting (Effiiciently Using ADO.NET
xxx which will be helpful).

Cheers,

Bill

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp
 
William,

Thanks for the response. I already have the data relations built because I
am using typed datasets as my business entities. My question is more
pertaining to the actual design of how to retrieve data with a data
structure of many tables.

Thanks
 
Back
Top