|
'')";
// 1. Instantiate a new command with a query and connection
SqlCommand cmd = new SqlCommand(insertString, conn);
// 2. Call ExecuteNonQuery to send command
cmd.ExecuteNonQuery();
The SqlCommand instantiation is just a little different from what you''''ve seen before, but it is basically the same. Instead of a literal string as the first parameter of the SqlCommand constructor, we are using a variable, insertString. The insertString variable is declared just above the SqlCommand declaration.
SqlCommand的实例化过程与以前看到的有一些区别，但是基本一致。在构造函数的第一个字符串参数中是用的是插入字符串变量而不三字符串字面值。该变量在SqlCommand声明之前被声明了。
Notice the two apostrophes ('''''''') in the insertString text for the word "doesn''''''''t". This is how you escape the apostrophe to get the string to populate column properly.
注意在insertString文本中“doesn’’t”的两个单引号（’’）。这是将它转义为适当的单引号。
Another observation to make about the insert command is that we explicitly specified the columns CategoryName and Description. The Categories table has a primary key field named CategoryID. We left this out of the list because SQL Server will add this field itself. Trying to add a value to a primary key field, such as CategoryID, will generate an exception.
另外一个需要注意的是我们显式指明了列：CategoryName和Description。列表中有一个主键名为CategoryID。我们忽略这列因为SQL Server将自动添加此字段。试图对主键比如CategoryID添加值会产生异常。
To execute this command, we simply call the ExecuteNonQuery method on the SqlCommand instance, cmd.
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >>
[Sql Server]第二课 SqlConnection对象(翻译)
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
