System.Windows.Forms.Timer t1 = new System.Windows.Forms.Timer(); t1.Interval = 10000; t1.Tick += new EventHandler(t1_Tick); t1.Start();
void t1_Tick(object sender, EventArgs e) { //Requete vers la base de données String requete = "SELECT * FROM table WHERE date > " + DateTime.Now.Subtract(TimeSpan.FromMinutes(10)); //Affichage dans la gridview }
query = ("SELECT * FROM [marine.meteo]WHERE HeureMeteo > '" + heure2.Subtract(System.TimeSpan.FromMinutes(10)) + "'");
datetime > DateTime.Now.Subtract(TimeSpan.FromMinutes(10));
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionprotected void ButtonReel_Click(object sender, EventArgs e) { GridViewMois.Visible = true; System.Windows.Forms.Timer t1 = new System.Windows.Forms.Timer(); t1.Interval = 10000; t1.Tick += new EventHandler(t1_Tick); t1.Start(); }
void t1_Tick(object sender, EventArgs e) { connection = new SqlConnection("Data Source=etcccc") query = ("SELECT * FROM [marine.meteo] WHERE HeureMeteo > " + DateTime.Now.Subtract(System.TimeSpan.FromMinutes(10))); command = new SqlCommand(query, connection); connection.Open(); reader = command.ExecuteReader(); while (reader.Read()) { GridViewMois.DataSource = reader; GridViewMois.DataBind(); } connection.Close(); }
SELECT * FROM [marine.meteo]pour voir si c'est ton where qui ne va pas. Il faut bien faire attention a la différence de format entre ta colonne HeureMeteo et un datetime. Quel est le type de ta colonne?
SELECT * FROM [marine.meteo]
DateTime Heure = DateTime.Now; // string heure2 = Convert.ToString(Heure.TimeOfDay); System.TimeSpan heure2 = Heure.TimeOfDay; connection = new SqlConnection("Data Source=192.168.146.128;Initial Catalog=BDD_Marine;User ID=sa;Password=BTSbts2"); query = ("SELECT * FROM [marine.meteo]WHERE HeureMeteo > " + heure2.Subtract(System.TimeSpan.FromMinutes(10))); command = new SqlCommand(query, connection); //exécution de la requete et de la connexion connection.Open();//ouverture de la connection reader = command.ExecuteReader(); while (reader.Read()) { GridViewMois.DataSource = reader; GridViewMois.DataBind(); } connection.Close(); } }
query"SELECT * FROM [marine.meteo]WHERE HeureMeteo > 20:50:04.9677577"