Thursday, May 3, 2012

DataAccess without SqlDataReader


DataAccess class:

public void GetGugus(string kdggs)
        {
            string spName = "spr_tutorial_load_gugus";

            SqlParameter[] parameters = new SqlParameter[1];

            parameters[0] = new SqlParameter("@kdggs", SqlDbType.Char, 2);
            parameters[0].Direction = ParameterDirection.Input;
            parameters[0].Value = kdggs;

            SqlHelper.ExecuteNonQuery(UserManagementConfiguration.TutorialConnectionString, CommandType.StoredProcedure, spName, parameters);
        }


Note: SqlHelper is a function using Microsoft.ApplicationBlocks.Data;

No comments:

Post a Comment