Quản lý điểm sinh viên CNTT
180.053 lượt xem;
- QuanlydiemDataSet211.Designer.cs
- Quản lý điểm sinh vien CNTT /
- project /
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("QuanlydiemDataSet21")]
25 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
26 public partial class QuanlydiemDataSet21 : global::System.Data.DataSet {
27
28 private tblGIANG_VIENDataTable tabletblGIANG_VIEN;
29
30 private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
31
32 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
33 public QuanlydiemDataSet21() {
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 QuanlydiemDataSet21(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["tblGIANG_VIEN"] != null)) {
57 base.Tables.Add(new tblGIANG_VIENDataTable(ds.Tables["tblGIANG_VIEN"]));
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 tblGIANG_VIENDataTable tblGIANG_VIEN {
81 get {
82 return this.tabletblGIANG_VIEN;
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 QuanlydiemDataSet21 cln = ((QuanlydiemDataSet21)(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["tblGIANG_VIEN"] != null)) {
146 base.Tables.Add(new tblGIANG_VIENDataTable(ds.Tables["tblGIANG_VIEN"]));
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.tabletblGIANG_VIEN = ((tblGIANG_VIENDataTable)(base.Tables["tblGIANG_VIEN"]));
179 if ((initTable == true)) {
180 if ((this.tabletblGIANG_VIEN != null)) {
181 this.tabletblGIANG_VIEN.InitVars();
182 }
183 }
184 }
185
186 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
187 private void InitClass() {
188 this.DataSetName = "QuanlydiemDataSet21";
189 this.Prefix = "";
190 this.Namespace = "http://tempuri.org/QuanlydiemDataSet211.xsd";
191 this.EnforceConstraints = true;
192 this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
193 this.tabletblGIANG_VIEN = new tblGIANG_VIENDataTable();
194 base.Tables.Add(this.tabletblGIANG_VIEN);
195 }
196
197 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
198 private bool ShouldSerializetblGIANG_VIEN() {
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 QuanlydiemDataSet21 ds = new QuanlydiemDataSet21();
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 tblGIANG_VIENRowChangeEventHandler(object sender, tblGIANG_VIENRowChangeEvent 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 tblGIANG_VIENDataTable : global::System.Data.TypedTableBase<tblGIANG_VIENRow> {
264
265 private global::System.Data.DataColumn columnMaGV;
266
267 private global::System.Data.DataColumn columnTenGV;
268
269 private global::System.Data.DataColumn columnGioiTinh;
270
271 private global::System.Data.DataColumn columnPhone;
272
273 private global::System.Data.DataColumn columnEmail;
274
275 private global::System.Data.DataColumn columnPhanLoaiGV;
276
277 private global::System.Data.DataColumn columnAnh;
278
279 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
280 public tblGIANG_VIENDataTable() {
281 this.TableName = "tblGIANG_VIEN";
282 this.BeginInit();
283 this.InitClass();
284 this.EndInit();
285 }
286
287 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
288 internal tblGIANG_VIENDataTable(global::System.Data.DataTable table) {
289 this.TableName = table.TableName;
290 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
291 this.CaseSensitive = table.CaseSensitive;
292 }
293 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
294 this.Locale = table.Locale;
295 }
296 if ((table.Namespace != table.DataSet.Namespace)) {
297 this.Namespace = table.Namespace;
298 }
299 this.Prefix = table.Prefix;
300 this.MinimumCapacity = table.MinimumCapacity;
301 }
302
303 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
304 protected tblGIANG_VIENDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
305 base(info, context) {
306 this.InitVars();
307 }
308
309 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
310 public global::System.Data.DataColumn MaGVColumn {
311 get {
312 return this.columnMaGV;
313 }
314 }
315
316 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
317 public global::System.Data.DataColumn TenGVColumn {
318 get {
319 return this.columnTenGV;
320 }
321 }
322
323 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
324 public global::System.Data.DataColumn GioiTinhColumn {
325 get {
326 return this.columnGioiTinh;
327 }
328 }
329
330 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
331 public global::System.Data.DataColumn PhoneColumn {
332 get {
333 return this.columnPhone;
334 }
335 }
336
337 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
338 public global::System.Data.DataColumn EmailColumn {
339 get {
340 return this.columnEmail;
341 }
342 }
343
344 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
345 public global::System.Data.DataColumn PhanLoaiGVColumn {
346 get {
347 return this.columnPhanLoaiGV;
348 }
349 }
350
351 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
352 public global::System.Data.DataColumn AnhColumn {
353 get {
354 return this.columnAnh;
355 }
356 }
357
358 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
359 [global::System.ComponentModel.Browsable(false)]
360 public int Count {
361 get {
362 return this.Rows.Count;
363 }
364 }
365
366 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
367 public tblGIANG_VIENRow this[int index] {
368 get {
369 return ((tblGIANG_VIENRow)(this.Rows[index]));
370 }
371 }
372
373 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowChanging;
374
375 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowChanged;
376
377 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowDeleting;
378
379 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowDeleted;
380
381 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
382 public void AddtblGIANG_VIENRow(tblGIANG_VIENRow row) {
383 this.Rows.Add(row);
384 }
385
386 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
387 public tblGIANG_VIENRow AddtblGIANG_VIENRow(string MaGV, string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh) {
388 tblGIANG_VIENRow rowtblGIANG_VIENRow = ((tblGIANG_VIENRow)(this.NewRow()));
389 object[] columnValuesArray = new object[] {
390 MaGV,
391 TenGV,
392 GioiTinh,
393 Phone,
394 Email,
395 PhanLoaiGV,
396 Anh};
397 rowtblGIANG_VIENRow.ItemArray = columnValuesArray;
398 this.Rows.Add(rowtblGIANG_VIENRow);
399 return rowtblGIANG_VIENRow;
400 }
401
402 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
403 public tblGIANG_VIENRow FindByMaGV(string MaGV) {
404 return ((tblGIANG_VIENRow)(this.Rows.Find(new object[] {
405 MaGV})));
406 }
407
408 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
409 public override global::System.Data.DataTable Clone() {
410 tblGIANG_VIENDataTable cln = ((tblGIANG_VIENDataTable)(base.Clone()));
411 cln.InitVars();
412 return cln;
413 }
414
415 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
416 protected override global::System.Data.DataTable CreateInstance() {
417 return new tblGIANG_VIENDataTable();
418 }
419
420 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
421 internal void InitVars() {
422 this.columnMaGV = base.Columns["MaGV"];
423 this.columnTenGV = base.Columns["TenGV"];
424 this.columnGioiTinh = base.Columns["GioiTinh"];
425 this.columnPhone = base.Columns["Phone"];
426 this.columnEmail = base.Columns["Email"];
427 this.columnPhanLoaiGV = base.Columns["PhanLoaiGV"];
428 this.columnAnh = base.Columns["Anh"];
429 }
430
431 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
432 private void InitClass() {
433 this.columnMaGV = new global::System.Data.DataColumn("MaGV", typeof(string), null, global::System.Data.MappingType.Element);
434 base.Columns.Add(this.columnMaGV);
435 this.columnTenGV = new global::System.Data.DataColumn("TenGV", typeof(string), null, global::System.Data.MappingType.Element);
436 base.Columns.Add(this.columnTenGV);
437 this.columnGioiTinh = new global::System.Data.DataColumn("GioiTinh", typeof(string), null, global::System.Data.MappingType.Element);
438 base.Columns.Add(this.columnGioiTinh);
439 this.columnPhone = new global::System.Data.DataColumn("Phone", typeof(string), null, global::System.Data.MappingType.Element);
440 base.Columns.Add(this.columnPhone);
441 this.columnEmail = new global::System.Data.DataColumn("Email", typeof(string), null, global::System.Data.MappingType.Element);
442 base.Columns.Add(this.columnEmail);
443 this.columnPhanLoaiGV = new global::System.Data.DataColumn("PhanLoaiGV", typeof(string), null, global::System.Data.MappingType.Element);
444 base.Columns.Add(this.columnPhanLoaiGV);
445 this.columnAnh = new global::System.Data.DataColumn("Anh", typeof(string), null, global::System.Data.MappingType.Element);
446 base.Columns.Add(this.columnAnh);
447 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
448 this.columnMaGV}, true));
449 this.columnMaGV.AllowDBNull = false;
450 this.columnMaGV.Unique = true;
451 this.columnMaGV.MaxLength = 10;
452 this.columnTenGV.MaxLength = 30;
453 this.columnGioiTinh.MaxLength = 10;
454 this.columnPhone.MaxLength = 12;
455 this.columnEmail.MaxLength = 20;
456 this.columnPhanLoaiGV.MaxLength = 20;
457 this.columnAnh.MaxLength = 50;
458 }
459
460 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
461 public tblGIANG_VIENRow NewtblGIANG_VIENRow() {
462 return ((tblGIANG_VIENRow)(this.NewRow()));
463 }
464
465 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
466 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
467 return new tblGIANG_VIENRow(builder);
468 }
469
470 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
471 protected override global::System.Type GetRowType() {
472 return typeof(tblGIANG_VIENRow);
473 }
474
475 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
476 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
477 base.OnRowChanged(e);
478 if ((this.tblGIANG_VIENRowChanged != null)) {
479 this.tblGIANG_VIENRowChanged(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
480 }
481 }
482
483 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
484 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
485 base.OnRowChanging(e);
486 if ((this.tblGIANG_VIENRowChanging != null)) {
487 this.tblGIANG_VIENRowChanging(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
488 }
489 }
490
491 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
492 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
493 base.OnRowDeleted(e);
494 if ((this.tblGIANG_VIENRowDeleted != null)) {
495 this.tblGIANG_VIENRowDeleted(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
496 }
497 }
498
499 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
500 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
501 base.OnRowDeleting(e);
502 if ((this.tblGIANG_VIENRowDeleting != null)) {
503 this.tblGIANG_VIENRowDeleting(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
504 }
505 }
506
507 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
508 public void RemovetblGIANG_VIENRow(tblGIANG_VIENRow row) {
509 this.Rows.Remove(row);
510 }
511
512 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
513 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
514 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
515 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
516 QuanlydiemDataSet21 ds = new QuanlydiemDataSet21();
517 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
518 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
519 any1.MinOccurs = new decimal(0);
520 any1.MaxOccurs = decimal.MaxValue;
521 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
522 sequence.Items.Add(any1);
523 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
524 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
525 any2.MinOccurs = new decimal(1);
526 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
527 sequence.Items.Add(any2);
528 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
529 attribute1.Name = "namespace";
530 attribute1.FixedValue = ds.Namespace;
531 type.Attributes.Add(attribute1);
532 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
533 attribute2.Name = "tableTypeName";
534 attribute2.FixedValue = "tblGIANG_VIENDataTable";
535 type.Attributes.Add(attribute2);
536 type.Particle = sequence;
537 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
538 if (xs.Contains(dsSchema.TargetNamespace)) {
539 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
540 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
541 try {
542 global::System.Xml.Schema.XmlSchema schema = null;
543 dsSchema.Write(s1);
544 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
545 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
546 s2.SetLength(0);
547 schema.Write(s2);
548 if ((s1.Length == s2.Length)) {
549 s1.Position = 0;
550 s2.Position = 0;
551 for (; ((s1.Position != s1.Length)
552 && (s1.ReadByte() == s2.ReadByte())); ) {
553 ;
554 }
555 if ((s1.Position == s1.Length)) {
556 return type;
557 }
558 }
559 }
560 }
561 finally {
562 if ((s1 != null)) {
563 s1.Close();
564 }
565 if ((s2 != null)) {
566 s2.Close();
567 }
568 }
569 }
570 xs.Add(dsSchema);
571 return type;
572 }
573 }
574
575 /// <summary>
576 ///Represents strongly named DataRow class.
577 ///</summary>
578 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
579 public partial class tblGIANG_VIENRow : global::System.Data.DataRow {
580
581 private tblGIANG_VIENDataTable tabletblGIANG_VIEN;
582
583 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
584 internal tblGIANG_VIENRow(global::System.Data.DataRowBuilder rb) :
585 base(rb) {
586 this.tabletblGIANG_VIEN = ((tblGIANG_VIENDataTable)(this.Table));
587 }
588
589 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
590 public string MaGV {
591 get {
592 return ((string)(this[this.tabletblGIANG_VIEN.MaGVColumn]));
593 }
594 set {
595 this[this.tabletblGIANG_VIEN.MaGVColumn] = value;
596 }
597 }
598
599 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
600 public string TenGV {
601 get {
602 try {
603 return ((string)(this[this.tabletblGIANG_VIEN.TenGVColumn]));
604 }
605 catch (global::System.InvalidCastException e) {
606 throw new global::System.Data.StrongTypingException("The value for column \'TenGV\' in table \'tblGIANG_VIEN\' is DBNull.", e);
607 }
608 }
609 set {
610 this[this.tabletblGIANG_VIEN.TenGVColumn] = value;
611 }
612 }
613
614 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
615 public string GioiTinh {
616 get {
617 try {
618 return ((string)(this[this.tabletblGIANG_VIEN.GioiTinhColumn]));
619 }
620 catch (global::System.InvalidCastException e) {
621 throw new global::System.Data.StrongTypingException("The value for column \'GioiTinh\' in table \'tblGIANG_VIEN\' is DBNull.", e);
622 }
623 }
624 set {
625 this[this.tabletblGIANG_VIEN.GioiTinhColumn] = value;
626 }
627 }
628
629 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
630 public string Phone {
631 get {
632 try {
633 return ((string)(this[this.tabletblGIANG_VIEN.PhoneColumn]));
634 }
635 catch (global::System.InvalidCastException e) {
636 throw new global::System.Data.StrongTypingException("The value for column \'Phone\' in table \'tblGIANG_VIEN\' is DBNull.", e);
637 }
638 }
639 set {
640 this[this.tabletblGIANG_VIEN.PhoneColumn] = value;
641 }
642 }
643
644 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
645 public string Email {
646 get {
647 try {
648 return ((string)(this[this.tabletblGIANG_VIEN.EmailColumn]));
649 }
650 catch (global::System.InvalidCastException e) {
651 throw new global::System.Data.StrongTypingException("The value for column \'Email\' in table \'tblGIANG_VIEN\' is DBNull.", e);
652 }
653 }
654 set {
655 this[this.tabletblGIANG_VIEN.EmailColumn] = value;
656 }
657 }
658
659 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
660 public string PhanLoaiGV {
661 get {
662 try {
663 return ((string)(this[this.tabletblGIANG_VIEN.PhanLoaiGVColumn]));
664 }
665 catch (global::System.InvalidCastException e) {
666 throw new global::System.Data.StrongTypingException("The value for column \'PhanLoaiGV\' in table \'tblGIANG_VIEN\' is DBNull.", e);
667 }
668 }
669 set {
670 this[this.tabletblGIANG_VIEN.PhanLoaiGVColumn] = value;
671 }
672 }
673
674 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
675 public string Anh {
676 get {
677 try {
678 return ((string)(this[this.tabletblGIANG_VIEN.AnhColumn]));
679 }
680 catch (global::System.InvalidCastException e) {
681 throw new global::System.Data.StrongTypingException("The value for column \'Anh\' in table \'tblGIANG_VIEN\' is DBNull.", e);
682 }
683 }
684 set {
685 this[this.tabletblGIANG_VIEN.AnhColumn] = value;
686 }
687 }
688
689 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
690 public bool IsTenGVNull() {
691 return this.IsNull(this.tabletblGIANG_VIEN.TenGVColumn);
692 }
693
694 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
695 public void SetTenGVNull() {
696 this[this.tabletblGIANG_VIEN.TenGVColumn] = global::System.Convert.DBNull;
697 }
698
699 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
700 public bool IsGioiTinhNull() {
701 return this.IsNull(this.tabletblGIANG_VIEN.GioiTinhColumn);
702 }
703
704 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
705 public void SetGioiTinhNull() {
706 this[this.tabletblGIANG_VIEN.GioiTinhColumn] = global::System.Convert.DBNull;
707 }
708
709 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
710 public bool IsPhoneNull() {
711 return this.IsNull(this.tabletblGIANG_VIEN.PhoneColumn);
712 }
713
714 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
715 public void SetPhoneNull() {
716 this[this.tabletblGIANG_VIEN.PhoneColumn] = global::System.Convert.DBNull;
717 }
718
719 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
720 public bool IsEmailNull() {
721 return this.IsNull(this.tabletblGIANG_VIEN.EmailColumn);
722 }
723
724 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
725 public void SetEmailNull() {
726 this[this.tabletblGIANG_VIEN.EmailColumn] = global::System.Convert.DBNull;
727 }
728
729 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
730 public bool IsPhanLoaiGVNull() {
731 return this.IsNull(this.tabletblGIANG_VIEN.PhanLoaiGVColumn);
732 }
733
734 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
735 public void SetPhanLoaiGVNull() {
736 this[this.tabletblGIANG_VIEN.PhanLoaiGVColumn] = global::System.Convert.DBNull;
737 }
738
739 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
740 public bool IsAnhNull() {
741 return this.IsNull(this.tabletblGIANG_VIEN.AnhColumn);
742 }
743
744 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
745 public void SetAnhNull() {
746 this[this.tabletblGIANG_VIEN.AnhColumn] = global::System.Convert.DBNull;
747 }
748 }
749
750 /// <summary>
751 ///Row event argument class
752 ///</summary>
753 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
754 public class tblGIANG_VIENRowChangeEvent : global::System.EventArgs {
755
756 private tblGIANG_VIENRow eventRow;
757
758 private global::System.Data.DataRowAction eventAction;
759
760 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
761 public tblGIANG_VIENRowChangeEvent(tblGIANG_VIENRow row, global::System.Data.DataRowAction action) {
762 this.eventRow = row;
763 this.eventAction = action;
764 }
765
766 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
767 public tblGIANG_VIENRow Row {
768 get {
769 return this.eventRow;
770 }
771 }
772
773 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
774 public global::System.Data.DataRowAction Action {
775 get {
776 return this.eventAction;
777 }
778 }
779 }
780 }
781 }
782 namespace Quản_lý_điểm_sinh_vien_CNTT.QuanlydiemDataSet21TableAdapters {
783
784
785 /// <summary>
786 ///Represents the connection and commands used to retrieve and save data.
787 ///</summary>
788 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
789 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
790 [global::System.ComponentModel.ToolboxItem(true)]
791 [global::System.ComponentModel.DataObjectAttribute(true)]
792 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
793 ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
794 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
795 public partial class tblGIANG_VIENTableAdapter : global::System.ComponentModel.Component {
796
797 private global::System.Data.SqlClient.SqlDataAdapter _adapter;
798
799 private global::System.Data.SqlClient.SqlConnection _connection;
800
801 private global::System.Data.SqlClient.SqlTransaction _transaction;
802
803 private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
804
805 private bool _clearBeforeFill;
806
807 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
808 public tblGIANG_VIENTableAdapter() {
809 this.ClearBeforeFill = true;
810 }
811
812 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
813 protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
814 get {
815 if ((this._adapter == null)) {
816 this.InitAdapter();
817 }
818 return this._adapter;
819 }
820 }
821
822 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
823 internal global::System.Data.SqlClient.SqlConnection Connection {
824 get {
825 if ((this._connection == null)) {
826 this.InitConnection();
827 }
828 return this._connection;
829 }
830 set {
831 this._connection = value;
832 if ((this.Adapter.InsertCommand != null)) {
833 this.Adapter.InsertCommand.Connection = value;
834 }
835 if ((this.Adapter.DeleteCommand != null)) {
836 this.Adapter.DeleteCommand.Connection = value;
837 }
838 if ((this.Adapter.UpdateCommand != null)) {
839 this.Adapter.UpdateCommand.Connection = value;
840 }
841 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
842 if ((this.CommandCollection[i] != null)) {
843 ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
844 }
845 }
846 }
847 }
848
849 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
850 internal global::System.Data.SqlClient.SqlTransaction Transaction {
851 get {
852 return this._transaction;
853 }
854 set {
855 this._transaction = value;
856 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
857 this.CommandCollection[i].Transaction = this._transaction;
858 }
859 if (((this.Adapter != null)
860 && (this.Adapter.DeleteCommand != null))) {
861 this.Adapter.DeleteCommand.Transaction = this._transaction;
862 }
863 if (((this.Adapter != null)
864 && (this.Adapter.InsertCommand != null))) {
865 this.Adapter.InsertCommand.Transaction = this._transaction;
866 }
867 if (((this.Adapter != null)
868 && (this.Adapter.UpdateCommand != null))) {
869 this.Adapter.UpdateCommand.Transaction = this._transaction;
870 }
871 }
872 }
873
874 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
875 protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
876 get {
877 if ((this._commandCollection == null)) {
878 this.InitCommandCollection();
879 }
880 return this._commandCollection;
881 }
882 }
883
884 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
885 public bool ClearBeforeFill {
886 get {
887 return this._clearBeforeFill;
888 }
889 set {
890 this._clearBeforeFill = value;
891 }
892 }
893
894 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
895 private void InitAdapter() {
896 this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
897 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
898 tableMapping.SourceTable = "Table";
899 tableMapping.DataSetTable = "tblGIANG_VIEN";
900 tableMapping.ColumnMappings.Add("MaGV", "MaGV");
901 tableMapping.ColumnMappings.Add("TenGV", "TenGV");
902 tableMapping.ColumnMappings.Add("GioiTinh", "GioiTinh");
903 tableMapping.ColumnMappings.Add("Phone", "Phone");
904 tableMapping.ColumnMappings.Add("Email", "Email");
905 tableMapping.ColumnMappings.Add("PhanLoaiGV", "PhanLoaiGV");
906 tableMapping.ColumnMappings.Add("Anh", "Anh");
907 this._adapter.TableMappings.Add(tableMapping);
908 this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
909 this._adapter.DeleteCommand.Connection = this.Connection;
910 this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[tblGIANG_VIEN] WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)) AND ((@IsNull_Anh = 1 AND [Anh] IS NULL) OR ([Anh] = @Original_Anh)))";
911 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
912 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
913 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_TenGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
914 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
915 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_GioiTinh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
916 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
917 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Phone", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
918 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
919 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Email", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
920 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
921 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PhanLoaiGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
922 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
923 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Anh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
924 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
925 this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
926 this._adapter.InsertCommand.Connection = this.Connection;
927 this._adapter.InsertCommand.CommandText = @"INSERT INTO [dbo].[tblGIANG_VIEN] ([MaGV], [TenGV], [GioiTinh], [Phone], [Email], [PhanLoaiGV], [Anh]) VALUES (@MaGV, @TenGV, @GioiTinh, @Phone, @Email, @PhanLoaiGV, @Anh);
928 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)";
929 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
930 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
931 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
932 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
933 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
934 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
935 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
936 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
937 this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
938 this._adapter.UpdateCommand.Connection = this.Connection;
939 this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[tblGIANG_VIEN] SET [MaGV] = @MaGV, [TenGV] = @TenGV, [GioiTinh] = @GioiTinh, [Phone] = @Phone, [Email] = @Email, [PhanLoaiGV] = @PhanLoaiGV, [Anh] = @Anh WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)) AND ((@IsNull_Anh = 1 AND [Anh] IS NULL) OR ([Anh] = @Original_Anh)));
940 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)";
941 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
942 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
943 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
944 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
945 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
946 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
947 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
948 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
949 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
950 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_TenGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
951 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
952 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_GioiTinh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
953 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
954 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Phone", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
955 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
956 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Email", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
957 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
958 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PhanLoaiGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
959 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
960 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Anh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
961 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
962 }
963
964 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
965 private void InitConnection() {
966 this._connection = new global::System.Data.SqlClient.SqlConnection();
967 this._connection.ConnectionString = global::Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.Default.QuanlydiemConnectionString2;
968 }
969
970 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
971 private void InitCommandCollection() {
972 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
973 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
974 this._commandCollection[0].Connection = this.Connection;
975 this._commandCollection[0].CommandText = "SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM dbo.tblGIANG_VIE" +
976 "N";
977 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
978 }
979
980 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
981 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
982 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
983 public virtual int Fill(QuanlydiemDataSet21.tblGIANG_VIENDataTable dataTable) {
984 this.Adapter.SelectCommand = this.CommandCollection[0];
985 if ((this.ClearBeforeFill == true)) {
986 dataTable.Clear();
987 }
988 int returnValue = this.Adapter.Fill(dataTable);
989 return returnValue;
990 }
991
992 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
993 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
994 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
995 public virtual QuanlydiemDataSet21.tblGIANG_VIENDataTable GetData() {
996 this.Adapter.SelectCommand = this.CommandCollection[0];
997 QuanlydiemDataSet21.tblGIANG_VIENDataTable dataTable = new QuanlydiemDataSet21.tblGIANG_VIENDataTable();
998 this.Adapter.Fill(dataTable);
999 return dataTable;
1000 }
1001
1002 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1003 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1004 public virtual int Update(QuanlydiemDataSet21.tblGIANG_VIENDataTable dataTable) {
1005 return this.Adapter.Update(dataTable);
1006 }
1007
1008 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1009 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1010 public virtual int Update(QuanlydiemDataSet21 dataSet) {
1011 return this.Adapter.Update(dataSet, "tblGIANG_VIEN");
1012 }
1013
1014 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1015 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1016 public virtual int Update(global::System.Data.DataRow dataRow) {
1017 return this.Adapter.Update(new global::System.Data.DataRow[] {
1018 dataRow});
1019 }
1020
1021 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1022 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1023 public virtual int Update(global::System.Data.DataRow[] dataRows) {
1024 return this.Adapter.Update(dataRows);
1025 }
1026
1027 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1028 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1029 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
1030 public virtual int Delete(string Original_MaGV, string Original_TenGV, string Original_GioiTinh, string Original_Phone, string Original_Email, string Original_PhanLoaiGV, string Original_Anh) {
1031 if ((Original_MaGV == null)) {
1032 throw new global::System.ArgumentNullException("Original_MaGV");
1033 }
1034 else {
1035 this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(Original_MaGV));
1036 }
1037 if ((Original_TenGV == null)) {
1038 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
1039 this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
1040 }
1041 else {
1042 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
1043 this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_TenGV));
1044 }
1045 if ((Original_GioiTinh == null)) {
1046 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
1047 this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
1048 }
1049 else {
1050 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
1051 this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_GioiTinh));
1052 }
1053 if ((Original_Phone == null)) {
1054 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
1055 this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;
1056 }
1057 else {
1058 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
1059 this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_Phone));
1060 }
1061 if ((Original_Email == null)) {
1062 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
1063 this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
1064 }
1065 else {
1066 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
1067 this.Adapter.DeleteCommand.Parameters[8].Value = ((string)(Original_Email));
1068 }
1069 if ((Original_PhanLoaiGV == null)) {
1070 this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
1071 this.Adapter.DeleteCommand.Parameters[10].Value = global::System.DBNull.Value;
1072 }
1073 else {
1074 this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
1075 this.Adapter.DeleteCommand.Parameters[10].Value = ((string)(Original_PhanLoaiGV));
1076 }
1077 if ((Original_Anh == null)) {
1078 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1));
1079 this.Adapter.DeleteCommand.Parameters[12].Value = global::System.DBNull.Value;
1080 }
1081 else {
1082 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
1083 this.Adapter.DeleteCommand.Parameters[12].Value = ((string)(Original_Anh));
1084 }
1085 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
1086 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
1087 != global::System.Data.ConnectionState.Open)) {
1088 this.Adapter.DeleteCommand.Connection.Open();
1089 }
1090 try {
1091 int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
1092 return returnValue;
1093 }
1094 finally {
1095 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1096 this.Adapter.DeleteCommand.Connection.Close();
1097 }
1098 }
1099 }
1100
1101 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1102 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1103 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
1104 public virtual int Insert(string MaGV, string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh) {
1105 if ((MaGV == null)) {
1106 throw new global::System.ArgumentNullException("MaGV");
1107 }
1108 else {
1109 this.Adapter.InsertCommand.Parameters[0].Value = ((string)(MaGV));
1110 }
1111 if ((TenGV == null)) {
1112 this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
1113 }
1114 else {
1115 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(TenGV));
1116 }
1117 if ((GioiTinh == null)) {
1118 this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
1119 }
1120 else {
1121 this.Adapter.InsertCommand.Parameters[2].Value = ((string)(GioiTinh));
1122 }
1123 if ((Phone == null)) {
1124 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
1125 }
1126 else {
1127 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Phone));
1128 }
1129 if ((Email == null)) {
1130 this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
1131 }
1132 else {
1133 this.Adapter.InsertCommand.Parameters[4].Value = ((string)(Email));
1134 }
1135 if ((PhanLoaiGV == null)) {
1136 this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
1137 }
1138 else {
1139 this.Adapter.InsertCommand.Parameters[5].Value = ((string)(PhanLoaiGV));
1140 }
1141 if ((Anh == null)) {
1142 this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
1143 }
1144 else {
1145 this.Adapter.InsertCommand.Parameters[6].Value = ((string)(Anh));
1146 }
1147 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
1148 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
1149 != global::System.Data.ConnectionState.Open)) {
1150 this.Adapter.InsertCommand.Connection.Open();
1151 }
1152 try {
1153 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
1154 return returnValue;
1155 }
1156 finally {
1157 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1158 this.Adapter.InsertCommand.Connection.Close();
1159 }
1160 }
1161 }
1162
1163 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1164 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1165 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
1166 public virtual int Update(string MaGV, string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh, string Original_MaGV, string Original_TenGV, string Original_GioiTinh, string Original_Phone, string Original_Email, string Original_PhanLoaiGV, string Original_Anh) {
1167 if ((MaGV == null)) {
1168 throw new global::System.ArgumentNullException("MaGV");
1169 }
1170 else {
1171 this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(MaGV));
1172 }
1173 if ((TenGV == null)) {
1174 this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
1175 }
1176 else {
1177 this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(TenGV));
1178 }
1179 if ((GioiTinh == null)) {
1180 this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
1181 }
1182 else {
1183 this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(GioiTinh));
1184 }
1185 if ((Phone == null)) {
1186 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
1187 }
1188 else {
1189 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(Phone));
1190 }
1191 if ((Email == null)) {
1192 this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
1193 }
1194 else {
1195 this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(Email));
1196 }
1197 if ((PhanLoaiGV == null)) {
1198 this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
1199 }
1200 else {
1201 this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(PhanLoaiGV));
1202 }
1203 if ((Anh == null)) {
1204 this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
1205 }
1206 else {
1207 this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(Anh));
1208 }
1209 if ((Original_MaGV == null)) {
1210 throw new global::System.ArgumentNullException("Original_MaGV");
1211 }
1212 else {
1213 this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(Original_MaGV));
1214 }
1215 if ((Original_TenGV == null)) {
1216 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(1));
1217 this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value;
1218 }
1219 else {
1220 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(0));
1221 this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(Original_TenGV));
1222 }
1223 if ((Original_GioiTinh == null)) {
1224 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(1));
1225 this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value;
1226 }
1227 else {
1228 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(0));
1229 this.Adapter.UpdateCommand.Parameters[11].Value = ((string)(Original_GioiTinh));
1230 }
1231 if ((Original_Phone == null)) {
1232 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(1));
1233 this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value;
1234 }
1235 else {
1236 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(0));
1237 this.Adapter.UpdateCommand.Parameters[13].Value = ((string)(Original_Phone));
1238 }
1239 if ((Original_Email == null)) {
1240 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(1));
1241 this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value;
1242 }
1243 else {
1244 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(0));
1245 this.Adapter.UpdateCommand.Parameters[15].Value = ((string)(Original_Email));
1246 }
1247 if ((Original_PhanLoaiGV == null)) {
1248 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(1));
1249 this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value;
1250 }
1251 else {
1252 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(0));
1253 this.Adapter.UpdateCommand.Parameters[17].Value = ((string)(Original_PhanLoaiGV));
1254 }
1255 if ((Original_Anh == null)) {
1256 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(1));
1257 this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value;
1258 }
1259 else {
1260 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(0));
1261 this.Adapter.UpdateCommand.Parameters[19].Value = ((string)(Original_Anh));
1262 }
1263 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
1264 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
1265 != global::System.Data.ConnectionState.Open)) {
1266 this.Adapter.UpdateCommand.Connection.Open();
1267 }
1268 try {
1269 int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
1270 return returnValue;
1271 }
1272 finally {
1273 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1274 this.Adapter.UpdateCommand.Connection.Close();
1275 }
1276 }
1277 }
1278
1279 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1280 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1281 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
1282 public virtual int Update(string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh, string Original_MaGV, string Original_TenGV, string Original_GioiTinh, string Original_Phone, string Original_Email, string Original_PhanLoaiGV, string Original_Anh) {
1283 return this.Update(Original_MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh, Original_MaGV, Original_TenGV, Original_GioiTinh, Original_Phone, Original_Email, Original_PhanLoaiGV, Original_Anh);
1284 }
1285 }
1286
1287 /// <summary>
1288 ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
1289 ///</summary>
1290 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1291 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
1292 [global::System.ComponentModel.ToolboxItem(true)]
1293 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
1294 "esigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
1295 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
1296 public partial class TableAdapterManager : global::System.ComponentModel.Component {
1297
1298 private UpdateOrderOption _updateOrder;
1299
1300 private tblGIANG_VIENTableAdapter _tblGIANG_VIENTableAdapter;
1301
1302 private bool _backupDataSetBeforeUpdate;
1303
1304 private global::System.Data.IDbConnection _connection;
1305
1306 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1307 public UpdateOrderOption UpdateOrder {
1308 get {
1309 return this._updateOrder;
1310 }
1311 set {
1312 this._updateOrder = value;
1313 }
1314 }
1315
1316 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1317 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
1318 "ft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" +
1319 "", "System.Drawing.Design.UITypeEditor")]
1320 public tblGIANG_VIENTableAdapter tblGIANG_VIENTableAdapter {
1321 get {
1322 return this._tblGIANG_VIENTableAdapter;
1323 }
1324 set {
1325 this._tblGIANG_VIENTableAdapter = value;
1326 }
1327 }
1328
1329 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1330 public bool BackupDataSetBeforeUpdate {
1331 get {
1332 return this._backupDataSetBeforeUpdate;
1333 }
1334 set {
1335 this._backupDataSetBeforeUpdate = value;
1336 }
1337 }
1338
1339 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1340 [global::System.ComponentModel.Browsable(false)]
1341 public global::System.Data.IDbConnection Connection {
1342 get {
1343 if ((this._connection != null)) {
1344 return this._connection;
1345 }
1346 if (((this._tblGIANG_VIENTableAdapter != null)
1347 && (this._tblGIANG_VIENTableAdapter.Connection != null))) {
1348 return this._tblGIANG_VIENTableAdapter.Connection;
1349 }
1350 return null;
1351 }
1352 set {
1353 this._connection = value;
1354 }
1355 }
1356
1357 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1358 [global::System.ComponentModel.Browsable(false)]
1359 public int TableAdapterInstanceCount {
1360 get {
1361 int count = 0;
1362 if ((this._tblGIANG_VIENTableAdapter != null)) {
1363 count = (count + 1);
1364 }
1365 return count;
1366 }
1367 }
1368
1369 /// <summary>
1370 ///Update rows in top-down order.
1371 ///</summary>
1372 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1373 private int UpdateUpdatedRows(QuanlydiemDataSet21 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1374 int result = 0;
1375 if ((this._tblGIANG_VIENTableAdapter != null)) {
1376 global::System.Data.DataRow[] updatedRows = dataSet.tblGIANG_VIEN.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
1377 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
1378 if (((updatedRows != null)
1379 && (0 < updatedRows.Length))) {
1380 result = (result + this._tblGIANG_VIENTableAdapter.Update(updatedRows));
1381 allChangedRows.AddRange(updatedRows);
1382 }
1383 }
1384 return result;
1385 }
1386
1387 /// <summary>
1388 ///Insert rows in top-down order.
1389 ///</summary>
1390 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1391 private int UpdateInsertedRows(QuanlydiemDataSet21 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1392 int result = 0;
1393 if ((this._tblGIANG_VIENTableAdapter != null)) {
1394 global::System.Data.DataRow[] addedRows = dataSet.tblGIANG_VIEN.Select(null, null, global::System.Data.DataViewRowState.Added);
1395 if (((addedRows != null)
1396 && (0 < addedRows.Length))) {
1397 result = (result + this._tblGIANG_VIENTableAdapter.Update(addedRows));
1398 allAddedRows.AddRange(addedRows);
1399 }
1400 }
1401 return result;
1402 }
1403
1404 /// <summary>
1405 ///Delete rows in bottom-up order.
1406 ///</summary>
1407 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1408 private int UpdateDeletedRows(QuanlydiemDataSet21 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
1409 int result = 0;
1410 if ((this._tblGIANG_VIENTableAdapter != null)) {
1411 global::System.Data.DataRow[] deletedRows = dataSet.tblGIANG_VIEN.Select(null, null, global::System.Data.DataViewRowState.Deleted);
1412 if (((deletedRows != null)
1413 && (0 < deletedRows.Length))) {
1414 result = (result + this._tblGIANG_VIENTableAdapter.Update(deletedRows));
1415 allChangedRows.AddRange(deletedRows);
1416 }
1417 }
1418 return result;
1419 }
1420
1421 /// <summary>
1422 ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
1423 ///</summary>
1424 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1425 private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1426 if (((updatedRows == null)
1427 || (updatedRows.Length < 1))) {
1428 return updatedRows;
1429 }
1430 if (((allAddedRows == null)
1431 || (allAddedRows.Count < 1))) {
1432 return updatedRows;
1433 }
1434 global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1435 for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
1436 global::System.Data.DataRow row = updatedRows[i];
1437 if ((allAddedRows.Contains(row) == false)) {
1438 realUpdatedRows.Add(row);
1439 }
1440 }
1441 return realUpdatedRows.ToArray();
1442 }
1443
1444 /// <summary>
1445 ///Update all changes to the dataset.
1446 ///</summary>
1447 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1448 public virtual int UpdateAll(QuanlydiemDataSet21 dataSet) {
1449 if ((dataSet == null)) {
1450 throw new global::System.ArgumentNullException("dataSet");
1451 }
1452 if ((dataSet.HasChanges() == false)) {
1453 return 0;
1454 }
1455 if (((this._tblGIANG_VIENTableAdapter != null)
1456 && (this.MatchTableAdapterConnection(this._tblGIANG_VIENTableAdapter.Connection) == false))) {
1457 throw new global::System.ArgumentException("All TableAdapters managed by a TableAdapterManager must use the same connection s" +
1458 "tring.");
1459 }
1460 global::System.Data.IDbConnection workConnection = this.Connection;
1461 if ((workConnection == null)) {
1462 throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" +
1463 "ger TableAdapter property to a valid TableAdapter instance.");
1464 }
1465 bool workConnOpened = false;
1466 if (((workConnection.State & global::System.Data.ConnectionState.Broken)
1467 == global::System.Data.ConnectionState.Broken)) {
1468 workConnection.Close();
1469 }
1470 if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
1471 workConnection.Open();
1472 workConnOpened = true;
1473 }
1474 global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
1475 if ((workTransaction == null)) {
1476 throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" +
1477 "ctions or the current state is not allowing the transaction to begin.");
1478 }
1479 global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1480 global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1481 global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
1482 global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
1483 int result = 0;
1484 global::System.Data.DataSet backupDataSet = null;
1485 if (this.BackupDataSetBeforeUpdate) {
1486 backupDataSet = new global::System.Data.DataSet();
1487 backupDataSet.Merge(dataSet);
1488 }
1489 try {
1490 // ---- Prepare for update -----------
1491 //
1492 if ((this._tblGIANG_VIENTableAdapter != null)) {
1493 revertConnections.Add(this._tblGIANG_VIENTableAdapter, this._tblGIANG_VIENTableAdapter.Connection);
1494 this._tblGIANG_VIENTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
1495 this._tblGIANG_VIENTableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
1496 if (this._tblGIANG_VIENTableAdapter.Adapter.AcceptChangesDuringUpdate) {
1497 this._tblGIANG_VIENTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
1498 adaptersWithAcceptChangesDuringUpdate.Add(this._tblGIANG_VIENTableAdapter.Adapter);
1499 }
1500 }
1501 //
1502 //---- Perform updates -----------
1503 //
1504 if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
1505 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1506 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1507 }
1508 else {
1509 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1510 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1511 }
1512 result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
1513 //
1514 //---- Commit updates -----------
1515 //
1516 workTransaction.Commit();
1517 if ((0 < allAddedRows.Count)) {
1518 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1519 allAddedRows.CopyTo(rows);
1520 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1521 global::System.Data.DataRow row = rows[i];
1522 row.AcceptChanges();
1523 }
1524 }
1525 if ((0 < allChangedRows.Count)) {
1526 global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
1527 allChangedRows.CopyTo(rows);
1528 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1529 global::System.Data.DataRow row = rows[i];
1530 row.AcceptChanges();
1531 }
1532 }
1533 }
1534 catch (global::System.Exception ex) {
1535 workTransaction.Rollback();
1536 // ---- Restore the dataset -----------
1537 if (this.BackupDataSetBeforeUpdate) {
1538 global::System.Diagnostics.Debug.Assert((backupDataSet != null));
1539 dataSet.Clear();
1540 dataSet.Merge(backupDataSet);
1541 }
1542 else {
1543 if ((0 < allAddedRows.Count)) {
1544 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1545 allAddedRows.CopyTo(rows);
1546 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1547 global::System.Data.DataRow row = rows[i];
1548 row.AcceptChanges();
1549 row.SetAdded();
1550 }
1551 }
1552 }
1553 throw ex;
1554 }
1555 finally {
1556 if (workConnOpened) {
1557 workConnection.Close();
1558 }
1559 if ((this._tblGIANG_VIENTableAdapter != null)) {
1560 this._tblGIANG_VIENTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._tblGIANG_VIENTableAdapter]));
1561 this._tblGIANG_VIENTableAdapter.Transaction = null;
1562 }
1563 if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
1564 global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
1565 adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
1566 for (int i = 0; (i < adapters.Length); i = (i + 1)) {
1567 global::System.Data.Common.DataAdapter adapter = adapters[i];
1568 adapter.AcceptChangesDuringUpdate = true;
1569 }
1570 }
1571 }
1572 return result;
1573 }
1574
1575 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1576 protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
1577 global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
1578 }
1579
1580 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1581 protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
1582 if ((this._connection != null)) {
1583 return true;
1584 }
1585 if (((this.Connection == null)
1586 || (inputConnection == null))) {
1587 return true;
1588 }
1589 if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
1590 return true;
1591 }
1592 return false;
1593 }
1594
1595 /// <summary>
1596 ///Update Order Option
1597 ///</summary>
1598 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1599 public enum UpdateOrderOption {
1600
1601 InsertUpdateDelete = 0,
1602
1603 UpdateInsertDelete = 1,
1604 }
1605
1606 /// <summary>
1607 ///Used to sort self-referenced table's rows
1608 ///</summary>
1609 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1610 private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
1611
1612 private global::System.Data.DataRelation _relation;
1613
1614 private int _childFirst;
1615
1616 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1617 internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
1618 this._relation = relation;
1619 if (childFirst) {
1620 this._childFirst = -1;
1621 }
1622 else {
1623 this._childFirst = 1;
1624 }
1625 }
1626
1627 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1628 private bool IsChildAndParent(global::System.Data.DataRow child, global::System.Data.DataRow parent) {
1629 global::System.Diagnostics.Debug.Assert((child != null));
1630 global::System.Diagnostics.Debug.Assert((parent != null));
1631 global::System.Data.DataRow newParent = child.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1632 for (
1633 ; ((newParent != null)
1634 && ((object.ReferenceEquals(newParent, child) == false)
1635 && (object.ReferenceEquals(newParent, parent) == false)));
1636 ) {
1637 newParent = newParent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1638 }
1639 if ((newParent == null)) {
1640 for (newParent = child.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original); ((newParent != null)
1641 && ((object.ReferenceEquals(newParent, child) == false)
1642 && (object.ReferenceEquals(newParent, parent) == false)));
1643 ) {
1644 newParent = newParent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
1645 }
1646 }
1647 if (object.ReferenceEquals(newParent, parent)) {
1648 return true;
1649 }
1650 return false;
1651 }
1652
1653 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1654 public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
1655 if (object.ReferenceEquals(row1, row2)) {
1656 return 0;
1657 }
1658 if ((row1 == null)) {
1659 return -1;
1660 }
1661 if ((row2 == null)) {
1662 return 1;
1663 }
1664
1665 // Is row1 the child or grandchild of row2
1666 if (this.IsChildAndParent(row1, row2)) {
1667 return this._childFirst;
1668 }
1669
1670 // Is row2 the child or grandchild of row1
1671 if (this.IsChildAndParent(row2, row1)) {
1672 return (-1 * this._childFirst);
1673 }
1674 return 0;
1675 }
1676 }
1677 }
1678 }
1679
1680 #pragma warning restore 1591
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("QuanlydiemDataSet21")]
25 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
26 public partial class QuanlydiemDataSet21 : global::System.Data.DataSet {
27
28 private tblGIANG_VIENDataTable tabletblGIANG_VIEN;
29
30 private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
31
32 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
33 public QuanlydiemDataSet21() {
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 QuanlydiemDataSet21(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["tblGIANG_VIEN"] != null)) {
57 base.Tables.Add(new tblGIANG_VIENDataTable(ds.Tables["tblGIANG_VIEN"]));
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 tblGIANG_VIENDataTable tblGIANG_VIEN {
81 get {
82 return this.tabletblGIANG_VIEN;
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 QuanlydiemDataSet21 cln = ((QuanlydiemDataSet21)(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["tblGIANG_VIEN"] != null)) {
146 base.Tables.Add(new tblGIANG_VIENDataTable(ds.Tables["tblGIANG_VIEN"]));
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.tabletblGIANG_VIEN = ((tblGIANG_VIENDataTable)(base.Tables["tblGIANG_VIEN"]));
179 if ((initTable == true)) {
180 if ((this.tabletblGIANG_VIEN != null)) {
181 this.tabletblGIANG_VIEN.InitVars();
182 }
183 }
184 }
185
186 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
187 private void InitClass() {
188 this.DataSetName = "QuanlydiemDataSet21";
189 this.Prefix = "";
190 this.Namespace = "http://tempuri.org/QuanlydiemDataSet211.xsd";
191 this.EnforceConstraints = true;
192 this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
193 this.tabletblGIANG_VIEN = new tblGIANG_VIENDataTable();
194 base.Tables.Add(this.tabletblGIANG_VIEN);
195 }
196
197 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
198 private bool ShouldSerializetblGIANG_VIEN() {
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 QuanlydiemDataSet21 ds = new QuanlydiemDataSet21();
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 tblGIANG_VIENRowChangeEventHandler(object sender, tblGIANG_VIENRowChangeEvent 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 tblGIANG_VIENDataTable : global::System.Data.TypedTableBase<tblGIANG_VIENRow> {
264
265 private global::System.Data.DataColumn columnMaGV;
266
267 private global::System.Data.DataColumn columnTenGV;
268
269 private global::System.Data.DataColumn columnGioiTinh;
270
271 private global::System.Data.DataColumn columnPhone;
272
273 private global::System.Data.DataColumn columnEmail;
274
275 private global::System.Data.DataColumn columnPhanLoaiGV;
276
277 private global::System.Data.DataColumn columnAnh;
278
279 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
280 public tblGIANG_VIENDataTable() {
281 this.TableName = "tblGIANG_VIEN";
282 this.BeginInit();
283 this.InitClass();
284 this.EndInit();
285 }
286
287 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
288 internal tblGIANG_VIENDataTable(global::System.Data.DataTable table) {
289 this.TableName = table.TableName;
290 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
291 this.CaseSensitive = table.CaseSensitive;
292 }
293 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
294 this.Locale = table.Locale;
295 }
296 if ((table.Namespace != table.DataSet.Namespace)) {
297 this.Namespace = table.Namespace;
298 }
299 this.Prefix = table.Prefix;
300 this.MinimumCapacity = table.MinimumCapacity;
301 }
302
303 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
304 protected tblGIANG_VIENDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
305 base(info, context) {
306 this.InitVars();
307 }
308
309 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
310 public global::System.Data.DataColumn MaGVColumn {
311 get {
312 return this.columnMaGV;
313 }
314 }
315
316 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
317 public global::System.Data.DataColumn TenGVColumn {
318 get {
319 return this.columnTenGV;
320 }
321 }
322
323 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
324 public global::System.Data.DataColumn GioiTinhColumn {
325 get {
326 return this.columnGioiTinh;
327 }
328 }
329
330 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
331 public global::System.Data.DataColumn PhoneColumn {
332 get {
333 return this.columnPhone;
334 }
335 }
336
337 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
338 public global::System.Data.DataColumn EmailColumn {
339 get {
340 return this.columnEmail;
341 }
342 }
343
344 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
345 public global::System.Data.DataColumn PhanLoaiGVColumn {
346 get {
347 return this.columnPhanLoaiGV;
348 }
349 }
350
351 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
352 public global::System.Data.DataColumn AnhColumn {
353 get {
354 return this.columnAnh;
355 }
356 }
357
358 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
359 [global::System.ComponentModel.Browsable(false)]
360 public int Count {
361 get {
362 return this.Rows.Count;
363 }
364 }
365
366 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
367 public tblGIANG_VIENRow this[int index] {
368 get {
369 return ((tblGIANG_VIENRow)(this.Rows[index]));
370 }
371 }
372
373 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowChanging;
374
375 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowChanged;
376
377 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowDeleting;
378
379 public event tblGIANG_VIENRowChangeEventHandler tblGIANG_VIENRowDeleted;
380
381 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
382 public void AddtblGIANG_VIENRow(tblGIANG_VIENRow row) {
383 this.Rows.Add(row);
384 }
385
386 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
387 public tblGIANG_VIENRow AddtblGIANG_VIENRow(string MaGV, string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh) {
388 tblGIANG_VIENRow rowtblGIANG_VIENRow = ((tblGIANG_VIENRow)(this.NewRow()));
389 object[] columnValuesArray = new object[] {
390 MaGV,
391 TenGV,
392 GioiTinh,
393 Phone,
394 Email,
395 PhanLoaiGV,
396 Anh};
397 rowtblGIANG_VIENRow.ItemArray = columnValuesArray;
398 this.Rows.Add(rowtblGIANG_VIENRow);
399 return rowtblGIANG_VIENRow;
400 }
401
402 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
403 public tblGIANG_VIENRow FindByMaGV(string MaGV) {
404 return ((tblGIANG_VIENRow)(this.Rows.Find(new object[] {
405 MaGV})));
406 }
407
408 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
409 public override global::System.Data.DataTable Clone() {
410 tblGIANG_VIENDataTable cln = ((tblGIANG_VIENDataTable)(base.Clone()));
411 cln.InitVars();
412 return cln;
413 }
414
415 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
416 protected override global::System.Data.DataTable CreateInstance() {
417 return new tblGIANG_VIENDataTable();
418 }
419
420 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
421 internal void InitVars() {
422 this.columnMaGV = base.Columns["MaGV"];
423 this.columnTenGV = base.Columns["TenGV"];
424 this.columnGioiTinh = base.Columns["GioiTinh"];
425 this.columnPhone = base.Columns["Phone"];
426 this.columnEmail = base.Columns["Email"];
427 this.columnPhanLoaiGV = base.Columns["PhanLoaiGV"];
428 this.columnAnh = base.Columns["Anh"];
429 }
430
431 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
432 private void InitClass() {
433 this.columnMaGV = new global::System.Data.DataColumn("MaGV", typeof(string), null, global::System.Data.MappingType.Element);
434 base.Columns.Add(this.columnMaGV);
435 this.columnTenGV = new global::System.Data.DataColumn("TenGV", typeof(string), null, global::System.Data.MappingType.Element);
436 base.Columns.Add(this.columnTenGV);
437 this.columnGioiTinh = new global::System.Data.DataColumn("GioiTinh", typeof(string), null, global::System.Data.MappingType.Element);
438 base.Columns.Add(this.columnGioiTinh);
439 this.columnPhone = new global::System.Data.DataColumn("Phone", typeof(string), null, global::System.Data.MappingType.Element);
440 base.Columns.Add(this.columnPhone);
441 this.columnEmail = new global::System.Data.DataColumn("Email", typeof(string), null, global::System.Data.MappingType.Element);
442 base.Columns.Add(this.columnEmail);
443 this.columnPhanLoaiGV = new global::System.Data.DataColumn("PhanLoaiGV", typeof(string), null, global::System.Data.MappingType.Element);
444 base.Columns.Add(this.columnPhanLoaiGV);
445 this.columnAnh = new global::System.Data.DataColumn("Anh", typeof(string), null, global::System.Data.MappingType.Element);
446 base.Columns.Add(this.columnAnh);
447 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
448 this.columnMaGV}, true));
449 this.columnMaGV.AllowDBNull = false;
450 this.columnMaGV.Unique = true;
451 this.columnMaGV.MaxLength = 10;
452 this.columnTenGV.MaxLength = 30;
453 this.columnGioiTinh.MaxLength = 10;
454 this.columnPhone.MaxLength = 12;
455 this.columnEmail.MaxLength = 20;
456 this.columnPhanLoaiGV.MaxLength = 20;
457 this.columnAnh.MaxLength = 50;
458 }
459
460 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
461 public tblGIANG_VIENRow NewtblGIANG_VIENRow() {
462 return ((tblGIANG_VIENRow)(this.NewRow()));
463 }
464
465 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
466 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
467 return new tblGIANG_VIENRow(builder);
468 }
469
470 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
471 protected override global::System.Type GetRowType() {
472 return typeof(tblGIANG_VIENRow);
473 }
474
475 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
476 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
477 base.OnRowChanged(e);
478 if ((this.tblGIANG_VIENRowChanged != null)) {
479 this.tblGIANG_VIENRowChanged(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
480 }
481 }
482
483 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
484 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
485 base.OnRowChanging(e);
486 if ((this.tblGIANG_VIENRowChanging != null)) {
487 this.tblGIANG_VIENRowChanging(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
488 }
489 }
490
491 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
492 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
493 base.OnRowDeleted(e);
494 if ((this.tblGIANG_VIENRowDeleted != null)) {
495 this.tblGIANG_VIENRowDeleted(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
496 }
497 }
498
499 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
500 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
501 base.OnRowDeleting(e);
502 if ((this.tblGIANG_VIENRowDeleting != null)) {
503 this.tblGIANG_VIENRowDeleting(this, new tblGIANG_VIENRowChangeEvent(((tblGIANG_VIENRow)(e.Row)), e.Action));
504 }
505 }
506
507 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
508 public void RemovetblGIANG_VIENRow(tblGIANG_VIENRow row) {
509 this.Rows.Remove(row);
510 }
511
512 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
513 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
514 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
515 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
516 QuanlydiemDataSet21 ds = new QuanlydiemDataSet21();
517 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
518 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
519 any1.MinOccurs = new decimal(0);
520 any1.MaxOccurs = decimal.MaxValue;
521 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
522 sequence.Items.Add(any1);
523 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
524 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
525 any2.MinOccurs = new decimal(1);
526 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
527 sequence.Items.Add(any2);
528 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
529 attribute1.Name = "namespace";
530 attribute1.FixedValue = ds.Namespace;
531 type.Attributes.Add(attribute1);
532 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
533 attribute2.Name = "tableTypeName";
534 attribute2.FixedValue = "tblGIANG_VIENDataTable";
535 type.Attributes.Add(attribute2);
536 type.Particle = sequence;
537 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
538 if (xs.Contains(dsSchema.TargetNamespace)) {
539 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
540 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
541 try {
542 global::System.Xml.Schema.XmlSchema schema = null;
543 dsSchema.Write(s1);
544 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
545 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
546 s2.SetLength(0);
547 schema.Write(s2);
548 if ((s1.Length == s2.Length)) {
549 s1.Position = 0;
550 s2.Position = 0;
551 for (; ((s1.Position != s1.Length)
552 && (s1.ReadByte() == s2.ReadByte())); ) {
553 ;
554 }
555 if ((s1.Position == s1.Length)) {
556 return type;
557 }
558 }
559 }
560 }
561 finally {
562 if ((s1 != null)) {
563 s1.Close();
564 }
565 if ((s2 != null)) {
566 s2.Close();
567 }
568 }
569 }
570 xs.Add(dsSchema);
571 return type;
572 }
573 }
574
575 /// <summary>
576 ///Represents strongly named DataRow class.
577 ///</summary>
578 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
579 public partial class tblGIANG_VIENRow : global::System.Data.DataRow {
580
581 private tblGIANG_VIENDataTable tabletblGIANG_VIEN;
582
583 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
584 internal tblGIANG_VIENRow(global::System.Data.DataRowBuilder rb) :
585 base(rb) {
586 this.tabletblGIANG_VIEN = ((tblGIANG_VIENDataTable)(this.Table));
587 }
588
589 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
590 public string MaGV {
591 get {
592 return ((string)(this[this.tabletblGIANG_VIEN.MaGVColumn]));
593 }
594 set {
595 this[this.tabletblGIANG_VIEN.MaGVColumn] = value;
596 }
597 }
598
599 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
600 public string TenGV {
601 get {
602 try {
603 return ((string)(this[this.tabletblGIANG_VIEN.TenGVColumn]));
604 }
605 catch (global::System.InvalidCastException e) {
606 throw new global::System.Data.StrongTypingException("The value for column \'TenGV\' in table \'tblGIANG_VIEN\' is DBNull.", e);
607 }
608 }
609 set {
610 this[this.tabletblGIANG_VIEN.TenGVColumn] = value;
611 }
612 }
613
614 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
615 public string GioiTinh {
616 get {
617 try {
618 return ((string)(this[this.tabletblGIANG_VIEN.GioiTinhColumn]));
619 }
620 catch (global::System.InvalidCastException e) {
621 throw new global::System.Data.StrongTypingException("The value for column \'GioiTinh\' in table \'tblGIANG_VIEN\' is DBNull.", e);
622 }
623 }
624 set {
625 this[this.tabletblGIANG_VIEN.GioiTinhColumn] = value;
626 }
627 }
628
629 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
630 public string Phone {
631 get {
632 try {
633 return ((string)(this[this.tabletblGIANG_VIEN.PhoneColumn]));
634 }
635 catch (global::System.InvalidCastException e) {
636 throw new global::System.Data.StrongTypingException("The value for column \'Phone\' in table \'tblGIANG_VIEN\' is DBNull.", e);
637 }
638 }
639 set {
640 this[this.tabletblGIANG_VIEN.PhoneColumn] = value;
641 }
642 }
643
644 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
645 public string Email {
646 get {
647 try {
648 return ((string)(this[this.tabletblGIANG_VIEN.EmailColumn]));
649 }
650 catch (global::System.InvalidCastException e) {
651 throw new global::System.Data.StrongTypingException("The value for column \'Email\' in table \'tblGIANG_VIEN\' is DBNull.", e);
652 }
653 }
654 set {
655 this[this.tabletblGIANG_VIEN.EmailColumn] = value;
656 }
657 }
658
659 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
660 public string PhanLoaiGV {
661 get {
662 try {
663 return ((string)(this[this.tabletblGIANG_VIEN.PhanLoaiGVColumn]));
664 }
665 catch (global::System.InvalidCastException e) {
666 throw new global::System.Data.StrongTypingException("The value for column \'PhanLoaiGV\' in table \'tblGIANG_VIEN\' is DBNull.", e);
667 }
668 }
669 set {
670 this[this.tabletblGIANG_VIEN.PhanLoaiGVColumn] = value;
671 }
672 }
673
674 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
675 public string Anh {
676 get {
677 try {
678 return ((string)(this[this.tabletblGIANG_VIEN.AnhColumn]));
679 }
680 catch (global::System.InvalidCastException e) {
681 throw new global::System.Data.StrongTypingException("The value for column \'Anh\' in table \'tblGIANG_VIEN\' is DBNull.", e);
682 }
683 }
684 set {
685 this[this.tabletblGIANG_VIEN.AnhColumn] = value;
686 }
687 }
688
689 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
690 public bool IsTenGVNull() {
691 return this.IsNull(this.tabletblGIANG_VIEN.TenGVColumn);
692 }
693
694 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
695 public void SetTenGVNull() {
696 this[this.tabletblGIANG_VIEN.TenGVColumn] = global::System.Convert.DBNull;
697 }
698
699 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
700 public bool IsGioiTinhNull() {
701 return this.IsNull(this.tabletblGIANG_VIEN.GioiTinhColumn);
702 }
703
704 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
705 public void SetGioiTinhNull() {
706 this[this.tabletblGIANG_VIEN.GioiTinhColumn] = global::System.Convert.DBNull;
707 }
708
709 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
710 public bool IsPhoneNull() {
711 return this.IsNull(this.tabletblGIANG_VIEN.PhoneColumn);
712 }
713
714 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
715 public void SetPhoneNull() {
716 this[this.tabletblGIANG_VIEN.PhoneColumn] = global::System.Convert.DBNull;
717 }
718
719 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
720 public bool IsEmailNull() {
721 return this.IsNull(this.tabletblGIANG_VIEN.EmailColumn);
722 }
723
724 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
725 public void SetEmailNull() {
726 this[this.tabletblGIANG_VIEN.EmailColumn] = global::System.Convert.DBNull;
727 }
728
729 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
730 public bool IsPhanLoaiGVNull() {
731 return this.IsNull(this.tabletblGIANG_VIEN.PhanLoaiGVColumn);
732 }
733
734 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
735 public void SetPhanLoaiGVNull() {
736 this[this.tabletblGIANG_VIEN.PhanLoaiGVColumn] = global::System.Convert.DBNull;
737 }
738
739 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
740 public bool IsAnhNull() {
741 return this.IsNull(this.tabletblGIANG_VIEN.AnhColumn);
742 }
743
744 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
745 public void SetAnhNull() {
746 this[this.tabletblGIANG_VIEN.AnhColumn] = global::System.Convert.DBNull;
747 }
748 }
749
750 /// <summary>
751 ///Row event argument class
752 ///</summary>
753 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
754 public class tblGIANG_VIENRowChangeEvent : global::System.EventArgs {
755
756 private tblGIANG_VIENRow eventRow;
757
758 private global::System.Data.DataRowAction eventAction;
759
760 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
761 public tblGIANG_VIENRowChangeEvent(tblGIANG_VIENRow row, global::System.Data.DataRowAction action) {
762 this.eventRow = row;
763 this.eventAction = action;
764 }
765
766 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
767 public tblGIANG_VIENRow Row {
768 get {
769 return this.eventRow;
770 }
771 }
772
773 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
774 public global::System.Data.DataRowAction Action {
775 get {
776 return this.eventAction;
777 }
778 }
779 }
780 }
781 }
782 namespace Quản_lý_điểm_sinh_vien_CNTT.QuanlydiemDataSet21TableAdapters {
783
784
785 /// <summary>
786 ///Represents the connection and commands used to retrieve and save data.
787 ///</summary>
788 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
789 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
790 [global::System.ComponentModel.ToolboxItem(true)]
791 [global::System.ComponentModel.DataObjectAttribute(true)]
792 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
793 ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
794 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
795 public partial class tblGIANG_VIENTableAdapter : global::System.ComponentModel.Component {
796
797 private global::System.Data.SqlClient.SqlDataAdapter _adapter;
798
799 private global::System.Data.SqlClient.SqlConnection _connection;
800
801 private global::System.Data.SqlClient.SqlTransaction _transaction;
802
803 private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
804
805 private bool _clearBeforeFill;
806
807 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
808 public tblGIANG_VIENTableAdapter() {
809 this.ClearBeforeFill = true;
810 }
811
812 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
813 protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
814 get {
815 if ((this._adapter == null)) {
816 this.InitAdapter();
817 }
818 return this._adapter;
819 }
820 }
821
822 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
823 internal global::System.Data.SqlClient.SqlConnection Connection {
824 get {
825 if ((this._connection == null)) {
826 this.InitConnection();
827 }
828 return this._connection;
829 }
830 set {
831 this._connection = value;
832 if ((this.Adapter.InsertCommand != null)) {
833 this.Adapter.InsertCommand.Connection = value;
834 }
835 if ((this.Adapter.DeleteCommand != null)) {
836 this.Adapter.DeleteCommand.Connection = value;
837 }
838 if ((this.Adapter.UpdateCommand != null)) {
839 this.Adapter.UpdateCommand.Connection = value;
840 }
841 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
842 if ((this.CommandCollection[i] != null)) {
843 ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
844 }
845 }
846 }
847 }
848
849 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
850 internal global::System.Data.SqlClient.SqlTransaction Transaction {
851 get {
852 return this._transaction;
853 }
854 set {
855 this._transaction = value;
856 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
857 this.CommandCollection[i].Transaction = this._transaction;
858 }
859 if (((this.Adapter != null)
860 && (this.Adapter.DeleteCommand != null))) {
861 this.Adapter.DeleteCommand.Transaction = this._transaction;
862 }
863 if (((this.Adapter != null)
864 && (this.Adapter.InsertCommand != null))) {
865 this.Adapter.InsertCommand.Transaction = this._transaction;
866 }
867 if (((this.Adapter != null)
868 && (this.Adapter.UpdateCommand != null))) {
869 this.Adapter.UpdateCommand.Transaction = this._transaction;
870 }
871 }
872 }
873
874 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
875 protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
876 get {
877 if ((this._commandCollection == null)) {
878 this.InitCommandCollection();
879 }
880 return this._commandCollection;
881 }
882 }
883
884 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
885 public bool ClearBeforeFill {
886 get {
887 return this._clearBeforeFill;
888 }
889 set {
890 this._clearBeforeFill = value;
891 }
892 }
893
894 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
895 private void InitAdapter() {
896 this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
897 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
898 tableMapping.SourceTable = "Table";
899 tableMapping.DataSetTable = "tblGIANG_VIEN";
900 tableMapping.ColumnMappings.Add("MaGV", "MaGV");
901 tableMapping.ColumnMappings.Add("TenGV", "TenGV");
902 tableMapping.ColumnMappings.Add("GioiTinh", "GioiTinh");
903 tableMapping.ColumnMappings.Add("Phone", "Phone");
904 tableMapping.ColumnMappings.Add("Email", "Email");
905 tableMapping.ColumnMappings.Add("PhanLoaiGV", "PhanLoaiGV");
906 tableMapping.ColumnMappings.Add("Anh", "Anh");
907 this._adapter.TableMappings.Add(tableMapping);
908 this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
909 this._adapter.DeleteCommand.Connection = this.Connection;
910 this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[tblGIANG_VIEN] WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)) AND ((@IsNull_Anh = 1 AND [Anh] IS NULL) OR ([Anh] = @Original_Anh)))";
911 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
912 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
913 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_TenGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
914 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
915 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_GioiTinh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
916 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
917 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Phone", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
918 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
919 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Email", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
920 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
921 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PhanLoaiGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
922 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
923 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Anh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
924 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
925 this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
926 this._adapter.InsertCommand.Connection = this.Connection;
927 this._adapter.InsertCommand.CommandText = @"INSERT INTO [dbo].[tblGIANG_VIEN] ([MaGV], [TenGV], [GioiTinh], [Phone], [Email], [PhanLoaiGV], [Anh]) VALUES (@MaGV, @TenGV, @GioiTinh, @Phone, @Email, @PhanLoaiGV, @Anh);
928 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)";
929 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
930 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
931 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
932 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
933 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
934 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
935 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
936 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
937 this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
938 this._adapter.UpdateCommand.Connection = this.Connection;
939 this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[tblGIANG_VIEN] SET [MaGV] = @MaGV, [TenGV] = @TenGV, [GioiTinh] = @GioiTinh, [Phone] = @Phone, [Email] = @Email, [PhanLoaiGV] = @PhanLoaiGV, [Anh] = @Anh WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)) AND ((@IsNull_Anh = 1 AND [Anh] IS NULL) OR ([Anh] = @Original_Anh)));
940 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)";
941 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
942 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
943 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
944 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
945 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
946 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
947 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
948 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
949 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_MaGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "MaGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
950 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_TenGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
951 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_TenGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "TenGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
952 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_GioiTinh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
953 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_GioiTinh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "GioiTinh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
954 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Phone", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
955 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Phone", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Phone", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
956 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Email", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
957 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Email", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
958 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PhanLoaiGV", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
959 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PhanLoaiGV", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PhanLoaiGV", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
960 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Anh", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
961 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Anh", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Anh", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
962 }
963
964 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
965 private void InitConnection() {
966 this._connection = new global::System.Data.SqlClient.SqlConnection();
967 this._connection.ConnectionString = global::Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.Default.QuanlydiemConnectionString2;
968 }
969
970 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
971 private void InitCommandCollection() {
972 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
973 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
974 this._commandCollection[0].Connection = this.Connection;
975 this._commandCollection[0].CommandText = "SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM dbo.tblGIANG_VIE" +
976 "N";
977 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
978 }
979
980 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
981 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
982 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
983 public virtual int Fill(QuanlydiemDataSet21.tblGIANG_VIENDataTable dataTable) {
984 this.Adapter.SelectCommand = this.CommandCollection[0];
985 if ((this.ClearBeforeFill == true)) {
986 dataTable.Clear();
987 }
988 int returnValue = this.Adapter.Fill(dataTable);
989 return returnValue;
990 }
991
992 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
993 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
994 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
995 public virtual QuanlydiemDataSet21.tblGIANG_VIENDataTable GetData() {
996 this.Adapter.SelectCommand = this.CommandCollection[0];
997 QuanlydiemDataSet21.tblGIANG_VIENDataTable dataTable = new QuanlydiemDataSet21.tblGIANG_VIENDataTable();
998 this.Adapter.Fill(dataTable);
999 return dataTable;
1000 }
1001
1002 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1003 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1004 public virtual int Update(QuanlydiemDataSet21.tblGIANG_VIENDataTable dataTable) {
1005 return this.Adapter.Update(dataTable);
1006 }
1007
1008 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1009 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1010 public virtual int Update(QuanlydiemDataSet21 dataSet) {
1011 return this.Adapter.Update(dataSet, "tblGIANG_VIEN");
1012 }
1013
1014 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1015 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1016 public virtual int Update(global::System.Data.DataRow dataRow) {
1017 return this.Adapter.Update(new global::System.Data.DataRow[] {
1018 dataRow});
1019 }
1020
1021 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1022 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1023 public virtual int Update(global::System.Data.DataRow[] dataRows) {
1024 return this.Adapter.Update(dataRows);
1025 }
1026
1027 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1028 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1029 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
1030 public virtual int Delete(string Original_MaGV, string Original_TenGV, string Original_GioiTinh, string Original_Phone, string Original_Email, string Original_PhanLoaiGV, string Original_Anh) {
1031 if ((Original_MaGV == null)) {
1032 throw new global::System.ArgumentNullException("Original_MaGV");
1033 }
1034 else {
1035 this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(Original_MaGV));
1036 }
1037 if ((Original_TenGV == null)) {
1038 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
1039 this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
1040 }
1041 else {
1042 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
1043 this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_TenGV));
1044 }
1045 if ((Original_GioiTinh == null)) {
1046 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
1047 this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
1048 }
1049 else {
1050 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
1051 this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_GioiTinh));
1052 }
1053 if ((Original_Phone == null)) {
1054 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
1055 this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;
1056 }
1057 else {
1058 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
1059 this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_Phone));
1060 }
1061 if ((Original_Email == null)) {
1062 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
1063 this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
1064 }
1065 else {
1066 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
1067 this.Adapter.DeleteCommand.Parameters[8].Value = ((string)(Original_Email));
1068 }
1069 if ((Original_PhanLoaiGV == null)) {
1070 this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
1071 this.Adapter.DeleteCommand.Parameters[10].Value = global::System.DBNull.Value;
1072 }
1073 else {
1074 this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
1075 this.Adapter.DeleteCommand.Parameters[10].Value = ((string)(Original_PhanLoaiGV));
1076 }
1077 if ((Original_Anh == null)) {
1078 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1));
1079 this.Adapter.DeleteCommand.Parameters[12].Value = global::System.DBNull.Value;
1080 }
1081 else {
1082 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
1083 this.Adapter.DeleteCommand.Parameters[12].Value = ((string)(Original_Anh));
1084 }
1085 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
1086 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
1087 != global::System.Data.ConnectionState.Open)) {
1088 this.Adapter.DeleteCommand.Connection.Open();
1089 }
1090 try {
1091 int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
1092 return returnValue;
1093 }
1094 finally {
1095 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1096 this.Adapter.DeleteCommand.Connection.Close();
1097 }
1098 }
1099 }
1100
1101 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1102 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1103 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
1104 public virtual int Insert(string MaGV, string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh) {
1105 if ((MaGV == null)) {
1106 throw new global::System.ArgumentNullException("MaGV");
1107 }
1108 else {
1109 this.Adapter.InsertCommand.Parameters[0].Value = ((string)(MaGV));
1110 }
1111 if ((TenGV == null)) {
1112 this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
1113 }
1114 else {
1115 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(TenGV));
1116 }
1117 if ((GioiTinh == null)) {
1118 this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
1119 }
1120 else {
1121 this.Adapter.InsertCommand.Parameters[2].Value = ((string)(GioiTinh));
1122 }
1123 if ((Phone == null)) {
1124 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
1125 }
1126 else {
1127 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Phone));
1128 }
1129 if ((Email == null)) {
1130 this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
1131 }
1132 else {
1133 this.Adapter.InsertCommand.Parameters[4].Value = ((string)(Email));
1134 }
1135 if ((PhanLoaiGV == null)) {
1136 this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
1137 }
1138 else {
1139 this.Adapter.InsertCommand.Parameters[5].Value = ((string)(PhanLoaiGV));
1140 }
1141 if ((Anh == null)) {
1142 this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
1143 }
1144 else {
1145 this.Adapter.InsertCommand.Parameters[6].Value = ((string)(Anh));
1146 }
1147 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
1148 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
1149 != global::System.Data.ConnectionState.Open)) {
1150 this.Adapter.InsertCommand.Connection.Open();
1151 }
1152 try {
1153 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
1154 return returnValue;
1155 }
1156 finally {
1157 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1158 this.Adapter.InsertCommand.Connection.Close();
1159 }
1160 }
1161 }
1162
1163 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1164 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1165 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
1166 public virtual int Update(string MaGV, string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh, string Original_MaGV, string Original_TenGV, string Original_GioiTinh, string Original_Phone, string Original_Email, string Original_PhanLoaiGV, string Original_Anh) {
1167 if ((MaGV == null)) {
1168 throw new global::System.ArgumentNullException("MaGV");
1169 }
1170 else {
1171 this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(MaGV));
1172 }
1173 if ((TenGV == null)) {
1174 this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
1175 }
1176 else {
1177 this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(TenGV));
1178 }
1179 if ((GioiTinh == null)) {
1180 this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
1181 }
1182 else {
1183 this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(GioiTinh));
1184 }
1185 if ((Phone == null)) {
1186 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
1187 }
1188 else {
1189 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(Phone));
1190 }
1191 if ((Email == null)) {
1192 this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
1193 }
1194 else {
1195 this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(Email));
1196 }
1197 if ((PhanLoaiGV == null)) {
1198 this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
1199 }
1200 else {
1201 this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(PhanLoaiGV));
1202 }
1203 if ((Anh == null)) {
1204 this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
1205 }
1206 else {
1207 this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(Anh));
1208 }
1209 if ((Original_MaGV == null)) {
1210 throw new global::System.ArgumentNullException("Original_MaGV");
1211 }
1212 else {
1213 this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(Original_MaGV));
1214 }
1215 if ((Original_TenGV == null)) {
1216 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(1));
1217 this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value;
1218 }
1219 else {
1220 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(0));
1221 this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(Original_TenGV));
1222 }
1223 if ((Original_GioiTinh == null)) {
1224 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(1));
1225 this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value;
1226 }
1227 else {
1228 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(0));
1229 this.Adapter.UpdateCommand.Parameters[11].Value = ((string)(Original_GioiTinh));
1230 }
1231 if ((Original_Phone == null)) {
1232 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(1));
1233 this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value;
1234 }
1235 else {
1236 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(0));
1237 this.Adapter.UpdateCommand.Parameters[13].Value = ((string)(Original_Phone));
1238 }
1239 if ((Original_Email == null)) {
1240 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(1));
1241 this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value;
1242 }
1243 else {
1244 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(0));
1245 this.Adapter.UpdateCommand.Parameters[15].Value = ((string)(Original_Email));
1246 }
1247 if ((Original_PhanLoaiGV == null)) {
1248 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(1));
1249 this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value;
1250 }
1251 else {
1252 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(0));
1253 this.Adapter.UpdateCommand.Parameters[17].Value = ((string)(Original_PhanLoaiGV));
1254 }
1255 if ((Original_Anh == null)) {
1256 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(1));
1257 this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value;
1258 }
1259 else {
1260 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(0));
1261 this.Adapter.UpdateCommand.Parameters[19].Value = ((string)(Original_Anh));
1262 }
1263 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
1264 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
1265 != global::System.Data.ConnectionState.Open)) {
1266 this.Adapter.UpdateCommand.Connection.Open();
1267 }
1268 try {
1269 int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
1270 return returnValue;
1271 }
1272 finally {
1273 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1274 this.Adapter.UpdateCommand.Connection.Close();
1275 }
1276 }
1277 }
1278
1279 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1280 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1281 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
1282 public virtual int Update(string TenGV, string GioiTinh, string Phone, string Email, string PhanLoaiGV, string Anh, string Original_MaGV, string Original_TenGV, string Original_GioiTinh, string Original_Phone, string Original_Email, string Original_PhanLoaiGV, string Original_Anh) {
1283 return this.Update(Original_MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh, Original_MaGV, Original_TenGV, Original_GioiTinh, Original_Phone, Original_Email, Original_PhanLoaiGV, Original_Anh);
1284 }
1285 }
1286
1287 /// <summary>
1288 ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
1289 ///</summary>
1290 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1291 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
1292 [global::System.ComponentModel.ToolboxItem(true)]
1293 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
1294 "esigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
1295 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
1296 public partial class TableAdapterManager : global::System.ComponentModel.Component {
1297
1298 private UpdateOrderOption _updateOrder;
1299
1300 private tblGIANG_VIENTableAdapter _tblGIANG_VIENTableAdapter;
1301
1302 private bool _backupDataSetBeforeUpdate;
1303
1304 private global::System.Data.IDbConnection _connection;
1305
1306 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1307 public UpdateOrderOption UpdateOrder {
1308 get {
1309 return this._updateOrder;
1310 }
1311 set {
1312 this._updateOrder = value;
1313 }
1314 }
1315
1316 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1317 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
1318 "ft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" +
1319 "", "System.Drawing.Design.UITypeEditor")]
1320 public tblGIANG_VIENTableAdapter tblGIANG_VIENTableAdapter {
1321 get {
1322 return this._tblGIANG_VIENTableAdapter;
1323 }
1324 set {
1325 this._tblGIANG_VIENTableAdapter = value;
1326 }
1327 }
1328
1329 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1330 public bool BackupDataSetBeforeUpdate {
1331 get {
1332 return this._backupDataSetBeforeUpdate;
1333 }
1334 set {
1335 this._backupDataSetBeforeUpdate = value;
1336 }
1337 }
1338
1339 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1340 [global::System.ComponentModel.Browsable(false)]
1341 public global::System.Data.IDbConnection Connection {
1342 get {
1343 if ((this._connection != null)) {
1344 return this._connection;
1345 }
1346 if (((this._tblGIANG_VIENTableAdapter != null)
1347 && (this._tblGIANG_VIENTableAdapter.Connection != null))) {
1348 return this._tblGIANG_VIENTableAdapter.Connection;
1349 }
1350 return null;
1351 }
1352 set {
1353 this._connection = value;
1354 }
1355 }
1356
1357 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1358 [global::System.ComponentModel.Browsable(false)]
1359 public int TableAdapterInstanceCount {
1360 get {
1361 int count = 0;
1362 if ((this._tblGIANG_VIENTableAdapter != null)) {
1363 count = (count + 1);
1364 }
1365 return count;
1366 }
1367 }
1368
1369 /// <summary>
1370 ///Update rows in top-down order.
1371 ///</summary>
1372 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1373 private int UpdateUpdatedRows(QuanlydiemDataSet21 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1374 int result = 0;
1375 if ((this._tblGIANG_VIENTableAdapter != null)) {
1376 global::System.Data.DataRow[] updatedRows = dataSet.tblGIANG_VIEN.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
1377 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
1378 if (((updatedRows != null)
1379 && (0 < updatedRows.Length))) {
1380 result = (result + this._tblGIANG_VIENTableAdapter.Update(updatedRows));
1381 allChangedRows.AddRange(updatedRows);
1382 }
1383 }
1384 return result;
1385 }
1386
1387 /// <summary>
1388 ///Insert rows in top-down order.
1389 ///</summary>
1390 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1391 private int UpdateInsertedRows(QuanlydiemDataSet21 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1392 int result = 0;
1393 if ((this._tblGIANG_VIENTableAdapter != null)) {
1394 global::System.Data.DataRow[] addedRows = dataSet.tblGIANG_VIEN.Select(null, null, global::System.Data.DataViewRowState.Added);
1395 if (((addedRows != null)
1396 && (0 < addedRows.Length))) {
1397 result = (result + this._tblGIANG_VIENTableAdapter.Update(addedRows));
1398 allAddedRows.AddRange(addedRows);
1399 }
1400 }
1401 return result;
1402 }
1403
1404 /// <summary>
1405 ///Delete rows in bottom-up order.
1406 ///</summary>
1407 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1408 private int UpdateDeletedRows(QuanlydiemDataSet21 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
1409 int result = 0;
1410 if ((this._tblGIANG_VIENTableAdapter != null)) {
1411 global::System.Data.DataRow[] deletedRows = dataSet.tblGIANG_VIEN.Select(null, null, global::System.Data.DataViewRowState.Deleted);
1412 if (((deletedRows != null)
1413 && (0 < deletedRows.Length))) {
1414 result = (result + this._tblGIANG_VIENTableAdapter.Update(deletedRows));
1415 allChangedRows.AddRange(deletedRows);
1416 }
1417 }
1418 return result;
1419 }
1420
1421 /// <summary>
1422 ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
1423 ///</summary>
1424 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1425 private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1426 if (((updatedRows == null)
1427 || (updatedRows.Length < 1))) {
1428 return updatedRows;
1429 }
1430 if (((allAddedRows == null)
1431 || (allAddedRows.Count < 1))) {
1432 return updatedRows;
1433 }
1434 global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1435 for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
1436 global::System.Data.DataRow row = updatedRows[i];
1437 if ((allAddedRows.Contains(row) == false)) {
1438 realUpdatedRows.Add(row);
1439 }
1440 }
1441 return realUpdatedRows.ToArray();
1442 }
1443
1444 /// <summary>
1445 ///Update all changes to the dataset.
1446 ///</summary>
1447 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1448 public virtual int UpdateAll(QuanlydiemDataSet21 dataSet) {
1449 if ((dataSet == null)) {
1450 throw new global::System.ArgumentNullException("dataSet");
1451 }
1452 if ((dataSet.HasChanges() == false)) {
1453 return 0;
1454 }
1455 if (((this._tblGIANG_VIENTableAdapter != null)
1456 && (this.MatchTableAdapterConnection(this._tblGIANG_VIENTableAdapter.Connection) == false))) {
1457 throw new global::System.ArgumentException("All TableAdapters managed by a TableAdapterManager must use the same connection s" +
1458 "tring.");
1459 }
1460 global::System.Data.IDbConnection workConnection = this.Connection;
1461 if ((workConnection == null)) {
1462 throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" +
1463 "ger TableAdapter property to a valid TableAdapter instance.");
1464 }
1465 bool workConnOpened = false;
1466 if (((workConnection.State & global::System.Data.ConnectionState.Broken)
1467 == global::System.Data.ConnectionState.Broken)) {
1468 workConnection.Close();
1469 }
1470 if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
1471 workConnection.Open();
1472 workConnOpened = true;
1473 }
1474 global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
1475 if ((workTransaction == null)) {
1476 throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" +
1477 "ctions or the current state is not allowing the transaction to begin.");
1478 }
1479 global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1480 global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1481 global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
1482 global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
1483 int result = 0;
1484 global::System.Data.DataSet backupDataSet = null;
1485 if (this.BackupDataSetBeforeUpdate) {
1486 backupDataSet = new global::System.Data.DataSet();
1487 backupDataSet.Merge(dataSet);
1488 }
1489 try {
1490 // ---- Prepare for update -----------
1491 //
1492 if ((this._tblGIANG_VIENTableAdapter != null)) {
1493 revertConnections.Add(this._tblGIANG_VIENTableAdapter, this._tblGIANG_VIENTableAdapter.Connection);
1494 this._tblGIANG_VIENTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
1495 this._tblGIANG_VIENTableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
1496 if (this._tblGIANG_VIENTableAdapter.Adapter.AcceptChangesDuringUpdate) {
1497 this._tblGIANG_VIENTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
1498 adaptersWithAcceptChangesDuringUpdate.Add(this._tblGIANG_VIENTableAdapter.Adapter);
1499 }
1500 }
1501 //
1502 //---- Perform updates -----------
1503 //
1504 if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
1505 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1506 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1507 }
1508 else {
1509 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1510 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1511 }
1512 result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
1513 //
1514 //---- Commit updates -----------
1515 //
1516 workTransaction.Commit();
1517 if ((0 < allAddedRows.Count)) {
1518 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1519 allAddedRows.CopyTo(rows);
1520 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1521 global::System.Data.DataRow row = rows[i];
1522 row.AcceptChanges();
1523 }
1524 }
1525 if ((0 < allChangedRows.Count)) {
1526 global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
1527 allChangedRows.CopyTo(rows);
1528 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1529 global::System.Data.DataRow row = rows[i];
1530 row.AcceptChanges();
1531 }
1532 }
1533 }
1534 catch (global::System.Exception ex) {
1535 workTransaction.Rollback();
1536 // ---- Restore the dataset -----------
1537 if (this.BackupDataSetBeforeUpdate) {
1538 global::System.Diagnostics.Debug.Assert((backupDataSet != null));
1539 dataSet.Clear();
1540 dataSet.Merge(backupDataSet);
1541 }
1542 else {
1543 if ((0 < allAddedRows.Count)) {
1544 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1545 allAddedRows.CopyTo(rows);
1546 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1547 global::System.Data.DataRow row = rows[i];
1548 row.AcceptChanges();
1549 row.SetAdded();
1550 }
1551 }
1552 }
1553 throw ex;
1554 }
1555 finally {
1556 if (workConnOpened) {
1557 workConnection.Close();
1558 }
1559 if ((this._tblGIANG_VIENTableAdapter != null)) {
1560 this._tblGIANG_VIENTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._tblGIANG_VIENTableAdapter]));
1561 this._tblGIANG_VIENTableAdapter.Transaction = null;
1562 }
1563 if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
1564 global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
1565 adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
1566 for (int i = 0; (i < adapters.Length); i = (i + 1)) {
1567 global::System.Data.Common.DataAdapter adapter = adapters[i];
1568 adapter.AcceptChangesDuringUpdate = true;
1569 }
1570 }
1571 }
1572 return result;
1573 }
1574
1575 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1576 protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
1577 global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
1578 }
1579
1580 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1581 protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
1582 if ((this._connection != null)) {
1583 return true;
1584 }
1585 if (((this.Connection == null)
1586 || (inputConnection == null))) {
1587 return true;
1588 }
1589 if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
1590 return true;
1591 }
1592 return false;
1593 }
1594
1595 /// <summary>
1596 ///Update Order Option
1597 ///</summary>
1598 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1599 public enum UpdateOrderOption {
1600
1601 InsertUpdateDelete = 0,
1602
1603 UpdateInsertDelete = 1,
1604 }
1605
1606 /// <summary>
1607 ///Used to sort self-referenced table's rows
1608 ///</summary>
1609 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
1610 private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
1611
1612 private global::System.Data.DataRelation _relation;
1613
1614 private int _childFirst;
1615
1616 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1617 internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
1618 this._relation = relation;
1619 if (childFirst) {
1620 this._childFirst = -1;
1621 }
1622 else {
1623 this._childFirst = 1;
1624 }
1625 }
1626
1627 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1628 private bool IsChildAndParent(global::System.Data.DataRow child, global::System.Data.DataRow parent) {
1629 global::System.Diagnostics.Debug.Assert((child != null));
1630 global::System.Diagnostics.Debug.Assert((parent != null));
1631 global::System.Data.DataRow newParent = child.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1632 for (
1633 ; ((newParent != null)
1634 && ((object.ReferenceEquals(newParent, child) == false)
1635 && (object.ReferenceEquals(newParent, parent) == false)));
1636 ) {
1637 newParent = newParent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1638 }
1639 if ((newParent == null)) {
1640 for (newParent = child.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original); ((newParent != null)
1641 && ((object.ReferenceEquals(newParent, child) == false)
1642 && (object.ReferenceEquals(newParent, parent) == false)));
1643 ) {
1644 newParent = newParent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
1645 }
1646 }
1647 if (object.ReferenceEquals(newParent, parent)) {
1648 return true;
1649 }
1650 return false;
1651 }
1652
1653 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1654 public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
1655 if (object.ReferenceEquals(row1, row2)) {
1656 return 0;
1657 }
1658 if ((row1 == null)) {
1659 return -1;
1660 }
1661 if ((row2 == null)) {
1662 return 1;
1663 }
1664
1665 // Is row1 the child or grandchild of row2
1666 if (this.IsChildAndParent(row1, row2)) {
1667 return this._childFirst;
1668 }
1669
1670 // Is row2 the child or grandchild of row1
1671 if (this.IsChildAndParent(row2, row1)) {
1672 return (-1 * this._childFirst);
1673 }
1674 return 0;
1675 }
1676 }
1677 }
1678 }
1679
1680 #pragma warning restore 1591