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 È¥µô£¡

»¹ÊDZ¨Í¬ÑùµÄ´í

---

ÒýÓÃ

AccessÈÕÆÚÊÇo.ordersday=#" + dateTimePicker1.Text + "#", ¶øÇÒidºÃÏñÊǹؼü×Öp.[id]= o.[id]

ÒýÓÃ

from [particular]  p  ºóÃæÄǸöÒ²ÊÇÒ»Ñù£¡°Ñas È¥µô£¡

ÕâÁ½¸ö¿ÉÄÜ