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Â¥µÄ¿´·¨
Ó¦¸Ã¼ì
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
ÓÐÈçÏÂÁ½¸ö±í
tb1
col col1
abc 111
cde 111
qaz 222
tgb 222
tb2
col2 col3
abc 111&n ......