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.
<February 2010>
SMTWTFS
31123456
78910111213
14151617181920
21222324252627
28123456
78910111213

Comment Stats

DayTotal% of Total
Sunday 2046.8%
Monday 42514.1%
Tuesday 51617.1%
Wednesday 55318.4%
Thursday 58019.2%
Friday 54718.2%
Saturday 1886.2%
Total 3013100.0%

Hour1Total% of Total
12:00 AM 772.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 1183.9%
7:00 AM 1806.0%
8:00 AM 1926.4%
9:00 AM 1585.2%
10:00 AM 1876.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 1063.5%
6:00 PM 1013.4%
7:00 PM 1073.6%
8:00 PM 923.1%
9:00 PM 882.9%
10:00 PM 893.0%
11:00 PM 953.2%
Total 3013100.0%

Comments by Blog Entry Date/Time

Day Entry MadeAvg.Total
Sunday 4.94158
Monday 4.80384
Tuesday 4.08477
Wednesday 7.47680
Thursday 6.25675
Friday 5.02462
Saturday 4.78177
Total 5.413013

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.02295
10:00 AM 5.63276
11:00 AM 4.20193
12:00 PM 6.14350
1:00 PM 3.17133
2:00 PM 5.00230
3:00 PM 7.62320
4:00 PM 4.00108
5:00 PM 6.04169
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.413013

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


Blog Stats

Favorite Web Sites

My Books

My MSDN Articles