Asp.net, listbox, htc, behavior, autosearch listbox, wcf, certificate SQL DB Helper - Discoveries / Experiences in .Net Application development - Site Home - MSDN Blogs

Discoveries / Experiences in .Net Application development

Discoveries during Web Application development using Asp.Net, C# etc

SQL DB Helper

SQL DB Helper

Rate This
  • Comments 2

this is a helper dll which helps to talk to sql databases during development.

the developer doesnt need to worry abt sql command objects , connections etc.

All we need to pass is the Connection string, stored proc name , Sql Parameters if any.

chk it out.

This was tested with Sql server 2005 / Sp2.

 

Attachment: DBSqlHelper.dll
  • Thanks...Do you have a simple example using it?

  • there you go..

    List<SqlParameter> arrSql = new List<SqlParameter>();    

                       SqlParameter currentDateParameter = new SqlParameter("@CurrentDate", SqlDbType.DateTime);

                       currentDateParameter.Value = currentDate;

                       arrSql.Add(currentDateParameter);

                       resultSet = DBSQLHelper.GetDataTable("<Connstring>",

                          "dbo.GetUsersToPlay",arrSql.ToArray()   );

Page 1 of 1 (2 items)
Leave a Comment
  • Please add 2 and 6 and type the answer here:
  • Post