microsoft.public.sqlserver.programming

TheSQLGuru

3/31/2007 12:36:00 PM

Always try to use a DataReader if you can. SIGNIFICANTLY more efficient.
There are only a few situations where you must use a dataset, such as
needing multiple tables set up with referential integrity for example.

--
TheSQLGuru
President
Indicium Resources, Inc.

"yshie via SQLMonster.com" <u32884@uwe> wrote in message
news:6ffe77e2d424a@uwe...
> visual studio 2005
> ms sql server
>
> how will i know if i need to use a dataadapter and dataset? do i need to
> use
> them everytime i have sqlcommand?
>
> because i will create a data binding code and i don't know if i need to
> create dataadapter and dataset. i have 4 textboxes and i will fill only
> the
> userID textbox. if i click the submit button, all info about the userID
> will
> display in the remaining textboxes. so, what's the recommended way to do
> this?
> tnx!
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programmin...
>