OleDbConnection cn = new OleDbConnection(); cn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\`Hp\Desktop\PROGRAM1\notificationSystem\notificationSystem\Database.accdb"; OleDbCommand cmd = new OleDbCommand(); cmd.Connection = cn; string cmdText = "SELECT * FROM news " + "WHERE npublished BETWEEN ? AND ?"; DateTime dt = this.metroDateTime1.Value.Date; DateTime dt2 = this.metroDateTime1.Value.Date.AddMinutes(1440); cmd.CommandText = cmdText; cmd.Parameters.AddWithValue("@p1", dt); cmd.Parameters.AddWithValue("@p2", dt2); cmd.Parameters.AddWithValue("@article", metroTextBox2.Text); OleDbDataAdapter adapter = new OleDbDataAdapter(cmdText, cn); DataSet ds = new DataSet(); adapter.Fill(ds); Form5 f5 = new Form5(); f5.newsGrid.DataSource = ds.Tables[0]; cn.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)