Select a particular record from Access database

Soumya Surendran

Hai Experts...Please Help me........
I want to retrieve a particular item from the table schedule. I was using the following code....But error occures....
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=RDSCHAGT1.mdb;User ID=;Password=;");
con.Open();
OleDbCommand cmd = con.CreateCommand();
cmd.CommandText = "select listNo from schedule where EXTRACT(year from listdate)='" + year.Text + "' and EXTRACT(month from listdate)='" + month.Text + "' GROUP BY listNo";
cmd.Connection = con;
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr[0]);

}
dr.Close();

Please Help me.......................

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Blocked Account17y ago
Hi

Change this line

cmd.CommandText = "select [listNo] from [schedule] where EXTRACT(year from listdate)='" + year.Text + "' and EXTRACT(month from listdate)='" + month.Text + "' GROUP BY listNo";

if this don't work then also put [] in the ramaining listdate and listNo in the query

means u have to put all the fields into the brackets.

Hope it works!
Soumya Surendran17y ago
The error was
IErrorInfo.GetDescription failed with E_FAIL(0x80004005)
Blocked Account17y ago
Hi

Can u explain what type of error you are getting.