The connection string to a database should never be hard coded in your application. There is (almost) always a difference between the development and production database server. Besides that IT management should have an easy way to change the configuration. Part of this has been automated by the wizards...

Another story from the app with the sprocs . That was a classical 2-tier CS application which we transformed into an asp.net 1.1 app. Once a year the application has to copy and transform huge amounts of data. This is done by running a batch of stored procedures which run in one huge transaction after...

Last week another rant on stored procs in databases passed by. A lot on it has been said over and over again but still I would like to add my 2 eurocents. Recently I inherited a database which contained a lot of sprocs and other coded logic. So I was forced into some more real world experience. The thing...

The term RAD is more or less a hot topic on Codebetter. It started with a "RAD kills" post by Jeffrey which lead many people to chime in. As I almost glorified RAD it's time to write something more elaborate on how I think you can work with RAD without making a mess out of it. This will dance around...

In the Crystal days adding reports to an asp.net application could give you quite a hard time. Having dropped crystal in favor of sql reporting services (so far) just annoying little stuff keeps me busy. In this post I'll demonstrate how to add RS reports to an asp.net application and concentrate...

Having used both Crystal Reports (CR) and SQL Reporting Services (RS) for a web-app I'm fully convinced. I've had enough of CR for once and for all. Oh yes, I have build great reports with CR but it was a bumpy road. Getting it all to work was favorite blog fodder , the many responses tell I'm not the...

In my apps I organize all interaction with my databases in components . On my component is a connection to the database and a couple of data-adapters to read and write data. These components are housed in a separate assembly. From there I can use them straight to fill the datasets on my web– or win-forms...

In a recent post I wrote some things on a datagrid and what to do over roundtrips. In a comment John asked me what I did with the data over the roundtrips. He mentions 4 ways to store it. I always use the first one: a full reread from the DB on every roundtrip. This is my situation: The data might be...

I had to miss the codeworse april fools joke. Spent the day doing my presentation on objectdatasources with VS 2005. On beforehand my main concern was setting up the hardware. Had to run VS 2005 from an external hard disk in 300Mb of memory. The sql server was running on another notebook. All was tied...

In ASP.NET 2.0 the gridview control is quite nice. By just setting some properties you can create a web application whose grid data can be edited by the end-user without the need to write all the plumbing code by hand. Which is quite a big step forward from 1.x. For this to work the gridview communciates...