sql¸üÐÂÎÊÌâ

Õâ¶Î´úÂë¿ÉÒÔÔËÐУ¬µ«²»ÄܸüÐÂÊý¾Ý£¬²»ÖªÎÊÌâ³öÔÚÄÄÀ

Dim Sql As String
Dim Cnn As SqlConnection
Dim Cmd As SqlCommand
Dim userid As String=Request.Cookies("gongsi_id").value
Dim ming As String=gongsiming.text
Dim dianh As String=gstel.text
Cnn=new SqlConnection("server=***;database=***;uid=sa;pwd=***;")
Cnn.open()
Sql = "update gongsi_yh set gongsiming='" & ming & "',gstel='" & dianh & "' where gongsi_id=" & trim(userid)
Cmd = New SqlCommand(Sql, Cnn)
Cmd.ExecuteNonQuery()
Cnn.Close()

---

sqlÓï¾äÖ±½ÓÔÚÊý¾Ý¿âÀïÖ´ÐÐÊÔÊÔ¡£

---

ÕâÑùÊÔÁË£¬¿ÉÒÔÖ´ÐÐsql

update gongsi_yh set gongsiming='" & ming & "',gstel='" & dianh & "' where gongsi_id=123

---

SQLÀï¸úһϿ´¿´Ö´ÐÐÁËû

---

Éè¸ö¶Ïµãµ÷ÊÔ£¬¿´ÏÂÉú³ÉµÄsqlÊÇ·ñÓëÄãÉèÏëµÄÒ»Ö£¬¿ÉÄÜδ»ñÈ¡µ½ÕýÈ·µÄ²ÎÊý

---

¿´¿´Sql =£¿

*****************************************************************************
»¶Ó­Ê¹ÓÃCSDNÂÛ̳רÓÃÔĶÁÆ÷ : CSDN Reader(¸½È«²¿Ô´´úÂë)

http://feiyun0112.cnblogs.com/

---

ÒýÓÃ

ÕâÑùÊÔÁË£¬¿ÉÒÔÖ´ÐÐsql

update gongsi_yh set gongsiming='" & ming & "',gstel='" & dianh & "' where gongsi_id=123

ÄǾÍÊÇÄãSQLÓï¾äµÄÎÊÌâ

---

ÎҸijÉÕâÑù¾Í¿ÉÒÔÁË£¬ÊǺÎÔ­Òò£¿
Dim ming As