| 为了执行此命令，我们简单的对SqlCommand实体cmd调用ExecuteNonQuery方法。
This code is part of the InsertData method of Listing 1 in the Putting it All Together section later in this lesson.
这段代码是表1中InsertData方法的一部分，我们将在后面集中介绍。
Updating Data
更新数据
The ExecuteNonQuery method is also used for updating data. The following code shows how to update data:
ExecuteNonQuery方法同样用来更新数据。下面的代码显示了如何更新数据：
// prepare command string
string updateString = @"
update Categories
set CategoryName = ''''Other''''
where CategoryName = ''''Miscellaneous''''";
// 1. Instantiate a new command with command text only
SqlCommand cmd = new SqlCommand(updateString);
// 2. Set the Connection property
cmd.Connection = conn;
// 3. Call ExecuteNonQuery to send command
cmd.ExecuteNonQuery();
Again, we put the SQL command into a string variable, but this time we used a different SqlCommand constructor that takes only the command. In step 2, we assign the SqlConnection object, conn, to the Connection property of the SqlCommand object, cmd.
再一次，我们将SQL命令赋给字符串变量，但是这次我们使用了不同的 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 