(from "Top Questions about DataGrid Web Server Control")

I know this is easy, but never seem to remember the syntax for the EditItemTemplate stuff.

Top Questions about the DataGrid Web Server Control

Static text for label:
Text='<%# DataBinder.Eval(Container, "DataItem.genre") %>'

DropDownList bound to DataSet:
<asp:DropDownList id=DropDownList4 runat="server"
DataSource="<%# DsBooks1 %>" DataMember="Genre"
DataTextField="genre" DataValueField="genre" Width="160px">

---

Same article has this snippet about checkboxes in the datagrid, like you'd see in hotmail, etc.

Some high level info about what perfmon counters to look at for ASP.NET apps.

Monitoring ASP.NET Application Performance

(from there, go up a couple chapter levels to ASP.NET optimization)

More info on AspCompat page directive. Not sure who authored this, but it's a quick few lines summary of what is accomplished with this setting, and what's the impact.

ASP.NET FAQ

How to Share Session State Between Classic ASP and ASP.NET

OK, here's the info I was thinking about. Shouldn't store an STA COM component in Session state since it will pin requests to that single thread that created the object.

A quote from the article:
You should never store any STA COM component in a shared resource where it can be accessed by threads other than the one that constructed it. This includes the cache and session state, for example.

Will have to come up with a way to prove this to myself...
Spit out thread ID in the page, and hammer a bunch of requests at it?

ASP.NET Optimization

This article on .NET performance reminds me about the issues with storing an STA object in Application state. I think it causes all subsequent requests to be run on the same single thread, so that the object will only be hit by that thread.

Now I'm wondering how this works with session state - cuz that's suspiciously the problem we're having at work...

Checklists

This is an OLD article (2001), but some interop issues have come up at work making me search a bit for STA / MTA issues, blocking, etc. There are a few thoughts in this article.

(search for "essentially") -- "avoid STA COM"

.NET General

This google search shows a PowerPoint that I want to check out. ASP.NET and COM interop in IIS 6.

PPT is here

Google Search: "asp.net" asp "com " interop

Had some questions about lock(this) today at work. Here's a Jeffrey Richter MSDN mag article about thread synchronization issues.

.NET: Safe Thread Synchronization -- MSDN Magazine, January 2003: "Lock"

---

Dr. GUI chimes in with thoughts on why you shouldn't lock on typeof(someObj)

Thanks to Charles for this link. Apparently some issues with garbage collection and interoperability in .NET when running on multiprocessor machines.

TheServerSide.NET - Tales from the Dump: Garbage Collection and Interoperability in .NET

Company makes asp.net control that makes aspx page calls without refreshing the page.

Dart Communications - Visual Studio Component Lab

Pretty much a rip off of the XmlHttp functionality of the MSXML control from old days, where you can go hit a URL, get the data, then use DHTML to render the results in some section of the page.

In the talk, the camera man basically describes the implementation just as I describe above -- control renders some javascript and uses MSXML XmlHttp request object.

The updating of the textbox without refresh is interesting, must use jscript and DHTML internally to do events like KeyPress.

Playing with Application Center Test on my XP machine, hitting a Windows Server 2003 machine. Getting the error Could not bind to Windows Management on a test client.

This article seems to fix the problem.

PRB: Error Message: Could Not Bind to Windows Management on a Test Client

If this article is dead someday, quick answer:

• open the WMI Control MMC snap-in
  
• grant "ACTUser" full control of the following node: root\CimV2\Applications\MicrosoftACT
  

A trip down memory lane to see where we've been with "Rich" clients, then what makes up a "smart" client, and where we might be headed...

David Hill's WebLog : What is a Smart Client anyway?

---

...and from the same author, a case study about Dell making the move towards smart clients, and loving it.

---

Smart Client architecture and design guide at MSDN

and PDF version of the whole document for offline viewing

---

Finally, the Smart Client Developer Center at MSDN

Some quick links and such for debugging sql in Query Analyzer.

Looks like there are some diffs if you have SQL Server sp 3

Google Groups : microsoft.public.sqlserver.server

Walkthrough of debugging SQL Stored Procedure. Uses Visual Studio, and SQL Server 7 or higher. Requires Remote Components setup on server, sql server permissions, configure DCOM on sql server, etc.

Debugging SQL

Coding4Fun has this upscale version of my "URL newline remover" application.

This one watches the clipboard for text that resembles a URL, and handles newlines, >> from emails, etc.

Coding4Fun: URLBuddy

Stuff to check out -- Visual Studio Team System Walkthrough

A Unit Testing Walkthrough with Visual Studio Team Test

Should check out this SQL 2005 presentation.

Download details: SQL Server 2005 Internals - .ppt presentation

keywords: db database sql t-sql tsql c#