Quản lý điểm sinh viên CNTT

177.558 lượt xem;
1 //------------------------------------------------------------------------------
2 // <auto-generated>
3 // This code was generated by a tool.
4 // Runtime Version:2.0.50727.4927
5 //
6 // Changes to this file may cause incorrect behavior and will be lost if
7 // the code is regenerated.
8 // </auto-generated>
9 //------------------------------------------------------------------------------
10
11 #pragma warning disable 1591
12
13 namespace Quản_lý_điểm_sinh_vien_CNTT {
14     
15     
16     /// <summary>
17     ///Represents a strongly typed in-memory cache of data.
18     ///</summary>
19     [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
20     [global::System.Serializable()]
21     [global::System.ComponentModel.DesignerCategoryAttribute("code")]
22     [global::System.ComponentModel.ToolboxItem(true)]
23     [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
24     [global::System.Xml.Serialization.XmlRootAttribute("QuanlydiemDataSet40")]
25     [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
26     public partial class QuanlydiemDataSet40 : global::System.Data.DataSet {
27         
28         private tblKET_QUA2DataTable tabletblKET_QUA2;
29         
30         private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
31         
32         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
33         public QuanlydiemDataSet40() {
34             this.BeginInit();
35             this.InitClass();
36             global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
37             base.Tables.CollectionChanged += schemaChangedHandler;
38             base.Relations.CollectionChanged += schemaChangedHandler;
39             this.EndInit();
40         }
41         
42         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
43         protected QuanlydiemDataSet40(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
44                 base(info, context, false) {
45             if ((this.IsBinarySerialized(info, context) == true)) {
46                 this.InitVars(false);
47                 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
48                 this.Tables.CollectionChanged += schemaChangedHandler1;
49                 this.Relations.CollectionChanged += schemaChangedHandler1;
50                 return;
51             }
52             string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
53             if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
54                 global::System.Data.DataSet ds = new global::System.Data.DataSet();
55                 ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
56                 if ((ds.Tables["tblKET_QUA2"] != null)) {
57                     base.Tables.Add(new tblKET_QUA2DataTable(ds.Tables["tblKET_QUA2"]));
58                 }
59                 this.DataSetName = ds.DataSetName;
60                 this.Prefix = ds.Prefix;
61                 this.Namespace = ds.Namespace;
62                 this.Locale = ds.Locale;
63                 this.CaseSensitive = ds.CaseSensitive;
64                 this.EnforceConstraints = ds.EnforceConstraints;
65                 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
66                 this.InitVars();
67             }
68             else {
69                 this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
70             }
71             this.GetSerializationData(info, context);
72             global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
73             base.Tables.CollectionChanged += schemaChangedHandler;
74             this.Relations.CollectionChanged += schemaChangedHandler;
75         }
76         
77         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
78         [global::System.ComponentModel.Browsable(false)]
79         [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
80         public tblKET_QUA2DataTable tblKET_QUA2 {
81             get {
82                 return this.tabletblKET_QUA2;
83             }
84         }
85         
86         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
87         [global::System.ComponentModel.BrowsableAttribute(true)]
88         [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
89         public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
90             get {
91                 return this._schemaSerializationMode;
92             }
93             set {
94                 this._schemaSerializationMode = value;
95             }
96         }
97         
98         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
99         [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
100         public new global::System.Data.DataTableCollection Tables {
101             get {
102                 return base.Tables;
103             }
104         }
105         
106         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
107         [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
108         public new global::System.Data.DataRelationCollection Relations {
109             get {
110                 return base.Relations;
111             }
112         }
113         
114         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
115         protected override void InitializeDerivedDataSet() {
116             this.BeginInit();
117             this.InitClass();
118             this.EndInit();
119         }
120         
121         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
122         public override global::System.Data.DataSet Clone() {
123             QuanlydiemDataSet40 cln = ((QuanlydiemDataSet40)(base.Clone()));
124             cln.InitVars();
125             cln.SchemaSerializationMode = this.SchemaSerializationMode;
126             return cln;
127         }
128         
129         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
130         protected override bool ShouldSerializeTables() {
131             return false;
132         }
133         
134         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
135         protected override bool ShouldSerializeRelations() {
136             return false;
137         }
138         
139         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
140         protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
141             if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
142                 this.Reset();
143                 global::System.Data.DataSet ds = new global::System.Data.DataSet();
144                 ds.ReadXml(reader);
145                 if ((ds.Tables["tblKET_QUA2"] != null)) {
146                     base.Tables.Add(new tblKET_QUA2DataTable(ds.Tables["tblKET_QUA2"]));
147                 }
148                 this.DataSetName = ds.DataSetName;
149                 this.Prefix = ds.Prefix;
150                 this.Namespace = ds.Namespace;
151                 this.Locale = ds.Locale;
152                 this.CaseSensitive = ds.CaseSensitive;
153                 this.EnforceConstraints = ds.EnforceConstraints;
154                 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
155                 this.InitVars();
156             }
157             else {
158                 this.ReadXml(reader);
159                 this.InitVars();
160             }
161         }
162         
163         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
164         protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
165             global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
166             this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
167             stream.Position = 0;
168             return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
169         }
170         
171         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
172         internal void InitVars() {
173             this.InitVars(true);
174         }
175         
176         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
177         internal void InitVars(bool initTable) {
178             this.tabletblKET_QUA2 = ((tblKET_QUA2DataTable)(base.Tables["tblKET_QUA2"]));
179             if ((initTable == true)) {
180                 if ((this.tabletblKET_QUA2 != null)) {
181                     this.tabletblKET_QUA2.InitVars();
182                 }
183             }
184         }
185         
186         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
187         private void InitClass() {
188             this.DataSetName = "QuanlydiemDataSet40";
189             this.Prefix = "";
190             this.Namespace = "http://tempuri.org/QuanlydiemDataSet40.xsd";
191             this.EnforceConstraints = true;
192             this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
193             this.tabletblKET_QUA2 = new tblKET_QUA2DataTable();
194             base.Tables.Add(this.tabletblKET_QUA2);
195         }
196         
197         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
198         private bool ShouldSerializetblKET_QUA2() {
199             return false;
200         }
201         
202         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
203         private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
204             if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
205                 this.InitVars();
206             }
207         }
208         
209         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
210         public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
211             QuanlydiemDataSet40 ds = new QuanlydiemDataSet40();
212             global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
213             global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
214             global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
215             any.Namespace = ds.Namespace;
216             sequence.Items.Add(any);
217             type.Particle = sequence;
218             global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
219             if (xs.Contains(dsSchema.TargetNamespace)) {
220                 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
221                 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
222                 try {
223                     global::System.Xml.Schema.XmlSchema schema = null;
224                     dsSchema.Write(s1);
225                     for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
226                         schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
227                         s2.SetLength(0);
228                         schema.Write(s2);
229                         if ((s1.Length == s2.Length)) {
230                             s1.Position = 0;
231                             s2.Position = 0;
232                             for (; ((s1.Position != s1.Length)
233                                         && (s1.ReadByte() == s2.ReadByte())); ) {
234                                 ;
235                             }
236                             if ((s1.Position == s1.Length)) {
237                                 return type;
238                             }
239                         }
240                     }
241                 }
242                 finally {
243                     if ((s1 != null)) {
244                         s1.Close();
245                     }
246                     if ((s2 != null)) {
247                         s2.Close();
248                     }
249                 }
250             }
251             xs.Add(dsSchema);
252             return type;
253         }
254         
255         public delegate void tblKET_QUA2RowChangeEventHandler(object sender, tblKET_QUA2RowChangeEvent e);
256         
257         /// <summary>
258         ///Represents the strongly named DataTable class.
259         ///</summary>
260         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
261         [global::System.Serializable()]
262         [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
263         public partial class tblKET_QUA2DataTable : global::System.Data.TypedTableBase<tblKET_QUA2Row> {
264             
265             private global::System.Data.DataColumn columnMaSV;
266             
267             private global::System.Data.DataColumn columnHoTen;
268             
269             private global::System.Data.DataColumn columnMaLop;
270             
271             private global::System.Data.DataColumn columnTenMon;
272             
273             private global::System.Data.DataColumn columnDiemThiLai;
274             
275             private global::System.Data.DataColumn columnDiemTongKet;
276             
277             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
278             public tblKET_QUA2DataTable() {
279                 this.TableName = "tblKET_QUA2";
280                 this.BeginInit();
281                 this.InitClass();
282                 this.EndInit();
283             }
284             
285             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
286             internal tblKET_QUA2DataTable(global::System.Data.DataTable table) {
287                 this.TableName = table.TableName;
288                 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
289                     this.CaseSensitive = table.CaseSensitive;
290                 }
291                 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
292                     this.Locale = table.Locale;
293                 }
294                 if ((table.Namespace != table.DataSet.Namespace)) {
295                     this.Namespace = table.Namespace;
296                 }
297                 this.Prefix = table.Prefix;
298                 this.MinimumCapacity = table.MinimumCapacity;
299             }
300             
301             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
302             protected tblKET_QUA2DataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
303                     base(info, context) {
304                 this.InitVars();
305             }
306             
307             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
308             public global::System.Data.DataColumn MaSVColumn {
309                 get {
310                     return this.columnMaSV;
311                 }
312             }
313             
314             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
315             public global::System.Data.DataColumn HoTenColumn {
316                 get {
317                     return this.columnHoTen;
318                 }
319             }
320             
321             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
322             public global::System.Data.DataColumn MaLopColumn {
323                 get {
324                     return this.columnMaLop;
325                 }
326             }
327             
328             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
329             public global::System.Data.DataColumn TenMonColumn {
330                 get {
331                     return this.columnTenMon;
332                 }
333             }
334             
335             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
336             public global::System.Data.DataColumn DiemThiLaiColumn {
337                 get {
338                     return this.columnDiemThiLai;
339                 }
340             }
341             
342             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
343             public global::System.Data.DataColumn DiemTongKetColumn {
344                 get {
345                     return this.columnDiemTongKet;
346                 }
347             }
348             
349             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
350             [global::System.ComponentModel.Browsable(false)]
351             public int Count {
352                 get {
353                     return this.Rows.Count;
354                 }
355             }
356             
357             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
358             public tblKET_QUA2Row this[int index] {
359                 get {
360                     return ((tblKET_QUA2Row)(this.Rows[index]));
361                 }
362             }
363             
364             public event tblKET_QUA2RowChangeEventHandler tblKET_QUA2RowChanging;
365             
366             public event tblKET_QUA2RowChangeEventHandler tblKET_QUA2RowChanged;
367             
368             public event tblKET_QUA2RowChangeEventHandler tblKET_QUA2RowDeleting;
369             
370             public event tblKET_QUA2RowChangeEventHandler tblKET_QUA2RowDeleted;
371             
372             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
373             public void AddtblKET_QUA2Row(tblKET_QUA2Row row) {
374                 this.Rows.Add(row);
375             }
376             
377             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
378             public tblKET_QUA2Row AddtblKET_QUA2Row(string MaSV, string HoTen, string MaLop, string TenMon, string DiemThiLai, string DiemTongKet) {
379                 tblKET_QUA2Row rowtblKET_QUA2Row = ((tblKET_QUA2Row)(this.NewRow()));
380                 object[] columnValuesArray = new object[] {
381                         MaSV,
382                         HoTen,
383                         MaLop,
384                         TenMon,
385                         DiemThiLai,
386                         DiemTongKet};
387                 rowtblKET_QUA2Row.ItemArray = columnValuesArray;
388                 this.Rows.Add(rowtblKET_QUA2Row);
389                 return rowtblKET_QUA2Row;
390             }
391             
392             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
393             public override global::System.Data.DataTable Clone() {
394                 tblKET_QUA2DataTable cln = ((tblKET_QUA2DataTable)(base.Clone()));
395                 cln.InitVars();
396                 return cln;
397             }
398             
399             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
400             protected override global::System.Data.DataTable CreateInstance() {
401                 return new tblKET_QUA2DataTable();
402             }
403             
404             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
405             internal void InitVars() {
406                 this.columnMaSV = base.Columns["MaSV"];
407                 this.columnHoTen = base.Columns["HoTen"];
408                 this.columnMaLop = base.Columns["MaLop"];
409                 this.columnTenMon = base.Columns["TenMon"];
410                 this.columnDiemThiLai = base.Columns["DiemThiLai"];
411                 this.columnDiemTongKet = base.Columns["DiemTongKet"];
412             }
413             
414             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
415             private void InitClass() {
416                 this.columnMaSV = new global::System.Data.DataColumn("MaSV", typeof(string), null, global::System.Data.MappingType.Element);
417                 base.Columns.Add(this.columnMaSV);
418                 this.columnHoTen = new global::System.Data.DataColumn("HoTen", typeof(string), null, global::System.Data.MappingType.Element);
419                 base.Columns.Add(this.columnHoTen);
420                 this.columnMaLop = new global::System.Data.DataColumn("MaLop", typeof(string), null, global::System.Data.MappingType.Element);
421                 base.Columns.Add(this.columnMaLop);
422                 this.columnTenMon = new global::System.Data.DataColumn("TenMon", typeof(string), null, global::System.Data.MappingType.Element);
423                 base.Columns.Add(this.columnTenMon);
424                 this.columnDiemThiLai = new global::System.Data.DataColumn("DiemThiLai", typeof(string), null, global::System.Data.MappingType.Element);
425                 base.Columns.Add(this.columnDiemThiLai);
426                 this.columnDiemTongKet = new global::System.Data.DataColumn("DiemTongKet", typeof(string), null, global::System.Data.MappingType.Element);
427                 base.Columns.Add(this.columnDiemTongKet);
428                 this.columnMaSV.MaxLength = 5;
429                 this.columnHoTen.MaxLength = 20;
430                 this.columnMaLop.MaxLength = 10;
431                 this.columnTenMon.MaxLength = 30;
432                 this.columnDiemThiLai.MaxLength = 5;
433                 this.columnDiemTongKet.MaxLength = 5;
434             }
435             
436             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
437             public tblKET_QUA2Row NewtblKET_QUA2Row() {
438                 return ((tblKET_QUA2Row)(this.NewRow()));
439             }
440             
441             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
442             protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
443                 return new tblKET_QUA2Row(builder);
444             }
445             
446             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
447             protected override global::System.Type GetRowType() {
448                 return typeof(tblKET_QUA2Row);
449             }
450             
451             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
452             protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
453                 base.OnRowChanged(e);
454                 if ((this.tblKET_QUA2RowChanged != null)) {
455                     this.tblKET_QUA2RowChanged(this, new tblKET_QUA2RowChangeEvent(((tblKET_QUA2Row)(e.Row)), e.Action));
456                 }
457             }
458             
459             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
460             protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
461                 base.OnRowChanging(e);
462                 if ((this.tblKET_QUA2RowChanging != null)) {
463                     this.tblKET_QUA2RowChanging(this, new tblKET_QUA2RowChangeEvent(((tblKET_QUA2Row)(e.Row)), e.Action));
464                 }
465             }
466             
467             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
468             protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
469                 base.OnRowDeleted(e);
470                 if ((this.tblKET_QUA2RowDeleted != null)) {
471                     this.tblKET_QUA2RowDeleted(this, new tblKET_QUA2RowChangeEvent(((tblKET_QUA2Row)(e.Row)), e.Action));
472                 }
473             }
474             
475             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
476             protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
477                 base.OnRowDeleting(e);
478                 if ((this.tblKET_QUA2RowDeleting != null)) {
479                     this.tblKET_QUA2RowDeleting(this, new tblKET_QUA2RowChangeEvent(((tblKET_QUA2Row)(e.Row)), e.Action));
480                 }
481             }
482             
483             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
484             public void RemovetblKET_QUA2Row(tblKET_QUA2Row row) {
485                 this.Rows.Remove(row);
486             }
487             
488             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
489             public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
490                 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
491                 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
492                 QuanlydiemDataSet40 ds = new QuanlydiemDataSet40();
493                 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
494                 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
495                 any1.MinOccurs = new decimal(0);
496                 any1.MaxOccurs = decimal.MaxValue;
497                 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
498                 sequence.Items.Add(any1);
499                 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
500                 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
501                 any2.MinOccurs = new decimal(1);
502                 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
503                 sequence.Items.Add(any2);
504                 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
505                 attribute1.Name = "namespace";
506                 attribute1.FixedValue = ds.Namespace;
507                 type.Attributes.Add(attribute1);
508                 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
509                 attribute2.Name = "tableTypeName";
510                 attribute2.FixedValue = "tblKET_QUA2DataTable";
511                 type.Attributes.Add(attribute2);
512                 type.Particle = sequence;
513                 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
514                 if (xs.Contains(dsSchema.TargetNamespace)) {
515                     global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
516                     global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
517                     try {
518                         global::System.Xml.Schema.XmlSchema schema = null;
519                         dsSchema.Write(s1);
520                         for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
521                             schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
522                             s2.SetLength(0);
523                             schema.Write(s2);
524                             if ((s1.Length == s2.Length)) {
525                                 s1.Position = 0;
526                                 s2.Position = 0;
527                                 for (; ((s1.Position != s1.Length)
528                                             && (s1.ReadByte() == s2.ReadByte())); ) {
529                                     ;
530                                 }
531                                 if ((s1.Position == s1.Length)) {
532                                     return type;
533                                 }
534                             }
535                         }
536                     }
537                     finally {
538                         if ((s1 != null)) {
539                             s1.Close();
540                         }
541                         if ((s2 != null)) {
542                             s2.Close();
543                         }
544                     }
545                 }
546                 xs.Add(dsSchema);
547                 return type;
548             }
549         }
550         
551         /// <summary>
552         ///Represents strongly named DataRow class.
553         ///</summary>
554         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
555         public partial class tblKET_QUA2Row : global::System.Data.DataRow {
556             
557             private tblKET_QUA2DataTable tabletblKET_QUA2;
558             
559             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
560             internal tblKET_QUA2Row(global::System.Data.DataRowBuilder rb) :
561                     base(rb) {
562                 this.tabletblKET_QUA2 = ((tblKET_QUA2DataTable)(this.Table));
563             }
564             
565             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
566             public string MaSV {
567                 get {
568                     try {
569                         return ((string)(this[this.tabletblKET_QUA2.MaSVColumn]));
570                     }
571                     catch (global::System.InvalidCastException e) {
572                         throw new global::System.Data.StrongTypingException("The value for column \'MaSV\' in table \'tblKET_QUA2\' is DBNull.", e);
573                     }
574                 }
575                 set {
576                     this[this.tabletblKET_QUA2.MaSVColumn] = value;
577                 }
578             }
579             
580             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
581             public string HoTen {
582                 get {
583                     try {
584                         return ((string)(this[this.tabletblKET_QUA2.HoTenColumn]));
585                     }
586                     catch (global::System.InvalidCastException e) {
587                         throw new global::System.Data.StrongTypingException("The value for column \'HoTen\' in table \'tblKET_QUA2\' is DBNull.", e);
588                     }
589                 }
590                 set {
591                     this[this.tabletblKET_QUA2.HoTenColumn] = value;
592                 }
593             }
594             
595             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
596             public string MaLop {
597                 get {
598                     try {
599                         return ((string)(this[this.tabletblKET_QUA2.MaLopColumn]));
600                     }
601                     catch (global::System.InvalidCastException e) {
602                         throw new global::System.Data.StrongTypingException("The value for column \'MaLop\' in table \'tblKET_QUA2\' is DBNull.", e);
603                     }
604                 }
605                 set {
606                     this[this.tabletblKET_QUA2.MaLopColumn] = value;
607                 }
608             }
609             
610             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
611             public string TenMon {
612                 get {
613                     try {
614                         return ((string)(this[this.tabletblKET_QUA2.TenMonColumn]));
615                     }
616                     catch (global::System.InvalidCastException e) {
617                         throw new global::System.Data.StrongTypingException("The value for column \'TenMon\' in table \'tblKET_QUA2\' is DBNull.", e);
618                     }
619                 }
620                 set {
621                     this[this.tabletblKET_QUA2.TenMonColumn] = value;
622                 }
623             }
624             
625             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
626             public string DiemThiLai {
627                 get {
628                     try {
629                         return ((string)(this[this.tabletblKET_QUA2.DiemThiLaiColumn]));
630                     }
631                     catch (global::System.InvalidCastException e) {
632                         throw new global::System.Data.StrongTypingException("The value for column \'DiemThiLai\' in table \'tblKET_QUA2\' is DBNull.", e);
633                     }
634                 }
635                 set {
636                     this[this.tabletblKET_QUA2.DiemThiLaiColumn] = value;
637                 }
638             }
639             
640             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
641             public string DiemTongKet {
642                 get {
643                     try {
644                         return ((string)(this[this.tabletblKET_QUA2.DiemTongKetColumn]));
645                     }
646                     catch (global::System.InvalidCastException e) {
647                         throw new global::System.Data.StrongTypingException("The value for column \'DiemTongKet\' in table \'tblKET_QUA2\' is DBNull.", e);
648                     }
649                 }
650                 set {
651                     this[this.tabletblKET_QUA2.DiemTongKetColumn] = value;
652                 }
653             }
654             
655             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
656             public bool IsMaSVNull() {
657                 return this.IsNull(this.tabletblKET_QUA2.MaSVColumn);
658             }
659             
660             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
661             public void SetMaSVNull() {
662                 this[this.tabletblKET_QUA2.MaSVColumn] = global::System.Convert.DBNull;
663             }
664             
665             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
666             public bool IsHoTenNull() {
667                 return this.IsNull(this.tabletblKET_QUA2.HoTenColumn);
668             }
669             
670             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
671             public void SetHoTenNull() {
672                 this[this.tabletblKET_QUA2.HoTenColumn] = global::System.Convert.DBNull;
673             }
674             
675             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
676             public bool IsMaLopNull() {
677                 return this.IsNull(this.tabletblKET_QUA2.MaLopColumn);
678             }
679             
680             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
681             public void SetMaLopNull() {
682                 this[this.tabletblKET_QUA2.MaLopColumn] = global::System.Convert.DBNull;
683             }
684             
685             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
686             public bool IsTenMonNull() {
687                 return this.IsNull(this.tabletblKET_QUA2.TenMonColumn);
688             }
689             
690             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
691             public void SetTenMonNull() {
692                 this[this.tabletblKET_QUA2.TenMonColumn] = global::System.Convert.DBNull;
693             }
694             
695             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
696             public bool IsDiemThiLaiNull() {
697                 return this.IsNull(this.tabletblKET_QUA2.DiemThiLaiColumn);
698             }
699             
700             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
701             public void SetDiemThiLaiNull() {
702                 this[this.tabletblKET_QUA2.DiemThiLaiColumn] = global::System.Convert.DBNull;
703             }
704             
705             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
706             public bool IsDiemTongKetNull() {
707                 return this.IsNull(this.tabletblKET_QUA2.DiemTongKetColumn);
708             }
709             
710             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
711             public void SetDiemTongKetNull() {
712                 this[this.tabletblKET_QUA2.DiemTongKetColumn] = global::System.Convert.DBNull;
713             }
714         }
715         
716         /// <summary>
717         ///Row event argument class
718         ///</summary>
719         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
720         public class tblKET_QUA2RowChangeEvent : global::System.EventArgs {
721             
722             private tblKET_QUA2Row eventRow;
723             
724             private global::System.Data.DataRowAction eventAction;
725             
726             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
727             public tblKET_QUA2RowChangeEvent(tblKET_QUA2Row row, global::System.Data.DataRowAction action) {
728                 this.eventRow = row;
729                 this.eventAction = action;
730             }
731             
732             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
733             public tblKET_QUA2Row Row {
734                 get {
735                     return this.eventRow;
736                 }
737             }
738             
739             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
740             public global::System.Data.DataRowAction Action {
741                 get {
742                     return this.eventAction;
743                 }
744             }
745         }
746     }
747 }
748 namespace Quản_lý_điểm_sinh_vien_CNTT.QuanlydiemDataSet40TableAdapters {
749     
750     
751     /// <summary>
752     ///Represents the connection and commands used to retrieve and save data.
753     ///</summary>
754     [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
755     [global::System.ComponentModel.DesignerCategoryAttribute("code")]
756     [global::System.ComponentModel.ToolboxItem(true)]
757     [global::System.ComponentModel.DataObjectAttribute(true)]
758     [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
759         ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
760     [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
761     public partial class tblKET_QUA2TableAdapter : global::System.ComponentModel.Component {
762         
763         private global::System.Data.SqlClient.SqlDataAdapter _adapter;
764         
765         private global::System.Data.SqlClient.SqlConnection _connection;
766         
767         private global::System.Data.SqlClient.SqlTransaction _transaction;
768         
769         private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
770         
771         private bool _clearBeforeFill;
772         
773         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
774         public tblKET_QUA2TableAdapter() {
775             this.ClearBeforeFill = true;
776         }
777         
778         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
779         protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
780             get {
781                 if ((this._adapter == null)) {
782                     this.InitAdapter();
783                 }
784                 return this._adapter;
785             }
786         }
787         
788         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
789         internal global::System.Data.SqlClient.SqlConnection Connection {
790             get {
791                 if ((this._connection == null)) {
792                     this.InitConnection();
793                 }
794                 return this._connection;
795             }
796             set {
797                 this._connection = value;
798                 if ((this.Adapter.InsertCommand != null)) {
799                     this.Adapter.InsertCommand.Connection = value;
800                 }
801                 if ((this.Adapter.DeleteCommand != null)) {
802                     this.Adapter.DeleteCommand.Connection = value;
803                 }
804                 if ((this.Adapter.UpdateCommand != null)) {
805                     this.Adapter.UpdateCommand.Connection = value;
806                 }
807                 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
808                     if ((this.CommandCollection[i] != null)) {
809                         ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
810                     }
811                 }
812             }
813         }
814         
815         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
816         internal global::System.Data.SqlClient.SqlTransaction Transaction {
817             get {
818                 return this._transaction;
819             }
820             set {
821                 this._transaction = value;
822                 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
823                     this.CommandCollection[i].Transaction = this._transaction;
824                 }
825                 if (((this.Adapter != null)
826                             && (this.Adapter.DeleteCommand != null))) {
827                     this.Adapter.DeleteCommand.Transaction = this._transaction;
828                 }
829                 if (((this.Adapter != null)
830                             && (this.Adapter.InsertCommand != null))) {
831                     this.Adapter.InsertCommand.Transaction = this._transaction;
832                 }
833                 if (((this.Adapter != null)
834                             && (this.Adapter.UpdateCommand != null))) {
835                     this.Adapter.UpdateCommand.Transaction = this._transaction;
836                 }
837             }
838         }
839         
840         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
841         protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
842             get {
843                 if ((this._commandCollection == null)) {
844                     this.InitCommandCollection();
845                 }
846                 return this._commandCollection;
847             }
848         }
849         
850         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
851         public bool ClearBeforeFill {
852             get {
853                 return this._clearBeforeFill;
854             }
855             set {
856                 this._clearBeforeFill = value;
857             }
858         }
859         
860         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
861         private void InitAdapter() {
862             this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
863             global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
864             tableMapping.SourceTable = "Table";
865             tableMapping.DataSetTable = "tblKET_QUA2";
866             tableMapping.ColumnMappings.Add("MaSV", "MaSV");
867             tableMapping.ColumnMappings.Add("HoTen", "HoTen");
868             tableMapping.ColumnMappings.Add("MaLop", "MaLop");
869             tableMapping.ColumnMappings.Add("TenMon", "TenMon");
870             tableMapping.ColumnMappings.Add("DiemThiLai", "DiemThiLai");
871             tableMapping.ColumnMappings.Add("DiemTongKet", "DiemTongKet");
872             this._adapter.TableMappings.Add(tableMapping);
873             this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
874             this._adapter.InsertCommand.Connection = this.Connection;
875             this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[tblKET_QUA2] ([MaSV], [HoTen], [MaLop], [TenMon], [DiemThiLai]" +
876                 ", [DiemTongKet]) VALUES (@MaSV, @HoTen, @MaLop, @TenMon, @DiemThiLai, @DiemTongK" +
877                 "et)";
878             this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
879             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MaSV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaSV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
880             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@HoTen", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "HoTen", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
881             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MaLop", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaLop", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
882             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@TenMon", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenMon", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
883             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DiemThiLai", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DiemThiLai", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
884             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DiemTongKet", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DiemTongKet", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
885         }
886         
887         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
888         private void InitConnection() {
889             this._connection = new global::System.Data.SqlClient.SqlConnection();
890             this._connection.ConnectionString = global::Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.Default.QuanlydiemConnectionString2;
891         }
892         
893         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
894         private void InitCommandCollection() {
895             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
896             this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
897             this._commandCollection[0].Connection = this.Connection;
898             this._commandCollection[0].CommandText = "SELECT MaSV, HoTen, MaLop, TenMon, DiemThiLai, DiemTongKet FROM dbo.tblKET_QUA2";
899             this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
900         }
901         
902         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
903         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
904         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
905         public virtual int Fill(QuanlydiemDataSet40.tblKET_QUA2DataTable dataTable) {
906             this.Adapter.SelectCommand = this.CommandCollection[0];
907             if ((this.ClearBeforeFill == true)) {
908                 dataTable.Clear();
909             }
910             int returnValue = this.Adapter.Fill(dataTable);
911             return returnValue;
912         }
913         
914         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
915         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
916         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
917         public virtual QuanlydiemDataSet40.tblKET_QUA2DataTable GetData() {
918             this.Adapter.SelectCommand = this.CommandCollection[0];
919             QuanlydiemDataSet40.tblKET_QUA2DataTable dataTable = new QuanlydiemDataSet40.tblKET_QUA2DataTable();
920             this.Adapter.Fill(dataTable);
921             return dataTable;
922         }
923         
924         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
925         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
926         public virtual int Update(QuanlydiemDataSet40.tblKET_QUA2DataTable dataTable) {
927             return this.Adapter.Update(dataTable);
928         }
929         
930         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
931         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
932         public virtual int Update(QuanlydiemDataSet40 dataSet) {
933             return this.Adapter.Update(dataSet, "tblKET_QUA2");
934         }
935         
936         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
937         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
938         public virtual int Update(global::System.Data.DataRow dataRow) {
939             return this.Adapter.Update(new global::System.Data.DataRow[] {
940                         dataRow});
941         }
942         
943         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
944         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
945         public virtual int Update(global::System.Data.DataRow[] dataRows) {
946             return this.Adapter.Update(dataRows);
947         }
948         
949         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
950         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
951         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
952         public virtual int Insert(string MaSV, string HoTen, string MaLop, string TenMon, string DiemThiLai, string DiemTongKet) {
953             if ((MaSV == null)) {
954                 this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
955             }
956             else {
957                 this.Adapter.InsertCommand.Parameters[0].Value = ((string)(MaSV));
958             }
959             if ((HoTen == null)) {
960                 this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
961             }
962             else {
963                 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(HoTen));
964             }
965             if ((MaLop == null)) {
966                 this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
967             }
968             else {
969                 this.Adapter.InsertCommand.Parameters[2].Value = ((string)(MaLop));
970             }
971             if ((TenMon == null)) {
972                 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
973             }
974             else {
975                 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(TenMon));
976             }
977             if ((DiemThiLai == null)) {
978                 this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
979             }
980             else {
981                 this.Adapter.InsertCommand.Parameters[4].Value = ((string)(DiemThiLai));
982             }
983             if ((DiemTongKet == null)) {
984                 this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
985             }
986             else {
987                 this.Adapter.InsertCommand.Parameters[5].Value = ((string)(DiemTongKet));
988             }
989             global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
990             if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
991                         != global::System.Data.ConnectionState.Open)) {
992                 this.Adapter.InsertCommand.Connection.Open();
993             }
994             try {
995                 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
996                 return returnValue;
997             }
998             finally {
999                 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1000                     this.Adapter.InsertCommand.Connection.Close();
1001                 }
1002             }
1003         }
1004     }
1005     
1006     /// <summary>
1007     ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
1008     ///</summary>
1009     [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1010     [global::System.ComponentModel.DesignerCategoryAttribute("code")]
1011     [global::System.ComponentModel.ToolboxItem(true)]
1012     [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
1013         "esigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
1014     [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
1015     public partial class TableAdapterManager : global::System.ComponentModel.Component {
1016         
1017         private UpdateOrderOption _updateOrder;
1018         
1019         private tblKET_QUA2TableAdapter _tblKET_QUA2TableAdapter;
1020         
1021         private bool _backupDataSetBeforeUpdate;
1022         
1023         private global::System.Data.IDbConnection _connection;
1024         
1025         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1026         public UpdateOrderOption UpdateOrder {
1027             get {
1028                 return this._updateOrder;
1029             }
1030             set {
1031                 this._updateOrder = value;
1032             }
1033         }
1034         
1035         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1036         [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
1037             "ft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" +
1038             "", "System.Drawing.Design.UITypeEditor")]
1039         public tblKET_QUA2TableAdapter tblKET_QUA2TableAdapter {
1040             get {
1041                 return this._tblKET_QUA2TableAdapter;
1042             }
1043             set {
1044                 this._tblKET_QUA2TableAdapter = value;
1045             }
1046         }
1047         
1048         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1049         public bool BackupDataSetBeforeUpdate {
1050             get {
1051                 return this._backupDataSetBeforeUpdate;
1052             }
1053             set {
1054                 this._backupDataSetBeforeUpdate = value;
1055             }
1056         }
1057         
1058         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1059         [global::System.ComponentModel.Browsable(false)]
1060         public global::System.Data.IDbConnection Connection {
1061             get {
1062                 if ((this._connection != null)) {
1063                     return this._connection;
1064                 }
1065                 if (((this._tblKET_QUA2TableAdapter != null)
1066                             && (this._tblKET_QUA2TableAdapter.Connection != null))) {
1067                     return this._tblKET_QUA2TableAdapter.Connection;
1068                 }
1069                 return null;
1070             }
1071             set {
1072                 this._connection = value;
1073             }
1074         }
1075         
1076         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1077         [global::System.ComponentModel.Browsable(false)]
1078         public int TableAdapterInstanceCount {
1079             get {
1080                 int count = 0;
1081                 if ((this._tblKET_QUA2TableAdapter != null)) {
1082                     count = (count + 1);
1083                 }
1084                 return count;
1085             }
1086         }
1087         
1088         /// <summary>
1089         ///Update rows in top-down order.
1090         ///</summary>
1091         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1092         private int UpdateUpdatedRows(QuanlydiemDataSet40 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1093             int result = 0;
1094             if ((this._tblKET_QUA2TableAdapter != null)) {
1095                 global::System.Data.DataRow[] updatedRows = dataSet.tblKET_QUA2.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
1096                 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
1097                 if (((updatedRows != null)
1098                             && (0 < updatedRows.Length))) {
1099                     result = (result + this._tblKET_QUA2TableAdapter.Update(updatedRows));
1100                     allChangedRows.AddRange(updatedRows);
1101                 }
1102             }
1103             return result;
1104         }
1105         
1106         /// <summary>
1107         ///Insert rows in top-down order.
1108         ///</summary>
1109         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1110         private int UpdateInsertedRows(QuanlydiemDataSet40 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1111             int result = 0;
1112             if ((this._tblKET_QUA2TableAdapter != null)) {
1113                 global::System.Data.DataRow[] addedRows = dataSet.tblKET_QUA2.Select(null, null, global::System.Data.DataViewRowState.Added);
1114                 if (((addedRows != null)
1115                             && (0 < addedRows.Length))) {
1116                     result = (result + this._tblKET_QUA2TableAdapter.Update(addedRows));
1117                     allAddedRows.AddRange(addedRows);
1118                 }
1119             }
1120             return result;
1121         }
1122         
1123         /// <summary>
1124         ///Delete rows in bottom-up order.
1125         ///</summary>
1126         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1127         private int UpdateDeletedRows(QuanlydiemDataSet40 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
1128             int result = 0;
1129             if ((this._tblKET_QUA2TableAdapter != null)) {
1130                 global::System.Data.DataRow[] deletedRows = dataSet.tblKET_QUA2.Select(null, null, global::System.Data.DataViewRowState.Deleted);
1131                 if (((deletedRows != null)
1132                             && (0 < deletedRows.Length))) {
1133                     result = (result + this._tblKET_QUA2TableAdapter.Update(deletedRows));
1134                     allChangedRows.AddRange(deletedRows);
1135                 }
1136             }
1137             return result;
1138         }
1139         
1140         /// <summary>
1141         ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
1142         ///</summary>
1143         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1144         private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1145             if (((updatedRows == null)
1146                         || (updatedRows.Length < 1))) {
1147                 return updatedRows;
1148             }
1149             if (((allAddedRows == null)
1150                         || (allAddedRows.Count < 1))) {
1151                 return updatedRows;
1152             }
1153             global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1154             for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
1155                 global::System.Data.DataRow row = updatedRows[i];
1156                 if ((allAddedRows.Contains(row) == false)) {
1157                     realUpdatedRows.Add(row);
1158                 }
1159             }
1160             return realUpdatedRows.ToArray();
1161         }
1162         
1163         /// <summary>
1164         ///Update all changes to the dataset.
1165         ///</summary>
1166         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1167         public virtual int UpdateAll(QuanlydiemDataSet40 dataSet) {
1168             if ((dataSet == null)) {
1169                 throw new global::System.ArgumentNullException("dataSet");
1170             }
1171             if ((dataSet.HasChanges() == false)) {
1172                 return 0;
1173             }
1174             if (((this._tblKET_QUA2TableAdapter != null)
1175                         && (this.MatchTableAdapterConnection(this._tblKET_QUA2TableAdapter.Connection) == false))) {
1176                 throw new global::System.ArgumentException("All TableAdapters managed by a TableAdapterManager must use the same connection s" +
1177                         "tring.");
1178             }
1179             global::System.Data.IDbConnection workConnection = this.Connection;
1180             if ((workConnection == null)) {
1181                 throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" +
1182                         "ger TableAdapter property to a valid TableAdapter instance.");
1183             }
1184             bool workConnOpened = false;
1185             if (((workConnection.State & global::System.Data.ConnectionState.Broken)
1186                         == global::System.Data.ConnectionState.Broken)) {
1187                 workConnection.Close();
1188             }
1189             if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
1190                 workConnection.Open();
1191                 workConnOpened = true;
1192             }
1193             global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
1194             if ((workTransaction == null)) {
1195                 throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" +
1196                         "ctions or the current state is not allowing the transaction to begin.");
1197             }
1198             global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1199             global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1200             global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
1201             global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
1202             int result = 0;
1203             global::System.Data.DataSet backupDataSet = null;
1204             if (this.BackupDataSetBeforeUpdate) {
1205                 backupDataSet = new global::System.Data.DataSet();
1206                 backupDataSet.Merge(dataSet);
1207             }
1208             try {
1209                 // ---- Prepare for update -----------
1210                 //
1211                 if ((this._tblKET_QUA2TableAdapter != null)) {
1212                     revertConnections.Add(this._tblKET_QUA2TableAdapter, this._tblKET_QUA2TableAdapter.Connection);
1213                     this._tblKET_QUA2TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
1214                     this._tblKET_QUA2TableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
1215                     if (this._tblKET_QUA2TableAdapter.Adapter.AcceptChangesDuringUpdate) {
1216                         this._tblKET_QUA2TableAdapter.Adapter.AcceptChangesDuringUpdate = false;
1217                         adaptersWithAcceptChangesDuringUpdate.Add(this._tblKET_QUA2TableAdapter.Adapter);
1218                     }
1219                 }
1220                 //
1221                 //---- Perform updates -----------
1222                 //
1223                 if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
1224                     result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1225                     result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1226                 }
1227                 else {
1228                     result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1229                     result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1230                 }
1231                 result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
1232                 //
1233                 //---- Commit updates -----------
1234                 //
1235                 workTransaction.Commit();
1236                 if ((0 < allAddedRows.Count)) {
1237                     global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1238                     allAddedRows.CopyTo(rows);
1239                     for (int i = 0; (i < rows.Length); i = (i + 1)) {
1240                         global::System.Data.DataRow row = rows[i];
1241                         row.AcceptChanges();
1242                     }
1243                 }
1244                 if ((0 < allChangedRows.Count)) {
1245                     global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
1246                     allChangedRows.CopyTo(rows);
1247                     for (int i = 0; (i < rows.Length); i = (i + 1)) {
1248                         global::System.Data.DataRow row = rows[i];
1249                         row.AcceptChanges();
1250                     }
1251                 }
1252             }
1253             catch (global::System.Exception ex) {
1254                 workTransaction.Rollback();
1255                 // ---- Restore the dataset -----------
1256                 if (this.BackupDataSetBeforeUpdate) {
1257                     global::System.Diagnostics.Debug.Assert((backupDataSet != null));
1258                     dataSet.Clear();
1259                     dataSet.Merge(backupDataSet);
1260                 }
1261                 else {
1262                     if ((0 < allAddedRows.Count)) {
1263                         global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1264                         allAddedRows.CopyTo(rows);
1265                         for (int i = 0; (i < rows.Length); i = (i + 1)) {
1266                             global::System.Data.DataRow row = rows[i];
1267                             row.AcceptChanges();
1268                             row.SetAdded();
1269                         }
1270                     }
1271                 }
1272                 throw ex;
1273             }
1274             finally {
1275                 if (workConnOpened) {
1276                     workConnection.Close();
1277                 }
1278                 if ((this._tblKET_QUA2TableAdapter != null)) {
1279                     this._tblKET_QUA2TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._tblKET_QUA2TableAdapter]));
1280                     this._tblKET_QUA2TableAdapter.Transaction = null;
1281                 }
1282                 if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
1283                     global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
1284                     adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
1285                     for (int i = 0; (i < adapters.Length); i = (i + 1)) {
1286                         global::System.Data.Common.DataAdapter adapter = adapters[i];
1287                         adapter.AcceptChangesDuringUpdate = true;
1288                     }
1289                 }
1290             }
1291             return result;
1292         }
1293         
1294         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1295         protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
1296             global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
1297         }
1298         
1299         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1300         protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
1301             if ((this._connection != null)) {
1302                 return true;
1303             }
1304             if (((this.Connection == null)
1305                         || (inputConnection == null))) {
1306                 return true;
1307             }
1308             if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
1309                 return true;
1310             }
1311             return false;
1312         }
1313         
1314         /// <summary>
1315         ///Update Order Option
1316         ///</summary>
1317         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1318         public enum UpdateOrderOption {
1319             
1320             InsertUpdateDelete = 0,
1321             
1322             UpdateInsertDelete = 1,
1323         }
1324         
1325         /// <summary>
1326         ///Used to sort self-referenced table's rows
1327         ///</summary>
1328         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1329         private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
1330             
1331             private global::System.Data.DataRelation _relation;
1332             
1333             private int _childFirst;
1334             
1335             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1336             internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
1337                 this._relation = relation;
1338                 if (childFirst) {
1339                     this._childFirst = -1;
1340                 }
1341                 else {
1342                     this._childFirst = 1;
1343                 }
1344             }
1345             
1346             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1347             private bool IsChildAndParent(global::System.Data.DataRow child, global::System.Data.DataRow parent) {
1348                 global::System.Diagnostics.Debug.Assert((child != null));
1349                 global::System.Diagnostics.Debug.Assert((parent != null));
1350                 global::System.Data.DataRow newParent = child.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1351                 for (
1352                 ; ((newParent != null)
1353                             && ((object.ReferenceEquals(newParent, child) == false)
1354                             && (object.ReferenceEquals(newParent, parent) == false)));
1355                 ) {
1356                     newParent = newParent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1357                 }
1358                 if ((newParent == null)) {
1359                     for (newParent = child.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original); ((newParent != null)
1360                                 && ((object.ReferenceEquals(newParent, child) == false)
1361                                 && (object.ReferenceEquals(newParent, parent) == false)));
1362                     ) {
1363                         newParent = newParent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
1364                     }
1365                 }
1366                 if (object.ReferenceEquals(newParent, parent)) {
1367                     return true;
1368                 }
1369                 return false;
1370             }
1371             
1372             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1373             public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
1374                 if (object.ReferenceEquals(row1, row2)) {
1375                     return 0;
1376                 }
1377                 if ((row1 == null)) {
1378                     return -1;
1379                 }
1380                 if ((row2 == null)) {
1381                     return 1;
1382                 }
1383
1384                 // Is row1 the child or grandchild of row2
1385                 if (this.IsChildAndParent(row1, row2)) {
1386                     return this._childFirst;
1387                 }
1388
1389                 // Is row2 the child or grandchild of row1
1390                 if (this.IsChildAndParent(row2, row1)) {
1391                     return (-1 * this._childFirst);
1392                 }
1393                 return 0;
1394             }
1395         }
1396     }
1397 }
1398
1399 #pragma warning restore 1591



Quản lý điểm sinh viên CNTT 177.558 lượt xem

Gõ tìm kiếm nhanh...



Dự án liên quan!

Hệ thống quản lý tiền lương trong .Net

5.481 lượt xem

Quản lý xây dựng phần mềm soạn thảo Web ASP

1.567 lượt xem
quản lý website vật liệu xây dựng ASP.net

quản lý website vật liệu xây dựng ASP.net

10.076 lượt xem
Quản lý website tra cứu đồ án của sinh viên ASP

Quản lý website tra cứu đồ án của sinh viên ASP

8.850 lượt xem
Quản lý website tin tức ASP.net

Quản lý website tin tức ASP.net

29.344 lượt xem
Quản lý website nghe nhạc xem videos ASP.net

Quản lý website nghe nhạc xem videos ASP.net

5.719 lượt xem