.NETTER Characters...

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") );

• Share This Post:
• 
• 
•