I'm working with an ASP.Net 4.0 project, and I'm calling a stored procedure on a SQL 2008 64-bit server. When I call the stored procedure, I don't get an error message, but the stored procedure doesn't do anything. When I call the stored proc natively in SQL Management Studio, it works fine. I've walked through the code in the ...

I wrote some quick and dirty ADO.NET code to go against an RSS feed instead of a flat XML file today.  In the process I had to figure a way to limit the number of rows returned by the function, which returns a DataTable.  The simplest method I found was this one, which uses the DataTable.Select() method.  Using this technique, you ...

For an admin application I've been working on, we're using a third party reporting tool to serve up reports to our users over the Internet.  The reports have a nice designer that works with XSD files in Visual Studio.  Not particularly fond of XSDs as a means of data access, I thought I would limit the damage by having only one of them ...

I had a situation where I was using a DataSourceControl (actually an LLBLGenProDataSource2,which inherits from DataSourceControl) bound to a grid, and I wanted the grid to refresh its contents whenever I added or deleted an item from it.  I discovered a neat trick noted here, which is that if you touch the SelectParameters collection of the ...

Frans announced yesterday that LLBLGen 2.0 has been released!  I’ve been using LLBLGen happily for several years now.  It is a very solid ORM tool and I’m looking forward to using the new version going forward.  You can read a list of new features and enhancements here.  If you haven’t used LLBLGen before, I ...

A new site I'm using to push me updates of interesting blogs is DotNetSlackers.com.  Sign up for their mail service, and you'll get a single daily email with that day's posts arranged by keyword category.  I've been pretty lax in firing up my RSS aggregator client, so this is a good way for me to at least make sure I'm not missing ...

Julie and I were having issues with getting Sql Query Notifications to work for ASP.NET cache dependencies (for our DevConnections talks).  The trick was this: sp_dbcmptlevel yourdatabasename,90 Julie did most of the research on this one, with help from Sushil Chordia and Leonid Tsybert from Microsoft.  She has more on her blog, but ...

I found this post by Rushi Desai on Invalidating cached result sets using SQL Server Query Notification.  It's from March so it's a bit out of date, but it has some working ASP.NET sample code (well, working in Beta 2, I presume, but pretty close for RTM).

I'm working on my caching presentation for Fall ASP.NET Connections and a few user group presentations.  Those few who read my blog can enjoy some early looks at my research, which I'll detail here for my own future reference (and yours!). First of all I only recently found a great article on Query Notifications in ADO.NET 2.0 ...