sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime < '"+endTime+"')"

ÕâÑùдÓÐÎÊÌâÂð£¬StartTime, EndTimeÔÚÊý¾Ý¿âÖÐÊÇdatetimeÀàÐÍ

---

ÓÃmessagebox('',sql)³öÀ´¿´¿´¾ÍÖªµÀÁË°¡

---

µ÷ÊÔÏ¿´¿´¾ÍÐС£whereÇ°¼Ó¸ö¿Õ¸ñ£¬where×Ö¾äÖпոñÈ¥µô£¬ ʱ¼äÓà '2009-1-1' £¬×¢Ò⣬'£¬'ÐèҪתÒå¡£

---

×îºÃµÄ辦·¨ÊÇÓÃmessagebox³ö來¿´Ò»Ï£¬SQL語¾äÓÐ沒問題¡£

---

ÓÃstringÊÔÊÔ
string startTime,endTime
startTime=em_1.Text
endTime=em_2.Text

string sql
sql = dw_1.GetSQLSelect()+" Where (StartTime> '"+startTime+"') and (EndTime < '"+endTime+"')"

---

Èç¹ûÄãÊÇÓÃÀ´¸ù¾Ýʱ¼ä²éѯ¼Ç¼µÄ»°
ls_select = "(convert(char(10),em_work.work_date,120) >= '" +ls_begin+ "') and (convert(char(10),em_work.work_date,120) <= '" + ls_end + "')"

---

ÒýÓÃ

ÓÃstringÊÔÊÔ
string startTime,endTime
startTime=em_1.Text
endTime=em_2.Text

string sql
sql = dw_1.GetSQLSelect()+" Where (StartTime> '"+startTime+"') and (EndTime < '"+endTime+"')"