dataset1.cs

这是用SQL数据库做的学生信息管理系统。简明

                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(System.DateTime), 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(bool), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column毕业否);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.column学号}, true));
                this.column学号.AllowDBNull = false;
                this.column学号.Unique = true;
            }
            
            public STURow NewSTURow() {
                return ((STURow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new STURow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(STURow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.STURowChanged != null)) {
                    this.STURowChanged(this, new STURowChangeEvent(((STURow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.STURowChanging != null)) {
                    this.STURowChanging(this, new STURowChangeEvent(((STURow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.STURowDeleted != null)) {
                    this.STURowDeleted(this, new STURowChangeEvent(((STURow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.STURowDeleting != null)) {
                    this.STURowDeleting(this, new STURowChangeEvent(((STURow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveSTURow(STURow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class STURow : DataRow {
            
            private STUDataTable tableSTU;
            
            internal STURow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableSTU = ((STUDataTable)(this.Table));
            }
            
            public string 学号 {
                get {
                    return ((string)(this[this.tableSTU.学号Column]));
                }
                set {
                    this[this.tableSTU.学号Column] = value;
                }
            }
            
            public string 姓名 {
                get {
                    try {
                        return ((string)(this[this.tableSTU.姓名Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.姓名Column] = value;
                }
            }
            
            public string 性别 {
                get {
                    try {
                        return ((string)(this[this.tableSTU.性别Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.性别Column] = value;
                }
            }
            
            public System.DateTime 出生 {
                get {
                    try {
                        return ((System.DateTime)(this[this.tableSTU.出生Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.出生Column] = value;
                }
            }
            
            public string 班级编号 {
                get {
                    try {
                        return ((string)(this[this.tableSTU.班级编号Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.班级编号Column] = value;
                }
            }
            
            public string 地址 {
                get {
                    try {
                        return ((string)(this[this.tableSTU.地址Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.地址Column] = value;
                }
            }
            
            public string 电话 {
                get {
                    try {
                        return ((string)(this[this.tableSTU.电话Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.电话Column] = value;
                }
            }
            
            public string 手机 {
                get {
                    try {
                        return ((string)(this[this.tableSTU.手机Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.手机Column] = value;
                }
            }
            
            public bool 毕业否 {
                get {
                    try {
                        return ((bool)(this[this.tableSTU.毕业否Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableSTU.毕业否Column] = value;
                }
            }
            
            public bool Is姓名Null() {
                return this.IsNull(this.tableSTU.姓名Column);
            }
            
            public void Set姓名Null() {
                this[this.tableSTU.姓名Column] = System.Convert.DBNull;
            }
            
            public bool Is性别Null() {
                return this.IsNull(this.tableSTU.性别Column);
            }
            
            public void Set性别Null() {
                this[this.tableSTU.性别Column] = System.Convert.DBNull;
            }
            
            public bool Is出生Null() {
                return this.IsNull(this.tableSTU.出生Column);
            }
            
            public void Set出生Null() {
                this[this.tableSTU.出生Column] = System.Convert.DBNull;
            }
            
            public bool Is班级编号Null() {
                return this.IsNull(this.tableSTU.班级编号Column);
            }
            
            public void Set班级编号Null() {
                this[this.tableSTU.班级编号Column] = System.Convert.DBNull;
            }
            
            public bool Is地址Null() {
                return this.IsNull(this.tableSTU.地址Column);
            }
            
            public void Set地址Null() {
                this[this.tableSTU.地址Column] = System.Convert.DBNull;
            }
            
            public bool Is电话Null() {
                return this.IsNull(this.tableSTU.电话Column);
            }
            
            public void Set电话Null() {
                this[this.tableSTU.电话Column] = System.Convert.DBNull;
            }
            
            public bool Is手机Null() {
                return this.IsNull(this.tableSTU.手机Column);
            }
            
            public void Set手机Null() {
                this[this.tableSTU.手机Column] = System.Convert.DBNull;
            }
            
            public bool Is毕业否Null() {
                return this.IsNull(this.tableSTU.毕业否Column);
            }
            
            public void Set毕业否Null() {
                this[this.tableSTU.毕业否Column] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class STURowChangeEvent : EventArgs {
            
            private STURow eventRow;
            
            private DataRowAction eventAction;
            
            public STURowChangeEvent(STURow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public STURow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}