dataset2.cs

自己参考开发的程序,用C#编写的,还有很的功能没有实现,数据库的安全性也没有很好的解决好.

//------------------------------------------------------------------------------
// <autogenerated>
//     This code was generated by a tool.
//     Runtime Version: 1.1.4322.573
//
//     Changes to this file may cause incorrect behavior and will be lost if 
//     the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------

namespace 教务管理系统 
{
	using System;
	using System.Data;
	using System.Xml;
	using System.Runtime.Serialization;
    
    
	[Serializable()]
	[System.ComponentModel.DesignerCategoryAttribute("code")]
	[System.Diagnostics.DebuggerStepThrough()]
	[System.ComponentModel.ToolboxItem(true)]
	public class DataSet2 : DataSet 
	{
        
		private 成绩表DataTable table成绩表;
        
		public DataSet2() 
		{
			this.InitClass();
			System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
			this.Tables.CollectionChanged += schemaChangedHandler;
			this.Relations.CollectionChanged += schemaChangedHandler;
		}
        
		protected DataSet2(SerializationInfo info, StreamingContext context) 
		{
			string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
			if ((strSchema != null)) 
			{
				DataSet ds = new DataSet();
				ds.ReadXmlSchema(new XmlTextReader(new System.IO.StringReader(strSchema)));
				if ((ds.Tables["成绩表"] != null)) 
				{
					this.Tables.Add(new 成绩表DataTable(ds.Tables["成绩表"]));
				}
				this.DataSetName = ds.DataSetName;
				this.Prefix = ds.Prefix;
				this.Namespace = ds.Namespace;
				this.Locale = ds.Locale;
				this.CaseSensitive = ds.CaseSensitive;
				this.EnforceConstraints = ds.EnforceConstraints;
				this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
				this.InitVars();
			}
			else 
			{
				this.InitClass();
			}
			this.GetSerializationData(info, context);
			System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
			this.Tables.CollectionChanged += schemaChangedHandler;
			this.Relations.CollectionChanged += schemaChangedHandler;
		}
        
		[System.ComponentModel.Browsable(false)]
		[System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)]
		public 成绩表DataTable 成绩表 
		{
			get 
			{
				return this.table成绩表;
			}
		}
        
		public override DataSet Clone() 
		{
			DataSet2 cln = ((DataSet2)(base.Clone()));
			cln.InitVars();
			return cln;
		}
        
		protected override bool ShouldSerializeTables() 
		{
			return false;
		}
        
		protected override bool ShouldSerializeRelations() 
		{
			return false;
		}
        
		protected override void ReadXmlSerializable(XmlReader reader) 
		{
			this.Reset();
			DataSet ds = new DataSet();
			ds.ReadXml(reader);
			if ((ds.Tables["成绩表"] != null)) 
			{
				this.Tables.Add(new 成绩表DataTable(ds.Tables["成绩表"]));
			}
			this.DataSetName = ds.DataSetName;
			this.Prefix = ds.Prefix;
			this.Namespace = ds.Namespace;
			this.Locale = ds.Locale;
			this.CaseSensitive = ds.CaseSensitive;
			this.EnforceConstraints = ds.EnforceConstraints;
			this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
			this.InitVars();
		}
        
		protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() 
		{
			System.IO.MemoryStream stream = new System.IO.MemoryStream();
			this.WriteXmlSchema(new XmlTextWriter(stream, null));
			stream.Position = 0;
			return System.Xml.Schema.XmlSchema.Read(new XmlTextReader(stream), null);
		}
        
		internal void InitVars() 
		{
			this.table成绩表 = ((成绩表DataTable)(this.Tables["成绩表"]));
			if ((this.table成绩表 != null)) 
			{
				this.table成绩表.InitVars();
			}
		}
        
		private void InitClass() 
		{
			this.DataSetName = "DataSet2";
			this.Prefix = "";
			this.Namespace = "http://www.tempuri.org/DataSet2.xsd";
			this.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.CaseSensitive = false;
			this.EnforceConstraints = true;
			this.table成绩表 = new 成绩表DataTable();
			this.Tables.Add(this.table成绩表);
		}
        
		private bool ShouldSerialize成绩表() 
		{
			return false;
		}
        
		private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) 
		{
			if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) 
			{
				this.InitVars();
			}
		}
        
		public delegate void 成绩表RowChangeEventHandler(object sender, 成绩表RowChangeEvent e);
        
		[System.Diagnostics.DebuggerStepThrough()]
			public class 成绩表DataTable : DataTable, System.Collections.IEnumerable 
		{
            
			private DataColumn column学号;
            
			private DataColumn column姓名;
            
			private DataColumn column课程名称;
            
			private DataColumn column开课系别;
            
			private DataColumn column教师;
            
			private DataColumn column成绩;
            
			internal 成绩表DataTable() : 
				base("成绩表") 
			{
				this.InitClass();
			}
            
			internal 成绩表DataTable(DataTable table) : 
				base(table.TableName) 
			{
				if ((table.CaseSensitive != table.DataSet.CaseSensitive)) 
				{
					this.CaseSensitive = table.CaseSensitive;
				}
				if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) 
				{
					this.Locale = table.Locale;
				}
				if ((table.Namespace != table.DataSet.Namespace)) 
				{
					this.Namespace = table.Namespace;
				}
				this.Prefix = table.Prefix;
				this.MinimumCapacity = table.MinimumCapacity;
				this.DisplayExpression = table.DisplayExpression;
			}
            
			[System.ComponentModel.Browsable(false)]
			public int Count 
			{
				get 
				{
					return this.Rows.Count;
				}
			}
            
			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开课系别;
				}
			}
            
			internal DataColumn 教师Column 
			{
				get 
				{
					return this.column教师;
				}
			}
            
			internal DataColumn 成绩Column 
			{
				get 
				{
					return this.column成绩;
				}
			}
            
			public 成绩表Row this[int index] 
			{
				get 
				{
					return ((成绩表Row)(this.Rows[index]));
				}
			}
            
			public event 成绩表RowChangeEventHandler 成绩表RowChanged;
            
			public event 成绩表RowChangeEventHandler 成绩表RowChanging;
            
			public event 成绩表RowChangeEventHandler 成绩表RowDeleted;
            
			public event 成绩表RowChangeEventHandler 成绩表RowDeleting;
            
			public void Add成绩表Row(成绩表Row row) 
			{
				this.Rows.Add(row);
			}
            
			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;
				}
			}
		}
	}
}