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());
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5