Scott on Writing

Musings on technical writing...

Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available

My Working with Data in ASP.NET 2.0 tutorials have been updated to include the four newest tutorials, which illustrate working with database data directly from an ASP.NET web page. The previous 46 tutorials (as well as all tutorials following these four) looked at working with data through a layered architecture. But for one-off projects or prototyping, it may be preferable to use a SqlDataSource and avoid building the architecture. These four new tutorials illustrate various facets of working with the SqlDataSource control:

  • Querying Data with the SqlDataSource Control [VB | C#]
  • Using Parameterized Queries with the SqlDataSource [VB | C#]
  • Inserting, Updating, and Deleting Data with the SqlDataSource [VB | C#]
  • Implementing Optimistic Concurrency with the SqlDataSource [VB | C#]

Like the previous tutorials in the series, all tutorials are available in C# and VB, include the complete code download as a self-extracting ZIP, and are available in PDF format. Also, the layout of the tutorial homepage has been revamped and a new style has been applied for the individual tutorials.

There are more tutorials to be released in the upcoming weeks, including tutorials on working with binary data (images, PDFs, etc.), caching, and much more!

posted on Wednesday, February 21, 2007 9:02 AM

Feedback

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 2/21/2007 3:44 PM Andrew McCallum

I haven't seen anything in your tutorials which talk about database transactions. Where/how does the data access layer begin and end transactions?

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 2/22/2007 7:53 AM Scott Mitchell

Andrew, I have four upcoming tutorials on transactions. One talking about different ways of using transactions through Typed DataSets and then three that take that logic and implement batch data modification interfaces.

This should hit the ASP.NET website by April Fools day (April 1st, 2007). If you are in desperate need for this material, email me (mitchell@4guysfromrolla.com) and I can send you an advance copy.

Thanks

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 3/2/2007 7:20 AM Tom Sluder

Scott, I was wondering if you were planning any tutorials on sub-headings and sub-totaling (other than in the footer) in GridViews?

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 3/2/2007 9:29 AM Scott Mitchell

Tom, there are no such tutorials planned. Sorry!

For similar content on the ASP.NET 1.x DataGrid, though, check out the following:
http://aspnet.4guysfromrolla.com/articles/072603-1.aspx
http://datawebcontrols.com/faqs/DataLists/GroupingByCategory.shtml
http://aspnet.4guysfromrolla.com/articles/073003-1.aspx

Thanks!

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 4/24/2007 12:13 PM Master Shake

Unreadable! Time to switch to Rails where you can get work done in 1/3 of the time and your code doesn't look like poo.

Title:  
Name:  
Url:
Protected by Clearscreen.SharpHIPEnter the code you see:
Comments   

My Links

Ads Via DevMavens

Archives

Post Categories

 

I am a Microsoft MVP for ASP.NET.
I am an ASPInsider.
<March 2010>
SMTWTFS
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Comment Stats

DayTotal% of Total
Sunday 2056.8%
Monday 42514.1%
Tuesday 51917.2%
Wednesday 55618.4%
Thursday 58019.2%
Friday 54718.1%
Saturday 1886.2%
Total 3020100.0%

Hour1Total% of Total
12:00 AM 782.6%
1:00 AM 812.7%
2:00 AM 682.3%
3:00 AM 822.7%
4:00 AM 692.3%
5:00 AM 1264.2%
6:00 AM 1193.9%
7:00 AM 1816.0%
8:00 AM 1926.4%
9:00 AM 1585.2%
10:00 AM 1886.2%
11:00 AM 1936.4%
12:00 PM 2016.7%
1:00 PM 1846.1%
2:00 PM 1695.6%
3:00 PM 1354.5%
4:00 PM 1153.8%
5:00 PM 1073.5%
6:00 PM 1013.3%
7:00 PM 1073.5%
8:00 PM 923.0%
9:00 PM 882.9%
10:00 PM 913.0%
11:00 PM 953.1%
Total 3020100.0%

Comments by Blog Entry Date/Time

Day Entry MadeAvg.Total
Sunday 5.00160
Monday 4.80384
Tuesday 4.04477
Wednesday 7.39680
Thursday 6.26676
Friday 5.07466
Saturday 4.78177
Total 5.403020

Hour1 Entry MadeAvg.Total
12:00 AM 5.2937
1:00 AM 1.002
5:00 AM 0.000
7:00 AM 3.8550
8:00 AM 3.72134
9:00 AM 6.06297
10:00 AM 5.63276
11:00 AM 4.22194
12:00 PM 6.16351
1:00 PM 3.09133
2:00 PM 4.89230
3:00 PM 7.67322
4:00 PM 4.00108
5:00 PM 6.07170
6:00 PM 4.64116
7:00 PM 8.95188
8:00 PM 8.63164
9:00 PM 5.00115
10:00 PM 6.31101
11:00 PM 4.5732
Total 5.403020

Learn More About Comment Stats
1 - All times GMT -8...


Blog Stats

Favorite Web Sites

My Books

My MSDN Articles