sqlÔõÑù²åÈëÊý¾Ý°¡
ºÃÆæ¹Ö£¬ÎÒÔÚÎҵĵçÄÔÉÏ×÷µÄÒ»¸ö¼òµ¥µÄÁôÑ԰壬ÁôÑԳɹ¦£¬Ò»ÇÐÕý³££¬ÓÚÊÇÎҾͰÑËüŪµ½·þÎñÆ÷ÉÏÈ¥£¬½á¹ûʲôÏÖÏó¶¼Ã»ÓУ¬²»¹ÜÓò»Óô洢¹ý³ÌÔÚÎÒµçÄÔÉ϶¼ÕýÈ·¶ø·þÎñÆ÷×ÜÊÇûÓз´Ó¦
ConnectionStringSettings setting = System.Configuration.ConfigurationManager.ConnectionStrings["masterConnectionString"];
SqlConnection conn = new SqlConnection(setting.ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("insert into talk (text) values (@text)", conn);
//cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@text", SqlDbType.NVarChar);
cmd.Parameters["@text"].Value = this.content1.Value;
cmd.ExecuteNonQuery();
conn.Close();
this.content1.Value = "";
¾ÍÁ¬×îºóÒ»¾äthis.content1.Value = "";Çå¿ÕÁôÑÔ¿ò¶¼²»Ö´ÐÐÁË£¬²»±¨´í£¬
´ÓÎҵIJâÊÔÊý¾Ý¿´£¬Á¬½ÓÒ²¾ÍûÎÊÌâÁË£¬¾ÍÈçÕâ¸ö»ÃæÒ»Ñù£¬ÎÒµãÁË È·ÈÏÁôÑÔ ºó£¬»¹ÊÇÕ⸱»Ãæ
Connection StringÊÇ·ñÕýÈ·ÄØ£¿
´ÓÄãµÄÃèÊö¿´¿ÉÄÜÕâ¸ö¹ý³ÌûÓÐÖ´ÐÐ,µ¥²½¸ú×Ù¿´ÏÂ
file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/QQ½ØÍ¼Î´ÃüÃû.jpg
Ó¦¸ÃÊÇÄãµÄÁ¬½Ó×Ö·û²»¶ÔÁË£¬µ¥²½¸ú×ÙÏÂ
¶÷£¬Í¬Òâ4Â¥µÄ¿´·¨
Ó¦¸Ã¼ì
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´
°à¼¶±í ½Ìʦ±í
°à¼¶ID & ......