Guest User

Untitled

a guest
Jan 9th, 2019
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.83 KB | None | 0 0
  1. string myConnection = "datasource=localhost; port=3306; username=root;password=root";
  2. if (comboBox4.SelectedItem.ToString() == "Salary")
  3. {
  4. string insert = "insert into budget.salary (name, suma) values (@name, @price);";
  5.  
  6. using (var conDataBase = new MySqlConnection(myConnection))
  7. using (var cmdDataBase = new MySqlCommand(insert, conDataBase))
  8. {
  9. cmdDataBase.Parameters.AddWithValue("@name", name);
  10. cmdDataBase.Parameters.AddWithValue("@price", suma);
  11. conDataBase.Open();
  12. cmdDataBase.ExecuteNonQuery();
  13.  
  14. MessageBox.Show("Saved");
  15. }
  16. }
  17. if (comboBox4.SelectedItem.ToString() == "Other")
  18. {
  19. string insert = "insert into budget.other (name, suma) values (@name, @price);";
  20.  
  21. using (var conDataBase = new MySqlConnection(myConnection))
  22. using (var cmdDataBase = new MySqlCommand(insert, conDataBase))
  23. {
  24. cmdDataBase.Parameters.AddWithValue("@name", name);
  25. cmdDataBase.Parameters.AddWithValue("@price", suma);
  26. conDataBase.Open();
  27. cmdDataBase.ExecuteNonQuery();
  28. MessageBox.Show("Saved");
  29.  
  30. }
  31. }
  32.  
  33. public void InsertInto(string table) {
  34. string myConnection = "datasource=localhost; port=3306; username=root;password=root";
  35. string insert = "insert into budget." + table + " (name, suma) values (@name, @price);";
  36.  
  37. using (var conDataBase = new MySqlConnection(myConnection))
  38. using (var cmdDataBase = new MySqlCommand(iterpti, conDataBase)) {
  39. cmdDataBase.Parameters.AddWithValue("@name", name);
  40. cmdDataBase.Parameters.AddWithValue("@price", suma);
  41. conDataBase.Open();
  42. cmdDataBase.ExecuteNonQuery();
  43. MessageBox.Show("Saved");
  44. }
  45. }
  46.  
  47. if (comboBox4.SelectedItem.ToString() == "Salary") {
  48. InsertInto("salary");
  49. }
  50. if (comboBox4.SelectedItem.ToString() == "Other") {
  51. InsertInto("other");
  52. }
  53.  
  54. string tableName = null; // tableName is the only difference between the two, right?
  55. if (comboBox4.SelectedItem.ToString() == "Salary") {
  56. tableName = "salary";
  57. } else if (comboBox4.SelectedItem.ToString() == "Other") {
  58. tableName = "other";
  59. }
  60.  
  61. if (tableName != null) {
  62. string iterpti = $"insert into budget.{tableName} (name, suma) values (@name, @price);";
  63.  
  64. using (var conDataBase = new MySqlConnection(myConnection))
  65. using (var cmdDataBase = new MySqlCommand(iterpti, conDataBase))
  66. {
  67. cmdDataBase.Parameters.AddWithValue("@name", name);
  68. cmdDataBase.Parameters.AddWithValue("@price", suma);
  69. conDataBase.Open();
  70. cmdDataBase.ExecuteNonQuery();
  71.  
  72. MessageBox.Show("Saved");
  73. }
  74.  
  75. }
  76.  
  77. private void InsertIntoTable(string tableName) {
  78. string iterpti = $"insert into budget.{tableName} (name, suma) values (@name, @price);";
  79.  
  80. using (var conDataBase = new MySqlConnection(myConnection))
  81. using (var cmdDataBase = new MySqlCommand(iterpti, conDataBase))
  82. {
  83. cmdDataBase.Parameters.AddWithValue("@name", name);
  84. cmdDataBase.Parameters.AddWithValue("@price", suma);
  85. conDataBase.Open();
  86. cmdDataBase.ExecuteNonQuery();
  87.  
  88. MessageBox.Show("Saved");
  89. }
  90. }
  91.  
  92. string iterpti = "insert into budget." + tableName + " (name, suma) values (@name, @price);";
  93.  
  94. private void DoInsertion(string tableName)
  95. {
  96. //logic to insert data
  97. }
  98.  
  99. if (comboBox4.SelectedItem.ToString() == "Salary")
  100. {
  101. DoInsertion("Salary");
  102. }
  103.  
  104. string myConnection = "datasource=localhost; port=3306; username=root;password=root";
  105. string value = comboBox4.SelectedItem.ToString();
  106. string insert = "";
  107.  
  108. switch (value)
  109. {
  110. case "Salary":
  111. insert = "insert into budget.salary (name, suma) values (@name, @price);";
  112. break;
  113.  
  114. case "Other":
  115. insert = "insert into budget.other (name, suma) values (@name, @price);";
  116. break;
  117.  
  118. # This case is optional in this situation.
  119. # You may not have to use this.
  120. default:
  121. break;
  122. }
  123.  
  124. using (var conDataBase = new MySqlConnection(myConnection))
  125. using (var cmdDataBase = new MySqlCommand(insert, conDataBase))
  126. {
  127. cmdDataBase.Parameters.AddWithValue("@name", name);
  128. cmdDataBase.Parameters.AddWithValue("@price", suma);
  129. conDataBase.Open();
  130. cmdDataBase.ExecuteNonQuery();
  131.  
  132. MessageBox.Show("Saved");
  133. }
  134.  
  135. string myConnection = "datasource=localhost; port=3306; username=root;password=root";
  136. string value = comboBox4.SelectedItem.ToString().ToLower();
  137. string insert = "";
  138.  
  139. if (value == "salary")
  140. {
  141. insert = "insert into budget.salary (name, suma) values (@name, @price);";
  142. }
  143.  
  144. else if (value == "other")
  145. insert = "insert into budget.other (name, suma) values (@name, @price);";
  146. }
  147.  
  148. using (var conDataBase = new MySqlConnection(myConnection))
  149. using (var cmdDataBase = new MySqlCommand(insert, conDataBase))
  150. {
  151. cmdDataBase.Parameters.AddWithValue("@name", name);
  152. cmdDataBase.Parameters.AddWithValue("@price", suma);
  153. conDataBase.Open();
  154. cmdDataBase.ExecuteNonQuery();
  155.  
  156. MessageBox.Show("Saved");
  157. }
  158.  
  159. string myConnection = "datasource=localhost; port=3306; username=root;password=root";
  160. string budgetField = comboBox4.SelectedItem.ToString().ToLower(); // This will be either "salary" or "other"
  161.  
  162. // This is where the magic happens: The {bracketed} variable gets repaced with either "salary" or "other".
  163. string insert = $"insert into budget.{budgetField} (name, suma) values (@name, @price);";
  164.  
  165. using (var conDataBase = new MySqlConnection(myConnection))
  166. using (var cmdDataBase = new MySqlCommand(iterpti, conDataBase))
  167. {
  168. cmdDataBase.Parameters.AddWithValue("@name", name);
  169. cmdDataBase.Parameters.AddWithValue("@price", suma);
  170. conDataBase.Open();
  171. cmdDataBase.ExecuteNonQuery();
  172. MessageBox.Show("Saved");
  173. }
  174.  
  175. public class Example1
  176. {
  177. private const string ConnectionString = "datasource=localhost; port=3306; username=root;password=root";
  178.  
  179. public void ExecuteOperation(string valueCombobox, string name, double price)
  180. {
  181. var sql = ConstructSql(valueCombobox);
  182. var value = InsertOperation(ConnectionString, sql, name, price);
  183.  
  184. //Do other things overhere like display the success message since you have the value variable.
  185. }
  186.  
  187. private string ConstructSql(string valueCombobox)
  188. {
  189. return string.Format("insert into budget.{0} (name, suma) values (@name, @price)", valueCombobox);
  190. }
  191. private int InsertOperation(string connectionstring, string sql, string name, double price)
  192. {
  193. using (var connection = new MySqlConnection(connectionstring))
  194. using (var command = new MySqlCommand(sql, connection))
  195. {
  196. command.Parameters.AddWithValue("@name", name);
  197. command.Parameters.AddWithValue("@price", price);
  198. connection.Open();
  199.  
  200. return command.ExecuteNonQuery();
  201. }
  202. }
  203. }
  204.  
  205. private void Form1_Load(object sender, EventArgs e)
  206. {
  207. SqlConnection connection = new SqlConnection();
  208. SqlCommand command = new SqlCommand();
  209. SqlDataReader reader;
  210.  
  211. connection.ConnectionString = @"Data Source=.SQLEXPRESS;Initial Catalog=University;"
  212. + "Integrated Security=SSPI";
  213. command.Connection = connection;
  214. command.CommandText = "SELECT FirstName, LastName, Age FROM Students";
  215.  
  216. connection.Open();
  217. reader = command.ExecuteReader();
  218.  
  219. while (reader.Read())
  220. {
  221. string firstName = reader["FirstName"].ToString();
  222. string lastName = reader["LastName"].ToString();
  223. int age = Convert.ToInt32(reader["Age"]);
  224.  
  225. studentsListBox.Items.Add(String.Format("{0} {1}, {2}",firstName,lastName,age));
  226. }
  227.  
  228. reader.Close();
  229. connection.Close();
Add Comment
Please, Sign In to add comment