sql ÎÊÌâ

PBÖпª·¢µÄ¡£

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ÀàÐÍ

---

×îºÃÓòÎÊý»¯µÄÐÎʽд.

---

PB²»¶®£¡Â¥Ï¼ÌÐø

---

ÄܾٸöÀý×ÓÂð£¬Ð»Ð»

ÒýÓÃ

×îºÃÓòÎÊý»¯µÄÐÎʽд.

---

C# code:
string sql = xx + " where startTime > @startTime and EndTime < @endTime";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.Add("@startTime",SqlDbType.DateTime);
cmd.Parameters.Add("@endTime",SqlDbType.DateTime);

cmd.Parameters["startTime"].Value = xx;
cmd.Parameters["endTime"].Value = xx;

cmd.ExecuteNonQuery();

---

PBÀïÃæ¿ÉÒÔÕâôÓÃô£¿/СÁº´ó´ó

---

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

--MSSQL
string sql
sql = dw_1.GetSQLSelect()+" Where (StartTime> '"+em_1.Text+"') and (EndTime < '"+em_2.Text+"')"

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.