READ THIS, GARGOYLES.. Even if you have been posting on the internet for 57 years..

[cjard]

I'll keep this brief:

.NET 1.1 (2003) and .NET 2.0 (2005) ARE VERY DIFFERENT WHEN IT COMES TO ADO.NET

Please say what version of .net you are using

Also say what database youre using


This avoids wasting the experts time giving an answer that doesnt apply to you, or drilling you for vital information necessary to help you.
Remember; forums are about helping others to help you. Help them first, by making a very informative post. Include code where possible and try and tell us what you are hoping to achieve, not just what problem you have encountered with your envisaged solution - your solution may not be a good way to reach the goal. If we know the goal, we can help devise a good solution, rather than fix up a bad one.

[TheCPUWizard]

Good advice, not to mention some of the changes that come with 3.0

[cjard]

eyh... i havent even looked at it so far.. Maybe next year when people start to use it!