c#连接access 问题

C# code:
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=orders.mdb;User Id=admin;Jet OLEDB:Database Password=hhh");
conn.Open();
string str = "select p.name, o.number,o.ordersday,o.giveday, p.id,p.name,p.how,p.price from [particular] as p join [orders] as o on p.id = o.id where o.ordersday='" + dateTimePicker1.Text + "' and o.giveday='" + dateTimePicker2.Text + "' and name='" + comboBox1.Text + "'";
OleDbCommand cmd = new OleDbCommand(str, conn);
[color=#FF0000] OleDbDataReader sdr2 = cmd.ExecuteReader();[/color]


报错说“ from 子句语法错误。”

大家帮我看看  语法怎么错了？

我没用过 access连接

谢谢！

---

from [particular]  p  后面那个也是一样！把as 去掉！

---

引用

from [particular]  p  后面那个也是一样！把as 去掉！

还是报同样的错

---

引用

Access日期是o.ordersday=#" + dateTimePicker1.Text + "#", 而且id好像是关键字p.[id]= o.[id]

引用

from [particular]  p  后面那个也是一样！把as 去掉！

这两个可能