C# SqlServer - .NET¼¼Êõ / C#

C# code:

SqlConnection myConn = new SqlConnection("Server=localhost;Database=Scores;uid=sa;pwd=;");
SqlCommand cmd= new SqlCommand();;
cmd.CommandType = System.Data.CommandType.Text;
myConn.Open();
cmd.CommandText = "insert into INFO(ѧºÅ) values ('111')";
int num = cmd.ExecuteNonQuery();
cmd.Connection = myConn;


ΪʲôûÓ𡣿´ó¼Ò°ï°ï棡Êý¾Ý¿âÖеıíû±ä°¡£¡

---

cmd.Connection = myConn;  
·Åµ½µÚ3ÐÐÈ¥

---

ÒªÏÈΪSqlCommand¶ÔÏóÖ¸¶¨SqlConnectionÁ¬½Ó£¬È»ºóÔÙÖ´ÐÐÃüÁî¡£

---

ÒýÓÃ

cmd.Connection = myConn;
·Åµ½µÚ3ÐÐÈ¥

¶÷ UP

---

ȷʵȷʵ£¬Ð»Ð»¶þ룬µ«ÊÇΪʲôÄØ£¿

---

cmd.Connection = myConn; ·ÅÔÚ int num = cmd.ExecuteNonQuery(); Ç°ÃæÖ´ÐоÍOKÁË

---

SqlConnection myConn = new SqlConnection("Server=localhost;Database=Scores;uid=sa;pwd=;");
  myConn.Open();
  SqlCommand cmd= new SqlCommand('insert into INFO(ѧºÅ) values ('111')',myConn);
  int num = cmd.ExecuteNonQuery();
  myConn.Close();

---

1¡¢2Â¥¶¼ÕýÈ· 
ÊÂʵÉÏ°Ñcmd.Connection = myConn; 
·Åµ½num = cmd.ExecuteNonQuery();֮ǰ¾ÍÐУ¬
cmdÒªÓÐÁ¬½Ó ²¢ÇÒÁ¬½Ó´ò¿ª²ÅÄÜexcute