C# (CSharp) Project_Dap.BL.DAL DataAccessLayer Beispiele

Beispiel #1

Datei: CLS_LOGIN.cs Projekt: abayoss/ADO_ProjectDap_ProductManagement

        public void EDIT_USER(string ID, string FullName, string PWD,
                              string UserType)
        {
            DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
            DAL.Open();
            SqlParameter[] param = new SqlParameter[4];
            param[0]       = new SqlParameter("@ID", SqlDbType.VarChar, 50);
            param[0].Value = ID;

            param[1]       = new SqlParameter("@FullName", SqlDbType.VarChar, 50);
            param[1].Value = FullName;

            param[2]       = new SqlParameter("@PWD", SqlDbType.VarChar, 50);
            param[2].Value = PWD;

            param[3]       = new SqlParameter("@UserType", SqlDbType.VarChar, 50);
            param[3].Value = UserType;


            DAL.ExecuteCommand("EDIT_USER", param);
            DAL.close();
        }