public static List <string> SelectCombo(string query) { //Open connection if (ConnectionClass.OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, ConnectionClass.connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); listcombo.Clear(); //Read the data and store them in the list while (dataReader.Read()) { string item = ""; listcombo.Add(item); item = listcombo[listcombo.Count - 1] = dataReader[0].ToString(); //get info from DB tables depending on the count of columns } //close Data Reader dataReader.Close(); //close Connection ConnectionClass.CloseConnection(); //return list to be displayed return(listcombo); } else { return(listcombo); } }
public static int SelectOne(string query) { int result = 0; //Open connection if (ConnectionClass.OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, ConnectionClass.connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list while (dataReader.Read()) { try { // MessageBox.Show(query + " " + dataReader.GetInt32(0).ToString()); result = dataReader.GetInt32(0); //почему-то 0 } catch { result = 0; } } //close Data Reader dataReader.Close(); //close Connection ConnectionClass.CloseConnection(); //return list to be displayed return(result); } else { return(result); } }
public static void QuerytoTable(string query) { try { //open connection if (ConnectionClass.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, ConnectionClass.connection); //Execute command cmd.ExecuteNonQuery(); //close connection ConnectionClass.CloseConnection(); } } catch { MessageBox.Show("Какая-то ошибка в твоей жизни"); return; } }
public static List <string[]> SelectQuery(string query, DataGridView table) { int countColumn = table.ColumnCount; //Open connection if (ConnectionClass.OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, ConnectionClass.connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); listName.Clear(); //Read the data and store them in the list while (dataReader.Read()) { listName.Add(new string[countColumn]); for (int i = 0; i < countColumn; i++) { listName[listName.Count - 1][i] = dataReader[i].ToString(); //get info from DB tables depending on the count of columns } } RefreshInfo(table); //close Data Reader dataReader.Close(); //close Connection ConnectionClass.CloseConnection(); //return list to be displayed return(listName); } else { return(listName); } }