ExamGuru IT/.Net Guru : Using a dataset's rowstate functionality in .net on microsoft.public.dotnet.framework.adonet

.NETGURU

Using a dataset's rowstate functionality in .net

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.adonet.

GrantMagic

I tend to use the SqlDataAdapter class in WinForms projects because once the
inital data is loaded any modifications can be easily added/updated through
a call to the Update() method. I've found in aspnet that the same thing is
possible but because of the stateless nature of the web in order to do this
I have to go through the following steps:

1. First visit to page loads DataSet and binds DataList with data
2. User edits data and submits the pages
3. Reload the DataSet with original data as in 1.
4. Iterate through the DataList and updates rows in the DataSet
5. Call the Update() method to update edited rows

Now am I doing this correctly or is there any way I can skip step 3? It
seems easier to just update each row in the DataList than go through the
process of only updating modified rows.

Reply to this message...

Miha Markic [MVP C#]

Hi,

You might cache the datataset you use for binding - you'll skip 3. then.
Or, you might manually create a dataset (from modified data) and update it.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"GrantMagic" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

GrantMagic

ok, thanks

How will that effect multiple users.
Will they each get their own section in the cache, or will the same cache
get utilised?

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

Miha Markic [MVP C#]

Hi Grant,

That depends on you as you have several options to cache it. :-)
For example, if you store it within session then it is per user, if you
store it in the cache then it is global.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"GrantMagic" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

	System.Data.DataSet
	System.Data.SqlClient.SqlDataAdapter
	System.Web.UI.WebControls.DataList

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification