Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
microsoft.public.sqlserver.programming
dataadapter and dataset
yshie
3/31/2007 8:19:00 AM
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...
1 Answer
TheSQLGuru
3/31/2007 12:36:00 PM
0
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...
>
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
dataadapter and dataset
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password