Geeks With Blogs

News Ashraful Alam Joy

Create Your Badge

Ashraful Alam is a Software Architect, who has 8 years of professional experience in Software Development industry. This Bangladeshi national is involved with project management and development of several US based software projects from his country. Already he has managed and developed several software projects, which are being used by several users of different countries, such as USA, Canada, Australia, and Bangladesh. While developing and managing a team, he contains and maintains a set of well defined engineering practices developed by him and other online developer communities.

Due to his willingness to give effort to improve and share better software development practices, Ashraf has been awarded as “Most Valuable Professional” (MVP) in ASP.NET category by Microsoft since year 2007 multiple times, which is a rare honor and prestigious reorganization among the developers around the world.

Check his portfolio to know more about him and his works.


.NETTER Characters... Every part of your life is best, if you can know yourself and thus create your life like an artist!

DAAB definitely saves the lines of codes to be written for data access. The sample provided below doesn’t include DAAB, but some general codes in .net 2.0 for data access:

       string connectionString = (string)ConfigurationSettings.AppSettings["ConnectionString"];

       SqlConnection connection = new SqlConnection(connectionString);

       SqlCommand command = new SqlCommand("INSERT_PERSON", connection);

       command.CommandType = CommandType.StoredProcedure;

       command.Parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar, 50));

       command.Parameters["@Name"].Value = "Ashraf";

       command.Parameters.Add(new SqlParameter("@Age", SqlDbType.NVarChar, 10));

       command.Parameters["@Age"].Value = "27";

       connection.Open();

       command.ExecuteNonQuery();

       connection.Close();

 The task can be done using DAAB very simply:

 //using Microsoft.ApplicationBlocks.Data;

 SqlHelper.ExecuteNonQuery(connection,"INSERT_PERSON", new  SqlParameter("@Name","Ashraf") , new SqlParameter("@Age", "27") );

Posted on Friday, July 7, 2006 3:53 PM Implementation , Database , .NET , Software Development | Back to top


Comments on this post: Using Data Access Application Block for .NET 2.0

# re: Using Data Access Application Block for .NET 2.0
Requesting Gravatar...
how to create dll for c# window application?
Left by james on Jan 05, 2010 8:54 PM

Your comment:
 (will show your gravatar)


Copyright © Ashraf Alam | Powered by: GeeksWithBlogs.net