Search:   Namespaces Discussions .NET v1.1 Feedback

advice needed - what approach for sql access Messages   Related Types This message was discovered on microsoft.public.dotnet.faqs. Post a new message to this list... KavvY After messing about I've made some headway towards getting a DataSet filled with data from an SQL database, unfortunately I've been advised that this isn't the way forward due to the overhead involved of filling the DataSet with every page access. So what method is prefereable to use? Am I supposed to create a DataAdapter that only fetches a certain query, dependant on what the users type in fields? Or am I supposed to use a DataSet in the same way? The book I bought is pretty useless in the respect that it focuses on the DataSet as the all-encompasing solution to all your needs. Which I debate TBH. All I want to do is execute SQL queries and put the results in to text boxes, then update the SQL tables with an update query afterwards.... Any advice greatly appreciated. Rich. Reply to this message...        CT One option is to cache the DataSet in the Session or ViewState. I can't tell how much data you're retrieving, but that obviously affects what is the "right" approach for you. If you need to display and update data, the DataSet is most likely your best choice. Are you extracting data from just one table, in which case you might just need the populate a DataTable object instead of a DataSet. -- Carsten Thomsen Enterprise Development with VS .NET, UML, and MSF http://www.apress.com/book/bookDisplay.html?bID=105 "KavvY" <k@u.r> wrote in message news:ODcJc.3026$Click here to reveal e-mail address... [Original message clipped] Reply to this message...     System.Data.Common.DataAdapter System.Data.DataSet System.Data.DataTable Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com