dataset1.cs

《学籍管理系统》 “c# WinForm 数据库操作的简单范例 （SQL Server 2000）”

            
            internal DataColumn 来自何校Column {
                get {
                    return this.column来自何校;
                }
            }
            
            internal DataColumn 政治面貌Column {
                get {
                    return this.column政治面貌;
                }
            }
            
            internal DataColumn 备注Column {
                get {
                    return this.column备注;
                }
            }
            
            internal DataColumn 照片Column {
                get {
                    return this.column照片;
                }
            }
            
            public EssentialInfoRow this[int index] {
                get {
                    return ((EssentialInfoRow)(this.Rows[index]));
                }
            }
            
            public event EssentialInfoRowChangeEventHandler EssentialInfoRowChanged;
            
            public event EssentialInfoRowChangeEventHandler EssentialInfoRowChanging;
            
            public event EssentialInfoRowChangeEventHandler EssentialInfoRowDeleted;
            
            public event EssentialInfoRowChangeEventHandler EssentialInfoRowDeleting;
            
            public void AddEssentialInfoRow(EssentialInfoRow row) {
                this.Rows.Add(row);
            }
            
            public EssentialInfoRow AddEssentialInfoRow(string 姓名, string 性别, string 学号, string 学院, string 专业, string 班级, string 电话, string 出生年月, string 民族, string 籍贯, string 住址, string 来自何校, string 政治面貌, string 备注, System.Byte[] 照片) {
                EssentialInfoRow rowEssentialInfoRow = ((EssentialInfoRow)(this.NewRow()));
                rowEssentialInfoRow.ItemArray = new object[] {
                        姓名,
                        性别,
                        学号,
                        学院,
                        专业,
                        班级,
                        电话,
                        出生年月,
                        民族,
                        籍贯,
                        住址,
                        来自何校,
                        政治面貌,
                        备注,
                        照片};
                this.Rows.Add(rowEssentialInfoRow);
                return rowEssentialInfoRow;
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                EssentialInfoDataTable cln = ((EssentialInfoDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new EssentialInfoDataTable();
            }
            
            internal void InitVars() {
                this.column姓名 = this.Columns["姓名"];
                this.column性别 = this.Columns["性别"];
                this.column学号 = this.Columns["学号"];
                this.column学院 = this.Columns["学院"];
                this.column专业 = this.Columns["专业"];
                this.column班级 = this.Columns["班级"];
                this.column电话 = this.Columns["电话"];
                this.column出生年月 = this.Columns["出生年月"];
                this.column民族 = this.Columns["民族"];
                this.column籍贯 = this.Columns["籍贯"];
                this.column住址 = this.Columns["住址"];
                this.column来自何校 = this.Columns["来自何校"];
                this.column政治面貌 = this.Columns["政治面貌"];
                this.column备注 = this.Columns["备注"];
                this.column照片 = this.Columns["照片"];
            }
            
            private void InitClass() {
                this.column姓名 = new DataColumn("姓名", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column姓名);
                this.column性别 = new DataColumn("性别", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column性别);
                this.column学号 = new DataColumn("学号", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column学号);
                this.column学院 = new DataColumn("学院", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column学院);
                this.column专业 = new DataColumn("专业", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column专业);
                this.column班级 = new DataColumn("班级", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column班级);
                this.column电话 = new DataColumn("电话", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column电话);
                this.column出生年月 = new DataColumn("出生年月", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column出生年月);
                this.column民族 = new DataColumn("民族", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column民族);
                this.column籍贯 = new DataColumn("籍贯", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column籍贯);
                this.column住址 = new DataColumn("住址", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column住址);
                this.column来自何校 = new DataColumn("来自何校", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column来自何校);
                this.column政治面貌 = new DataColumn("政治面貌", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column政治面貌);
                this.column备注 = new DataColumn("备注", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column备注);
                this.column照片 = new DataColumn("照片", typeof(System.Byte[]), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column照片);
                this.column姓名.AllowDBNull = false;
                this.column学号.AllowDBNull = false;
            }
            
            public EssentialInfoRow NewEssentialInfoRow() {
                return ((EssentialInfoRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new EssentialInfoRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(EssentialInfoRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.EssentialInfoRowChanged != null)) {
                    this.EssentialInfoRowChanged(this, new EssentialInfoRowChangeEvent(((EssentialInfoRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.EssentialInfoRowChanging != null)) {
                    this.EssentialInfoRowChanging(this, new EssentialInfoRowChangeEvent(((EssentialInfoRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.EssentialInfoRowDeleted != null)) {
                    this.EssentialInfoRowDeleted(this, new EssentialInfoRowChangeEvent(((EssentialInfoRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.EssentialInfoRowDeleting != null)) {
                    this.EssentialInfoRowDeleting(this, new EssentialInfoRowChangeEvent(((EssentialInfoRow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveEssentialInfoRow(EssentialInfoRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class EssentialInfoRow : DataRow {
            
            private EssentialInfoDataTable tableEssentialInfo;
            
            internal EssentialInfoRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableEssentialInfo = ((EssentialInfoDataTable)(this.Table));
            }
            
            public string 姓名 {
                get {
                    return ((string)(this[this.tableEssentialInfo.姓名Column]));
                }
                set {
                    this[this.tableEssentialInfo.姓名Column] = value;
                }
            }
            
            public string 性别 {
                get {
                    try {
                        return ((string)(this[this.tableEssentialInfo.性别Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableEssentialInfo.性别Column] = value;
                }
            }
            
            public string 学号 {
                get {
                    return ((string)(this[this.tableEssentialInfo.学号Column]));
                }
                set {
                    this[this.tableEssentialInfo.学号Column] = value;
                }
            }
            
            public string 学院 {
                get {
                    try {
                        return ((string)(this[this.tableEssentialInfo.学院Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableEssentialInfo.学院Column] = value;
                }
            }
            
            public string 专业 {
                get {
                    try {
                        return ((string)(this[this.tableEssentialInfo.专业Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableEssentialInfo.专业Column] = value;
                }
            }
            
            public string 班级 {
                get {
                    try {
                        return ((string)(this[this.tableEssentialInfo.班级Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableEssentialInfo.班级Column] = value;
                }
            }