For example, some databases expect YYYY-MM-DD type syntax for the SQL Date field while others might expect DD,MM,YYYY syntax. Databases can also have different SQL text escape requirements.

If the user enters data with an apostrophe into a text box, and you attempt to build and SQL string to execute, you get something like this in your string:<BR><BR><B>INSERT INTO MyTable ...

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...