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