Retrieving Data

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

William
Wed Jun 02 12:55:36 CDT 2004

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
"Sammy" <sammy@spam.com> wrote in message
news:usosGkMSEHA.3348@TK2MSFTNGP09.phx.gbl...
> 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
>
>

Sammy
Wed Jun 02 15:23:03 CDT 2004

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

"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:%23VA8loMSEHA.2000@TK2MSFTNGP11.phx.gbl...
> 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
> "Sammy" <sammy@spam.com> wrote in message
> news:usosGkMSEHA.3348@TK2MSFTNGP09.phx.gbl...
> > 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
> >
> >
>
>