Form6.cs 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. namespace WindowsFormsApp12
  11. {
  12. public partial class Form6 : Form
  13. {
  14. public Form6()
  15. {
  16. InitializeComponent();
  17. }
  18. private void студентыBindingNavigatorSaveItem_Click(object sender, EventArgs e)
  19. {
  20. this.Validate();
  21. this.студентыBindingSource.EndEdit();
  22. this.tableAdapterManager.UpdateAll(this.iS32KudroStudDataSet);
  23. }
  24. private void Form6_Load(object sender, EventArgs e)
  25. {
  26. // TODO: данная строка кода позволяет загрузить данные в таблицу "iS32KudroStudDataSet.Студенты". При необходимости она может быть перемещена или удалена.
  27. this.студентыTableAdapter.Fill(this.iS32KudroStudDataSet.Студенты);
  28. }
  29. private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
  30. {
  31. button1.Enabled = true;
  32. }
  33. private void button1_Click(object sender, EventArgs e)
  34. {
  35. DataGridViewColumn Col = null;
  36. switch (listBox1.SelectedIndex)
  37. {
  38. case 0:
  39. Col = dataGridViewTextBoxColumn2;
  40. break;
  41. case 1:
  42. Col = dataGridViewTextBoxColumn3;
  43. break;
  44. case 2:
  45. Col = dataGridViewTextBoxColumn4;
  46. break;
  47. case 3:
  48. Col = dataGridViewTextBoxColumn5;
  49. break;
  50. case 4:
  51. Col = dataGridViewTextBoxColumn6;
  52. break;
  53. case 5:
  54. Col = dataGridViewTextBoxColumn7;
  55. break;
  56. case 6:
  57. Col = dataGridViewTextBoxColumn8;
  58. break;
  59. case 7:
  60. Col = dataGridViewTextBoxColumn9;
  61. break;
  62. case 8:
  63. Col = dataGridViewTextBoxColumn10;
  64. break;
  65. case 9:
  66. Col = dataGridViewTextBoxColumn11;
  67. break;
  68. case 10:
  69. Col = dataGridViewTextBoxColumn12;
  70. break;
  71. //case 11: Col = dataGridViewTextBoxColumn1;// break;
  72. }
  73. if (radioButton1.Checked)
  74. студентыDataGridView.Sort(Col, ListSortDirection.Ascending);
  75. else
  76. студентыDataGridView.Sort(Col, ListSortDirection.Descending);
  77. }
  78. private void button2_Click(object sender, EventArgs e)
  79. {
  80. студентыBindingSource.Filter = "ФИО = '" + comboBox1.Text + "'";
  81. }
  82. private void button3_Click(object sender, EventArgs e)
  83. {
  84. студентыBindingSource.Filter = "";
  85. }
  86. private void button4_Click(object sender, EventArgs e)
  87. {
  88. for (int i = 0; i < студентыDataGridView.ColumnCount; i++)
  89. for (int j = 0; j < студентыDataGridView.RowCount; j++)
  90. {
  91. студентыDataGridView[i, j].Style.BackColor = Color.White;
  92. студентыDataGridView[i, j].Style.ForeColor = Color.Black;
  93. }
  94. for (int i = 0; i < студентыDataGridView.ColumnCount; i++)
  95. for (int j = 0; j < студентыDataGridView.RowCount; j++)
  96. if (студентыDataGridView[i, j].Value != null)
  97. if (студентыDataGridView[i, j].Value.ToString().IndexOf(listBox1.Text) > -1)
  98. {
  99. студентыDataGridView[i, j].Style.BackColor = Color.AliceBlue;
  100. студентыDataGridView[i, j].Style.ForeColor = Color.Blue;
  101. }
  102. }
  103. private void button5_Click(object sender, EventArgs e)
  104. { this.Close(); }
  105. private void button1_Click_1(object sender, EventArgs e)
  106. {
  107. DataGridViewColumn Col = null;
  108. switch (listBox1.SelectedIndex)
  109. {
  110. case 0:
  111. Col = dataGridViewTextBoxColumn2;
  112. break;
  113. case 1:
  114. Col = dataGridViewTextBoxColumn3;
  115. break;
  116. case 2:
  117. Col = dataGridViewTextBoxColumn4;
  118. break;
  119. case 3:
  120. Col = dataGridViewTextBoxColumn5;
  121. break;
  122. case 4:
  123. Col = dataGridViewTextBoxColumn6;
  124. break;
  125. case 5:
  126. Col = dataGridViewTextBoxColumn7;
  127. break;
  128. case 6:
  129. Col = dataGridViewTextBoxColumn8;
  130. break;
  131. case 7:
  132. Col = dataGridViewTextBoxColumn9;
  133. break;
  134. case 8:
  135. Col = dataGridViewTextBoxColumn10;
  136. break;
  137. case 9:
  138. Col = dataGridViewTextBoxColumn11;
  139. break;
  140. case 10:
  141. Col = dataGridViewTextBoxColumn12;
  142. break;
  143. //case 11: Col = dataGridViewTextBoxColumn1;// break;
  144. }
  145. if (radioButton1.Checked)
  146. студентыDataGridView.Sort(Col, ListSortDirection.Ascending);
  147. else
  148. студентыDataGridView.Sort(Col, ListSortDirection.Descending);
  149. }
  150. }
  151. }