dataset2.cs

数据库课程设计＿＿选修课管理系统＿＿含有ＳＱＬ数据库和全部源代码

            public 成绩表Row Add成绩表Row(string 学号, string 姓名, string 课程名称, string 开课系别, string 教师, int 成绩) {
                成绩表Row row成绩表Row = ((成绩表Row)(this.NewRow()));
                row成绩表Row.ItemArray = new object[] {
                        学号,
                        姓名,
                        课程名称,
                        开课系别,
                        教师,
                        成绩};
                this.Rows.Add(row成绩表Row);
                return row成绩表Row;
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                成绩表DataTable cln = ((成绩表DataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new 成绩表DataTable();
            }
            
            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["成绩"];
            }
            
            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(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column成绩);
                this.column学号.AllowDBNull = false;
                this.column课程名称.AllowDBNull = false;
                this.column成绩.AllowDBNull = false;
            }
            
            public 成绩表Row New成绩表Row() {
                return ((成绩表Row)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new 成绩表Row(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(成绩表Row);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.成绩表RowChanged != null)) {
                    this.成绩表RowChanged(this, new 成绩表RowChangeEvent(((成绩表Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.成绩表RowChanging != null)) {
                    this.成绩表RowChanging(this, new 成绩表RowChangeEvent(((成绩表Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.成绩表RowDeleted != null)) {
                    this.成绩表RowDeleted(this, new 成绩表RowChangeEvent(((成绩表Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.成绩表RowDeleting != null)) {
                    this.成绩表RowDeleting(this, new 成绩表RowChangeEvent(((成绩表Row)(e.Row)), e.Action));
                }
            }
            
            public void Remove成绩表Row(成绩表Row row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 成绩表Row : DataRow {
            
            private 成绩表DataTable table成绩表;
            
            internal 成绩表Row(DataRowBuilder rb) : 
                    base(rb) {
                this.table成绩表 = ((成绩表DataTable)(this.Table));
            }
            
            public string 学号 {
                get {
                    return ((string)(this[this.table成绩表.学号Column]));
                }
                set {
                    this[this.table成绩表.学号Column] = value;
                }
            }
            
            public string 姓名 {
                get {
                    try {
                        return ((string)(this[this.table成绩表.姓名Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table成绩表.姓名Column] = value;
                }
            }
            
            public string 课程名称 {
                get {
                    return ((string)(this[this.table成绩表.课程名称Column]));
                }
                set {
                    this[this.table成绩表.课程名称Column] = value;
                }
            }
            
            public string 开课系别 {
                get {
                    try {
                        return ((string)(this[this.table成绩表.开课系别Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table成绩表.开课系别Column] = value;
                }
            }
            
            public string 教师 {
                get {
                    try {
                        return ((string)(this[this.table成绩表.教师Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table成绩表.教师Column] = value;
                }
            }
            
            public int 成绩 {
                get {
                    return ((int)(this[this.table成绩表.成绩Column]));
                }
                set {
                    this[this.table成绩表.成绩Column] = value;
                }
            }
            
            public bool Is姓名Null() {
                return this.IsNull(this.table成绩表.姓名Column);
            }
            
            public void Set姓名Null() {
                this[this.table成绩表.姓名Column] = System.Convert.DBNull;
            }
            
            public bool Is开课系别Null() {
                return this.IsNull(this.table成绩表.开课系别Column);
            }
            
            public void Set开课系别Null() {
                this[this.table成绩表.开课系别Column] = System.Convert.DBNull;
            }
            
            public bool Is教师Null() {
                return this.IsNull(this.table成绩表.教师Column);
            }
            
            public void Set教师Null() {
                this[this.table成绩表.教师Column] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 成绩表RowChangeEvent : EventArgs {
            
            private 成绩表Row eventRow;
            
            private DataRowAction eventAction;
            
            public 成绩表RowChangeEvent(成绩表Row row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public 成绩表Row Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}