OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\db9.mdb");
const string SQLA = "SELECT * FROM he ORDER BY DAT";
OleDbCommand cmd = new OleDbCommand(SQLA, conn);
OleDbDataReader ar;
conn.Open();
ar = cmd.ExecuteReader();
textBox7.Text = heute.ToString().Remove(6);
string str;
string str1;
string str2;
while (ar.Read())
{
str1 = (ar["N1NEU"]).ToString();
str2 = (ar["Text"]).ToString();
str = ((ar["DAT"]).ToString()).Remove(6);
if(str == textBox7.Text)
{
textBox6.Text = str1;
textBox8.Text = str2;
break;
}
}
ar.Close();
conn.Close();