An Easy Way To Query a Database

woric

Rate me:

0.00/5 (No votes)

14 Feb 2011CPOL

6.3K

The sample code provided by Andrew Rissing is a huge improvement over the original, but incorrectly catches the exception and displays a MessageBox. (Andrew correctly points out this is not a good idea.)A better solution is to allow the exception to fail:public DataSet...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. An Easy Way To Query a Database

14 Feb 2011Andrew Rissing

The following samples should take advantage of using statements and furthermore built in features of the ADO.NET framework. Furthermore, if you open a connection, make sure you open it at the latest time possible and close it as soon as possible.Edit: While I was originally not trying to...

2. An Easy Way To Query a Database

23 Feb 2011PrimeCoder

Nice,How about adding a couple of other methodspublic static void Parameter(IDbCommand command, string naam, object value){ IDbDataParameter par = command.CreateParameter(); par.ParameterName = naam; par.Value = value ?? DBNull.Value; ...

3. An Easy Way To Query a Database

29 Apr 2011dontumindit

4 alternatives

An Easy Way To Query a Database

4. An Easy Way To Query a Database

14 Feb 2011FZelle

You are both wrong with the DataAdapter.Why do you think there is an overload with the querystring and the connectionstring?public DataSet select_query(string query, string con_str){ try { using (SqlDataAdapter da = new SqlDataAdapter(query,con_str)) { ...