Udostępnij za pośrednictwem

SQL DB Helper

  • Artykuł

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.

 

DBSqlHelper.dll

Comments

  • Anonymous
    May 22, 2008
    Thanks...Do you have a simple example using it?

  • Anonymous
    May 22, 2008
    there you go.. List<SqlParameter> arrSql = new List<SqlParameter>();                        SqlParameter currentDateParameter = new SqlParameter("@CurrentDate&quot;, SqlDbType.DateTime);                    currentDateParameter.Value = currentDate;                    arrSql.Add(currentDateParameter);                    resultSet = DBSQLHelper.GetDataTable("<Connstring>",                       "dbo.GetUsersToPlay",arrSql.ToArray()   );