Torna al Thread
MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter();
DataTable tabella = new DataTable();
da.SelectCommand = new MySql.Data.MySqlClient.MySqlCommand();
da.SelectCommand.Connection = new MySqlConnection(global::drill_manager.Properties.Settings.Default.gestione_impiantoConnectionString);
da.SelectCommand.CommandType = CommandType.Text;
da.SelectCommand.CommandText = "SELECT inizio FROM prenotazione WHERE inizio= ?inizio";"
da.SelectCommand.Parameters.Add("?inizio", MySql.Data.MySqlClient.MySqlDbType.DateTime).Value = dataCorrente;
if (da.SelectCommand.Connection.State == ConnectionState.Closed)
{
da.SelectCommand.Connection.Open();
}
da.Fill(tabella);
MessageBox.Show(tabella.Rows[0]["inizio"].ToString());