Welcome to AspAdvice Sign in | Join | Help

Browse by Tags

All Tags » ADO.NET   (RSS)
Tuesday, October 30, 2007 3:30 PM

Limit Rows In DataTable or DataSet

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
Posted by ssmith | 2 Comments
Filed under: , , ,
Friday, September 14, 2007 10:44 PM

Using PowerShell to Automate a SQL Task

I have a very large table in a SQL database that I need to clean up some old data on. I've already copied all of the data to another table in another database with a different schema. I have a legacy application that still uses the old data, but the data
Posted by ssmith | 5 Comments
Filed under: , ,
Wednesday, September 05, 2007 11:38 AM

Managing XSD Files - if you must have them

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
Posted by ssmith | 1 Comments
Filed under: , ,
Saturday, August 25, 2007 1:58 AM

Force Refresh of DataSourceControl

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
Posted by ssmith | 6 Comments
Filed under: , ,
Monday, July 03, 2006 9:26 AM

LLBLGen v2 Released

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
Posted by ssmith | 0 Comments
Filed under: , , ,
Friday, March 24, 2006 6:01 PM

Get Date From DateTime In SQL

Something I need to do from time to time is get just the date part of a datetime value in SQL. I found a cool way to do it on SQLJunkies today. select convert(varchar,DateColumn,101) The 101 means “mm/dd/yyyy” format, but there are a bunch of other codes
Posted by ssmith | 11 Comments
Filed under:
Monday, October 10, 2005 12:26 AM

New Site: DotNetSlackers

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
Posted by ssmith | 4 Comments
Wednesday, September 07, 2005 4:09 PM

Old Databases and Sql Query Notifications (cache invalidation)

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
Posted by ssmith | 1 Comments
Filed under: , ,
Friday, August 26, 2005 2:45 PM

More on SQL Server Query Notifications

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
Posted by ssmith | 0 Comments
Filed under: ,
Friday, August 26, 2005 12:36 PM

Working on Caching Presentation

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
Posted by ssmith | 0 Comments
Filed under: ,