示例#1
0
        public bool updateGiaoVien(Entities.tblGiaoVien sv)
        {
            bool   check = false;
            string sql   = "sp_tblGiaoVien_Update";

            try
            {
                con = ds.getConnect();
                cmd = new SqlCommand(sql, con);
                con.Open();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = sql;
                cmd.Connection  = con;
                cmd.Parameters.Add("@id", SqlDbType.Int).Value         = sv.Id;
                cmd.Parameters.Add("@idchucvu", SqlDbType.Int).Value   = sv.Idchucvu;
                cmd.Parameters.Add("@idlop", SqlDbType.Int).Value      = sv.Idlop;
                cmd.Parameters.Add("@idkhoa", SqlDbType.Int).Value     = sv.Idkhoa;
                cmd.Parameters.Add("@idmonhoc", SqlDbType.Int).Value   = sv.Idmonhoc;
                cmd.Parameters.Add("@idtaikhoan", SqlDbType.Int).Value = sv.Idtaikhoan;
                cmd.ExecuteNonQuery();
                check = true;
            }
            catch (Exception ex)
            {
                ex.ToString();
            }
            finally
            {
                cmd.Dispose();
                con.Close();
            }
            return(check);
        }