РП31ДьячковНикитинСтудентыDataSet.Designer.cs 71 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262
  1. //------------------------------------------------------------------------------
  2. // <auto-generated>
  3. // Этот код создан программой.
  4. // Исполняемая версия:4.0.30319.42000
  5. //
  6. // Изменения в этом файле могут привести к неправильной работе и будут потеряны в случае
  7. // повторной генерации кода.
  8. // </auto-generated>
  9. //------------------------------------------------------------------------------
  10. #pragma warning disable 1591
  11. namespace DiachkovStudents {
  12. /// <summary>
  13. ///Represents a strongly typed in-memory cache of data.
  14. ///</summary>
  15. [global::System.Serializable()]
  16. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  17. [global::System.ComponentModel.ToolboxItem(true)]
  18. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
  19. [global::System.Xml.Serialization.XmlRootAttribute("РП31ДьячковНикитинСтудентыDataSet")]
  20. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
  21. public partial class РП31ДьячковНикитинСтудентыDataSet : global::System.Data.DataSet {
  22. private СпециальностиDataTable tableСпециальности;
  23. private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  24. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  25. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  26. public РП31ДьячковНикитинСтудентыDataSet() {
  27. this.BeginInit();
  28. this.InitClass();
  29. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  30. base.Tables.CollectionChanged += schemaChangedHandler;
  31. base.Relations.CollectionChanged += schemaChangedHandler;
  32. this.EndInit();
  33. }
  34. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  35. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  36. protected РП31ДьячковНикитинСтудентыDataSet(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  37. base(info, context, false) {
  38. if ((this.IsBinarySerialized(info, context) == true)) {
  39. this.InitVars(false);
  40. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  41. this.Tables.CollectionChanged += schemaChangedHandler1;
  42. this.Relations.CollectionChanged += schemaChangedHandler1;
  43. return;
  44. }
  45. string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
  46. if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
  47. global::System.Data.DataSet ds = new global::System.Data.DataSet();
  48. ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
  49. if ((ds.Tables["Специальности"] != null)) {
  50. base.Tables.Add(new СпециальностиDataTable(ds.Tables["Специальности"]));
  51. }
  52. this.DataSetName = ds.DataSetName;
  53. this.Prefix = ds.Prefix;
  54. this.Namespace = ds.Namespace;
  55. this.Locale = ds.Locale;
  56. this.CaseSensitive = ds.CaseSensitive;
  57. this.EnforceConstraints = ds.EnforceConstraints;
  58. this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
  59. this.InitVars();
  60. }
  61. else {
  62. this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
  63. }
  64. this.GetSerializationData(info, context);
  65. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  66. base.Tables.CollectionChanged += schemaChangedHandler;
  67. this.Relations.CollectionChanged += schemaChangedHandler;
  68. }
  69. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  70. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  71. [global::System.ComponentModel.Browsable(false)]
  72. [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
  73. public СпециальностиDataTable Специальности {
  74. get {
  75. return this.tableСпециальности;
  76. }
  77. }
  78. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  79. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  80. [global::System.ComponentModel.BrowsableAttribute(true)]
  81. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
  82. public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
  83. get {
  84. return this._schemaSerializationMode;
  85. }
  86. set {
  87. this._schemaSerializationMode = value;
  88. }
  89. }
  90. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  91. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  92. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
  93. public new global::System.Data.DataTableCollection Tables {
  94. get {
  95. return base.Tables;
  96. }
  97. }
  98. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  99. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  100. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
  101. public new global::System.Data.DataRelationCollection Relations {
  102. get {
  103. return base.Relations;
  104. }
  105. }
  106. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  107. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  108. protected override void InitializeDerivedDataSet() {
  109. this.BeginInit();
  110. this.InitClass();
  111. this.EndInit();
  112. }
  113. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  114. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  115. public override global::System.Data.DataSet Clone() {
  116. РП31ДьячковНикитинСтудентыDataSet cln = ((РП31ДьячковНикитинСтудентыDataSet)(base.Clone()));
  117. cln.InitVars();
  118. cln.SchemaSerializationMode = this.SchemaSerializationMode;
  119. return cln;
  120. }
  121. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  122. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  123. protected override bool ShouldSerializeTables() {
  124. return false;
  125. }
  126. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  127. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  128. protected override bool ShouldSerializeRelations() {
  129. return false;
  130. }
  131. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  132. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  133. protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
  134. if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
  135. this.Reset();
  136. global::System.Data.DataSet ds = new global::System.Data.DataSet();
  137. ds.ReadXml(reader);
  138. if ((ds.Tables["Специальности"] != null)) {
  139. base.Tables.Add(new СпециальностиDataTable(ds.Tables["Специальности"]));
  140. }
  141. this.DataSetName = ds.DataSetName;
  142. this.Prefix = ds.Prefix;
  143. this.Namespace = ds.Namespace;
  144. this.Locale = ds.Locale;
  145. this.CaseSensitive = ds.CaseSensitive;
  146. this.EnforceConstraints = ds.EnforceConstraints;
  147. this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
  148. this.InitVars();
  149. }
  150. else {
  151. this.ReadXml(reader);
  152. this.InitVars();
  153. }
  154. }
  155. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  156. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  157. protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
  158. global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
  159. this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
  160. stream.Position = 0;
  161. return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
  162. }
  163. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  164. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  165. internal void InitVars() {
  166. this.InitVars(true);
  167. }
  168. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  169. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  170. internal void InitVars(bool initTable) {
  171. this.tableСпециальности = ((СпециальностиDataTable)(base.Tables["Специальности"]));
  172. if ((initTable == true)) {
  173. if ((this.tableСпециальности != null)) {
  174. this.tableСпециальности.InitVars();
  175. }
  176. }
  177. }
  178. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  179. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  180. private void InitClass() {
  181. this.DataSetName = "РП31ДьячковНикитинСтудентыDataSet";
  182. this.Prefix = "";
  183. this.Namespace = "http://tempuri.org/РП31ДьячковНикитинСтудентыDataSet.xsd";
  184. this.EnforceConstraints = true;
  185. this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  186. this.tableСпециальности = new СпециальностиDataTable();
  187. base.Tables.Add(this.tableСпециальности);
  188. }
  189. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  190. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  191. private bool ShouldSerializeСпециальности() {
  192. return false;
  193. }
  194. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  195. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  196. private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
  197. if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
  198. this.InitVars();
  199. }
  200. }
  201. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  202. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  203. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  204. РП31ДьячковНикитинСтудентыDataSet ds = new РП31ДьячковНикитинСтудентыDataSet();
  205. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  206. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  207. global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
  208. any.Namespace = ds.Namespace;
  209. sequence.Items.Add(any);
  210. type.Particle = sequence;
  211. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  212. if (xs.Contains(dsSchema.TargetNamespace)) {
  213. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  214. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  215. try {
  216. global::System.Xml.Schema.XmlSchema schema = null;
  217. dsSchema.Write(s1);
  218. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  219. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  220. s2.SetLength(0);
  221. schema.Write(s2);
  222. if ((s1.Length == s2.Length)) {
  223. s1.Position = 0;
  224. s2.Position = 0;
  225. for (; ((s1.Position != s1.Length)
  226. && (s1.ReadByte() == s2.ReadByte())); ) {
  227. ;
  228. }
  229. if ((s1.Position == s1.Length)) {
  230. return type;
  231. }
  232. }
  233. }
  234. }
  235. finally {
  236. if ((s1 != null)) {
  237. s1.Close();
  238. }
  239. if ((s2 != null)) {
  240. s2.Close();
  241. }
  242. }
  243. }
  244. xs.Add(dsSchema);
  245. return type;
  246. }
  247. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  248. public delegate void СпециальностиRowChangeEventHandler(object sender, СпециальностиRowChangeEvent e);
  249. /// <summary>
  250. ///Represents the strongly named DataTable class.
  251. ///</summary>
  252. [global::System.Serializable()]
  253. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
  254. public partial class СпециальностиDataTable : global::System.Data.TypedTableBase<СпециальностиRow> {
  255. private global::System.Data.DataColumn columnНаименованиеСпециальности;
  256. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  257. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  258. public СпециальностиDataTable() {
  259. this.TableName = "Специальности";
  260. this.BeginInit();
  261. this.InitClass();
  262. this.EndInit();
  263. }
  264. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  265. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  266. internal СпециальностиDataTable(global::System.Data.DataTable table) {
  267. this.TableName = table.TableName;
  268. if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
  269. this.CaseSensitive = table.CaseSensitive;
  270. }
  271. if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
  272. this.Locale = table.Locale;
  273. }
  274. if ((table.Namespace != table.DataSet.Namespace)) {
  275. this.Namespace = table.Namespace;
  276. }
  277. this.Prefix = table.Prefix;
  278. this.MinimumCapacity = table.MinimumCapacity;
  279. }
  280. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  281. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  282. protected СпециальностиDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  283. base(info, context) {
  284. this.InitVars();
  285. }
  286. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  287. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  288. public global::System.Data.DataColumn НаименованиеСпециальностиColumn {
  289. get {
  290. return this.columnНаименованиеСпециальности;
  291. }
  292. }
  293. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  294. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  295. [global::System.ComponentModel.Browsable(false)]
  296. public int Count {
  297. get {
  298. return this.Rows.Count;
  299. }
  300. }
  301. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  302. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  303. public СпециальностиRow this[int index] {
  304. get {
  305. return ((СпециальностиRow)(this.Rows[index]));
  306. }
  307. }
  308. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  309. public event СпециальностиRowChangeEventHandler СпециальностиRowChanging;
  310. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  311. public event СпециальностиRowChangeEventHandler СпециальностиRowChanged;
  312. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  313. public event СпециальностиRowChangeEventHandler СпециальностиRowDeleting;
  314. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  315. public event СпециальностиRowChangeEventHandler СпециальностиRowDeleted;
  316. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  317. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  318. public void AddСпециальностиRow(СпециальностиRow row) {
  319. this.Rows.Add(row);
  320. }
  321. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  322. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  323. public СпециальностиRow AddСпециальностиRow(string НаименованиеСпециальности) {
  324. СпециальностиRow rowСпециальностиRow = ((СпециальностиRow)(this.NewRow()));
  325. object[] columnValuesArray = new object[] {
  326. НаименованиеСпециальности};
  327. rowСпециальностиRow.ItemArray = columnValuesArray;
  328. this.Rows.Add(rowСпециальностиRow);
  329. return rowСпециальностиRow;
  330. }
  331. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  332. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  333. public override global::System.Data.DataTable Clone() {
  334. СпециальностиDataTable cln = ((СпециальностиDataTable)(base.Clone()));
  335. cln.InitVars();
  336. return cln;
  337. }
  338. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  339. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  340. protected override global::System.Data.DataTable CreateInstance() {
  341. return new СпециальностиDataTable();
  342. }
  343. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  344. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  345. internal void InitVars() {
  346. this.columnНаименованиеСпециальности = base.Columns["НаименованиеСпециальности"];
  347. }
  348. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  349. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  350. private void InitClass() {
  351. this.columnНаименованиеСпециальности = new global::System.Data.DataColumn("НаименованиеСпециальности", typeof(string), null, global::System.Data.MappingType.Element);
  352. base.Columns.Add(this.columnНаименованиеСпециальности);
  353. this.columnНаименованиеСпециальности.MaxLength = 50;
  354. }
  355. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  356. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  357. public СпециальностиRow NewСпециальностиRow() {
  358. return ((СпециальностиRow)(this.NewRow()));
  359. }
  360. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  361. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  362. protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
  363. return new СпециальностиRow(builder);
  364. }
  365. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  366. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  367. protected override global::System.Type GetRowType() {
  368. return typeof(СпециальностиRow);
  369. }
  370. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  371. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  372. protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
  373. base.OnRowChanged(e);
  374. if ((this.СпециальностиRowChanged != null)) {
  375. this.СпециальностиRowChanged(this, new СпециальностиRowChangeEvent(((СпециальностиRow)(e.Row)), e.Action));
  376. }
  377. }
  378. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  379. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  380. protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
  381. base.OnRowChanging(e);
  382. if ((this.СпециальностиRowChanging != null)) {
  383. this.СпециальностиRowChanging(this, new СпециальностиRowChangeEvent(((СпециальностиRow)(e.Row)), e.Action));
  384. }
  385. }
  386. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  387. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  388. protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
  389. base.OnRowDeleted(e);
  390. if ((this.СпециальностиRowDeleted != null)) {
  391. this.СпециальностиRowDeleted(this, new СпециальностиRowChangeEvent(((СпециальностиRow)(e.Row)), e.Action));
  392. }
  393. }
  394. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  395. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  396. protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
  397. base.OnRowDeleting(e);
  398. if ((this.СпециальностиRowDeleting != null)) {
  399. this.СпециальностиRowDeleting(this, new СпециальностиRowChangeEvent(((СпециальностиRow)(e.Row)), e.Action));
  400. }
  401. }
  402. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  403. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  404. public void RemoveСпециальностиRow(СпециальностиRow row) {
  405. this.Rows.Remove(row);
  406. }
  407. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  408. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  409. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  410. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  411. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  412. РП31ДьячковНикитинСтудентыDataSet ds = new РП31ДьячковНикитинСтудентыDataSet();
  413. global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
  414. any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  415. any1.MinOccurs = new decimal(0);
  416. any1.MaxOccurs = decimal.MaxValue;
  417. any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  418. sequence.Items.Add(any1);
  419. global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
  420. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  421. any2.MinOccurs = new decimal(1);
  422. any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  423. sequence.Items.Add(any2);
  424. global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
  425. attribute1.Name = "namespace";
  426. attribute1.FixedValue = ds.Namespace;
  427. type.Attributes.Add(attribute1);
  428. global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
  429. attribute2.Name = "tableTypeName";
  430. attribute2.FixedValue = "СпециальностиDataTable";
  431. type.Attributes.Add(attribute2);
  432. type.Particle = sequence;
  433. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  434. if (xs.Contains(dsSchema.TargetNamespace)) {
  435. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  436. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  437. try {
  438. global::System.Xml.Schema.XmlSchema schema = null;
  439. dsSchema.Write(s1);
  440. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  441. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  442. s2.SetLength(0);
  443. schema.Write(s2);
  444. if ((s1.Length == s2.Length)) {
  445. s1.Position = 0;
  446. s2.Position = 0;
  447. for (; ((s1.Position != s1.Length)
  448. && (s1.ReadByte() == s2.ReadByte())); ) {
  449. ;
  450. }
  451. if ((s1.Position == s1.Length)) {
  452. return type;
  453. }
  454. }
  455. }
  456. }
  457. finally {
  458. if ((s1 != null)) {
  459. s1.Close();
  460. }
  461. if ((s2 != null)) {
  462. s2.Close();
  463. }
  464. }
  465. }
  466. xs.Add(dsSchema);
  467. return type;
  468. }
  469. }
  470. /// <summary>
  471. ///Represents strongly named DataRow class.
  472. ///</summary>
  473. public partial class СпециальностиRow : global::System.Data.DataRow {
  474. private СпециальностиDataTable tableСпециальности;
  475. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  476. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  477. internal СпециальностиRow(global::System.Data.DataRowBuilder rb) :
  478. base(rb) {
  479. this.tableСпециальности = ((СпециальностиDataTable)(this.Table));
  480. }
  481. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  482. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  483. public string НаименованиеСпециальности {
  484. get {
  485. try {
  486. return ((string)(this[this.tableСпециальности.НаименованиеСпециальностиColumn]));
  487. }
  488. catch (global::System.InvalidCastException e) {
  489. throw new global::System.Data.StrongTypingException("Значение для столбца \'НаименованиеСпециальности\' в таблице \'Специальности\' равно " +
  490. "DBNull.", e);
  491. }
  492. }
  493. set {
  494. this[this.tableСпециальности.НаименованиеСпециальностиColumn] = value;
  495. }
  496. }
  497. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  498. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  499. public bool IsНаименованиеСпециальностиNull() {
  500. return this.IsNull(this.tableСпециальности.НаименованиеСпециальностиColumn);
  501. }
  502. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  503. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  504. public void SetНаименованиеСпециальностиNull() {
  505. this[this.tableСпециальности.НаименованиеСпециальностиColumn] = global::System.Convert.DBNull;
  506. }
  507. }
  508. /// <summary>
  509. ///Row event argument class
  510. ///</summary>
  511. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  512. public class СпециальностиRowChangeEvent : global::System.EventArgs {
  513. private СпециальностиRow eventRow;
  514. private global::System.Data.DataRowAction eventAction;
  515. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  516. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  517. public СпециальностиRowChangeEvent(СпециальностиRow row, global::System.Data.DataRowAction action) {
  518. this.eventRow = row;
  519. this.eventAction = action;
  520. }
  521. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  522. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  523. public СпециальностиRow Row {
  524. get {
  525. return this.eventRow;
  526. }
  527. }
  528. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  529. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  530. public global::System.Data.DataRowAction Action {
  531. get {
  532. return this.eventAction;
  533. }
  534. }
  535. }
  536. }
  537. }
  538. namespace DiachkovStudents.РП31ДьячковНикитинСтудентыDataSetTableAdapters {
  539. /// <summary>
  540. ///Represents the connection and commands used to retrieve and save data.
  541. ///</summary>
  542. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  543. [global::System.ComponentModel.ToolboxItem(true)]
  544. [global::System.ComponentModel.DataObjectAttribute(true)]
  545. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  546. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  547. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  548. public partial class СпециальностиTableAdapter : global::System.ComponentModel.Component {
  549. private global::System.Data.SqlClient.SqlDataAdapter _adapter;
  550. private global::System.Data.SqlClient.SqlConnection _connection;
  551. private global::System.Data.SqlClient.SqlTransaction _transaction;
  552. private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
  553. private bool _clearBeforeFill;
  554. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  555. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  556. public СпециальностиTableAdapter() {
  557. this.ClearBeforeFill = true;
  558. }
  559. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  560. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  561. protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
  562. get {
  563. if ((this._adapter == null)) {
  564. this.InitAdapter();
  565. }
  566. return this._adapter;
  567. }
  568. }
  569. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  570. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  571. internal global::System.Data.SqlClient.SqlConnection Connection {
  572. get {
  573. if ((this._connection == null)) {
  574. this.InitConnection();
  575. }
  576. return this._connection;
  577. }
  578. set {
  579. this._connection = value;
  580. if ((this.Adapter.InsertCommand != null)) {
  581. this.Adapter.InsertCommand.Connection = value;
  582. }
  583. if ((this.Adapter.DeleteCommand != null)) {
  584. this.Adapter.DeleteCommand.Connection = value;
  585. }
  586. if ((this.Adapter.UpdateCommand != null)) {
  587. this.Adapter.UpdateCommand.Connection = value;
  588. }
  589. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  590. if ((this.CommandCollection[i] != null)) {
  591. ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  592. }
  593. }
  594. }
  595. }
  596. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  597. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  598. internal global::System.Data.SqlClient.SqlTransaction Transaction {
  599. get {
  600. return this._transaction;
  601. }
  602. set {
  603. this._transaction = value;
  604. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  605. this.CommandCollection[i].Transaction = this._transaction;
  606. }
  607. if (((this.Adapter != null)
  608. && (this.Adapter.DeleteCommand != null))) {
  609. this.Adapter.DeleteCommand.Transaction = this._transaction;
  610. }
  611. if (((this.Adapter != null)
  612. && (this.Adapter.InsertCommand != null))) {
  613. this.Adapter.InsertCommand.Transaction = this._transaction;
  614. }
  615. if (((this.Adapter != null)
  616. && (this.Adapter.UpdateCommand != null))) {
  617. this.Adapter.UpdateCommand.Transaction = this._transaction;
  618. }
  619. }
  620. }
  621. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  622. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  623. protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
  624. get {
  625. if ((this._commandCollection == null)) {
  626. this.InitCommandCollection();
  627. }
  628. return this._commandCollection;
  629. }
  630. }
  631. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  632. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  633. public bool ClearBeforeFill {
  634. get {
  635. return this._clearBeforeFill;
  636. }
  637. set {
  638. this._clearBeforeFill = value;
  639. }
  640. }
  641. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  642. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  643. private void InitAdapter() {
  644. this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
  645. global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
  646. tableMapping.SourceTable = "Table";
  647. tableMapping.DataSetTable = "Специальности";
  648. tableMapping.ColumnMappings.Add("НаименованиеСпециальности", "НаименованиеСпециальности");
  649. this._adapter.TableMappings.Add(tableMapping);
  650. this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
  651. this._adapter.InsertCommand.Connection = this.Connection;
  652. this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[Специальности] ([НаименованиеСпециальности]) VALUES (@Наименов" +
  653. "аниеСпециальности)";
  654. this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
  655. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@НаименованиеСпециальности", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "НаименованиеСпециальности", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  656. }
  657. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  658. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  659. private void InitConnection() {
  660. this._connection = new global::System.Data.SqlClient.SqlConnection();
  661. this._connection.ConnectionString = global::DiachkovStudents.Properties.Settings.Default.РП31ДьячковНикитинСтудентыConnectionString;
  662. }
  663. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  664. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  665. private void InitCommandCollection() {
  666. this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
  667. this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
  668. this._commandCollection[0].Connection = this.Connection;
  669. this._commandCollection[0].CommandText = "SELECT НаименованиеСпециальности FROM dbo.Специальности";
  670. this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
  671. }
  672. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  673. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  674. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  675. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
  676. public virtual int Fill(РП31ДьячковНикитинСтудентыDataSet.СпециальностиDataTable dataTable) {
  677. this.Adapter.SelectCommand = this.CommandCollection[0];
  678. if ((this.ClearBeforeFill == true)) {
  679. dataTable.Clear();
  680. }
  681. int returnValue = this.Adapter.Fill(dataTable);
  682. return returnValue;
  683. }
  684. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  685. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  686. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  687. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
  688. public virtual РП31ДьячковНикитинСтудентыDataSet.СпециальностиDataTable GetData() {
  689. this.Adapter.SelectCommand = this.CommandCollection[0];
  690. РП31ДьячковНикитинСтудентыDataSet.СпециальностиDataTable dataTable = new РП31ДьячковНикитинСтудентыDataSet.СпециальностиDataTable();
  691. this.Adapter.Fill(dataTable);
  692. return dataTable;
  693. }
  694. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  695. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  696. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  697. public virtual int Update(РП31ДьячковНикитинСтудентыDataSet.СпециальностиDataTable dataTable) {
  698. return this.Adapter.Update(dataTable);
  699. }
  700. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  701. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  702. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  703. public virtual int Update(РП31ДьячковНикитинСтудентыDataSet dataSet) {
  704. return this.Adapter.Update(dataSet, "Специальности");
  705. }
  706. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  707. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  708. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  709. public virtual int Update(global::System.Data.DataRow dataRow) {
  710. return this.Adapter.Update(new global::System.Data.DataRow[] {
  711. dataRow});
  712. }
  713. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  714. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  715. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  716. public virtual int Update(global::System.Data.DataRow[] dataRows) {
  717. return this.Adapter.Update(dataRows);
  718. }
  719. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  720. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  721. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  722. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
  723. public virtual int Insert(string НаименованиеСпециальности) {
  724. if ((НаименованиеСпециальности == null)) {
  725. this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
  726. }
  727. else {
  728. this.Adapter.InsertCommand.Parameters[0].Value = ((string)(НаименованиеСпециальности));
  729. }
  730. global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
  731. if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
  732. != global::System.Data.ConnectionState.Open)) {
  733. this.Adapter.InsertCommand.Connection.Open();
  734. }
  735. try {
  736. int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
  737. return returnValue;
  738. }
  739. finally {
  740. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  741. this.Adapter.InsertCommand.Connection.Close();
  742. }
  743. }
  744. }
  745. }
  746. /// <summary>
  747. ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
  748. ///</summary>
  749. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  750. [global::System.ComponentModel.ToolboxItem(true)]
  751. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
  752. "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  753. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
  754. public partial class TableAdapterManager : global::System.ComponentModel.Component {
  755. private UpdateOrderOption _updateOrder;
  756. private СпециальностиTableAdapter _специальностиTableAdapter;
  757. private bool _backupDataSetBeforeUpdate;
  758. private global::System.Data.IDbConnection _connection;
  759. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  760. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  761. public UpdateOrderOption UpdateOrder {
  762. get {
  763. return this._updateOrder;
  764. }
  765. set {
  766. this._updateOrder = value;
  767. }
  768. }
  769. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  770. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  771. [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
  772. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
  773. "a", "System.Drawing.Design.UITypeEditor")]
  774. public СпециальностиTableAdapter СпециальностиTableAdapter {
  775. get {
  776. return this._специальностиTableAdapter;
  777. }
  778. set {
  779. this._специальностиTableAdapter = value;
  780. }
  781. }
  782. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  783. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  784. public bool BackupDataSetBeforeUpdate {
  785. get {
  786. return this._backupDataSetBeforeUpdate;
  787. }
  788. set {
  789. this._backupDataSetBeforeUpdate = value;
  790. }
  791. }
  792. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  793. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  794. [global::System.ComponentModel.Browsable(false)]
  795. public global::System.Data.IDbConnection Connection {
  796. get {
  797. if ((this._connection != null)) {
  798. return this._connection;
  799. }
  800. if (((this._специальностиTableAdapter != null)
  801. && (this._специальностиTableAdapter.Connection != null))) {
  802. return this._специальностиTableAdapter.Connection;
  803. }
  804. return null;
  805. }
  806. set {
  807. this._connection = value;
  808. }
  809. }
  810. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  811. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  812. [global::System.ComponentModel.Browsable(false)]
  813. public int TableAdapterInstanceCount {
  814. get {
  815. int count = 0;
  816. if ((this._специальностиTableAdapter != null)) {
  817. count = (count + 1);
  818. }
  819. return count;
  820. }
  821. }
  822. /// <summary>
  823. ///Update rows in top-down order.
  824. ///</summary>
  825. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  826. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  827. private int UpdateUpdatedRows(РП31ДьячковНикитинСтудентыDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  828. int result = 0;
  829. if ((this._специальностиTableAdapter != null)) {
  830. global::System.Data.DataRow[] updatedRows = dataSet.Специальности.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
  831. updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
  832. if (((updatedRows != null)
  833. && (0 < updatedRows.Length))) {
  834. result = (result + this._специальностиTableAdapter.Update(updatedRows));
  835. allChangedRows.AddRange(updatedRows);
  836. }
  837. }
  838. return result;
  839. }
  840. /// <summary>
  841. ///Insert rows in top-down order.
  842. ///</summary>
  843. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  844. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  845. private int UpdateInsertedRows(РП31ДьячковНикитинСтудентыDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  846. int result = 0;
  847. if ((this._специальностиTableAdapter != null)) {
  848. global::System.Data.DataRow[] addedRows = dataSet.Специальности.Select(null, null, global::System.Data.DataViewRowState.Added);
  849. if (((addedRows != null)
  850. && (0 < addedRows.Length))) {
  851. result = (result + this._специальностиTableAdapter.Update(addedRows));
  852. allAddedRows.AddRange(addedRows);
  853. }
  854. }
  855. return result;
  856. }
  857. /// <summary>
  858. ///Delete rows in bottom-up order.
  859. ///</summary>
  860. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  861. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  862. private int UpdateDeletedRows(РП31ДьячковНикитинСтудентыDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
  863. int result = 0;
  864. if ((this._специальностиTableAdapter != null)) {
  865. global::System.Data.DataRow[] deletedRows = dataSet.Специальности.Select(null, null, global::System.Data.DataViewRowState.Deleted);
  866. if (((deletedRows != null)
  867. && (0 < deletedRows.Length))) {
  868. result = (result + this._специальностиTableAdapter.Update(deletedRows));
  869. allChangedRows.AddRange(deletedRows);
  870. }
  871. }
  872. return result;
  873. }
  874. /// <summary>
  875. ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
  876. ///</summary>
  877. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  878. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  879. private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  880. if (((updatedRows == null)
  881. || (updatedRows.Length < 1))) {
  882. return updatedRows;
  883. }
  884. if (((allAddedRows == null)
  885. || (allAddedRows.Count < 1))) {
  886. return updatedRows;
  887. }
  888. global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  889. for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
  890. global::System.Data.DataRow row = updatedRows[i];
  891. if ((allAddedRows.Contains(row) == false)) {
  892. realUpdatedRows.Add(row);
  893. }
  894. }
  895. return realUpdatedRows.ToArray();
  896. }
  897. /// <summary>
  898. ///Update all changes to the dataset.
  899. ///</summary>
  900. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  901. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  902. public virtual int UpdateAll(РП31ДьячковНикитинСтудентыDataSet dataSet) {
  903. if ((dataSet == null)) {
  904. throw new global::System.ArgumentNullException("dataSet");
  905. }
  906. if ((dataSet.HasChanges() == false)) {
  907. return 0;
  908. }
  909. if (((this._специальностиTableAdapter != null)
  910. && (this.MatchTableAdapterConnection(this._специальностиTableAdapter.Connection) == false))) {
  911. throw new global::System.ArgumentException("Все адаптеры таблицы, управляемые диспетчером адаптера таблицы TableAdapterManage" +
  912. "r, должны использовать одинаковую строку подключения.");
  913. }
  914. global::System.Data.IDbConnection workConnection = this.Connection;
  915. if ((workConnection == null)) {
  916. throw new global::System.ApplicationException("TableAdapterManager не содержит сведений о подключении. Укажите для каждого адапт" +
  917. "ера таблицы TableAdapterManager допустимый экземпляр адаптера таблицы.");
  918. }
  919. bool workConnOpened = false;
  920. if (((workConnection.State & global::System.Data.ConnectionState.Broken)
  921. == global::System.Data.ConnectionState.Broken)) {
  922. workConnection.Close();
  923. }
  924. if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
  925. workConnection.Open();
  926. workConnOpened = true;
  927. }
  928. global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
  929. if ((workTransaction == null)) {
  930. throw new global::System.ApplicationException("Не удается начать транзакцию. Текущее соединение данных не поддерживает транзакци" +
  931. "и или текущее состояние не позволяет начать транзакцию.");
  932. }
  933. global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  934. global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  935. global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
  936. global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
  937. int result = 0;
  938. global::System.Data.DataSet backupDataSet = null;
  939. if (this.BackupDataSetBeforeUpdate) {
  940. backupDataSet = new global::System.Data.DataSet();
  941. backupDataSet.Merge(dataSet);
  942. }
  943. try {
  944. // ---- Prepare for update -----------
  945. //
  946. if ((this._специальностиTableAdapter != null)) {
  947. revertConnections.Add(this._специальностиTableAdapter, this._специальностиTableAdapter.Connection);
  948. this._специальностиTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
  949. this._специальностиTableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
  950. if (this._специальностиTableAdapter.Adapter.AcceptChangesDuringUpdate) {
  951. this._специальностиTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
  952. adaptersWithAcceptChangesDuringUpdate.Add(this._специальностиTableAdapter.Adapter);
  953. }
  954. }
  955. //
  956. //---- Perform updates -----------
  957. //
  958. if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
  959. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  960. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  961. }
  962. else {
  963. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  964. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  965. }
  966. result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
  967. //
  968. //---- Commit updates -----------
  969. //
  970. workTransaction.Commit();
  971. if ((0 < allAddedRows.Count)) {
  972. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  973. allAddedRows.CopyTo(rows);
  974. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  975. global::System.Data.DataRow row = rows[i];
  976. row.AcceptChanges();
  977. }
  978. }
  979. if ((0 < allChangedRows.Count)) {
  980. global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
  981. allChangedRows.CopyTo(rows);
  982. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  983. global::System.Data.DataRow row = rows[i];
  984. row.AcceptChanges();
  985. }
  986. }
  987. }
  988. catch (global::System.Exception ex) {
  989. workTransaction.Rollback();
  990. // ---- Restore the dataset -----------
  991. if (this.BackupDataSetBeforeUpdate) {
  992. global::System.Diagnostics.Debug.Assert((backupDataSet != null));
  993. dataSet.Clear();
  994. dataSet.Merge(backupDataSet);
  995. }
  996. else {
  997. if ((0 < allAddedRows.Count)) {
  998. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  999. allAddedRows.CopyTo(rows);
  1000. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1001. global::System.Data.DataRow row = rows[i];
  1002. row.AcceptChanges();
  1003. row.SetAdded();
  1004. }
  1005. }
  1006. }
  1007. throw ex;
  1008. }
  1009. finally {
  1010. if (workConnOpened) {
  1011. workConnection.Close();
  1012. }
  1013. if ((this._специальностиTableAdapter != null)) {
  1014. this._специальностиTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._специальностиTableAdapter]));
  1015. this._специальностиTableAdapter.Transaction = null;
  1016. }
  1017. if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
  1018. global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
  1019. adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
  1020. for (int i = 0; (i < adapters.Length); i = (i + 1)) {
  1021. global::System.Data.Common.DataAdapter adapter = adapters[i];
  1022. adapter.AcceptChangesDuringUpdate = true;
  1023. }
  1024. }
  1025. }
  1026. return result;
  1027. }
  1028. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1029. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1030. protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
  1031. global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
  1032. }
  1033. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1034. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1035. protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
  1036. if ((this._connection != null)) {
  1037. return true;
  1038. }
  1039. if (((this.Connection == null)
  1040. || (inputConnection == null))) {
  1041. return true;
  1042. }
  1043. if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
  1044. return true;
  1045. }
  1046. return false;
  1047. }
  1048. /// <summary>
  1049. ///Update Order Option
  1050. ///</summary>
  1051. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1052. public enum UpdateOrderOption {
  1053. InsertUpdateDelete = 0,
  1054. UpdateInsertDelete = 1,
  1055. }
  1056. /// <summary>
  1057. ///Used to sort self-referenced table's rows
  1058. ///</summary>
  1059. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1060. private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
  1061. private global::System.Data.DataRelation _relation;
  1062. private int _childFirst;
  1063. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1064. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1065. internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
  1066. this._relation = relation;
  1067. if (childFirst) {
  1068. this._childFirst = -1;
  1069. }
  1070. else {
  1071. this._childFirst = 1;
  1072. }
  1073. }
  1074. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1075. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1076. private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
  1077. global::System.Diagnostics.Debug.Assert((row != null));
  1078. global::System.Data.DataRow root = row;
  1079. distance = 0;
  1080. global::System.Collections.Generic.IDictionary<global::System.Data.DataRow, global::System.Data.DataRow> traversedRows = new global::System.Collections.Generic.Dictionary<global::System.Data.DataRow, global::System.Data.DataRow>();
  1081. traversedRows[row] = row;
  1082. global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1083. for (
  1084. ; ((parent != null)
  1085. && (traversedRows.ContainsKey(parent) == false));
  1086. ) {
  1087. distance = (distance + 1);
  1088. root = parent;
  1089. traversedRows[parent] = parent;
  1090. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1091. }
  1092. if ((distance == 0)) {
  1093. traversedRows.Clear();
  1094. traversedRows[row] = row;
  1095. parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1096. for (
  1097. ; ((parent != null)
  1098. && (traversedRows.ContainsKey(parent) == false));
  1099. ) {
  1100. distance = (distance + 1);
  1101. root = parent;
  1102. traversedRows[parent] = parent;
  1103. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1104. }
  1105. }
  1106. return root;
  1107. }
  1108. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1109. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1110. public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
  1111. if (object.ReferenceEquals(row1, row2)) {
  1112. return 0;
  1113. }
  1114. if ((row1 == null)) {
  1115. return -1;
  1116. }
  1117. if ((row2 == null)) {
  1118. return 1;
  1119. }
  1120. int distance1 = 0;
  1121. global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
  1122. int distance2 = 0;
  1123. global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
  1124. if (object.ReferenceEquals(root1, root2)) {
  1125. return (this._childFirst * distance1.CompareTo(distance2));
  1126. }
  1127. else {
  1128. global::System.Diagnostics.Debug.Assert(((root1.Table != null)
  1129. && (root2.Table != null)));
  1130. if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
  1131. return -1;
  1132. }
  1133. else {
  1134. return 1;
  1135. }
  1136. }
  1137. }
  1138. }
  1139. }
  1140. }
  1141. #pragma warning restore 1591