string myConnection = "datasource= ; username=root ;password=" ; MySqlConnection myConn = new MySqlConnection(myConnection); MySqlDataAdapter my = new MySqlDataAdapter(); my.SelectCommand = new MySqlCommand("select*from*users*ID ;", myConn); myConn.Open(); DataSet ds = new DataSet(); MessageBox.Show("Коннектед");
myConn.Open();
List<string> values = new List<string>(); command.CommandText = "SELECT * FROM `tablename`;"; Reader = command.ExecuteReader(); while (Reader.Read()) { values.Add(Read.GetValue(0).ToString()); //0 - индекс поля. }