VS is just cautious and adds them to all columns and tables.
You can leave them in, but if you write your own SQL statements you don’t have to include them (although you could if you wanted to).
Now that you’ve seen how to display, edit, and delete data, it’s time to learn how to insert new rows in the database using the is able to display data in a few different modes.
First of all, it can display an existing row in read-only mode.
In addition, you can use the control to insert new rows and to update existing ones.
(visible in Figure 13-5), to sort the data in the grid on that column.When you enter some values and click the Insert link, a process similar to updating with the table.If you click the Insert link without entering a name or sort order, you’ll get an error.Therefore, later in this chapter, you see how to extend and customize these controls. Go back to the by selecting that name from the Choose Data Source drop-down list. On the same Smart Tasks panel, select the Enable Inserting item. Open the control’s Properties Grid by pressing F4 and then locate the .
Because the database generates this ID automatically, there is no point in letting the user enter a value for it.The value of the first part contains the data source to identify the SQL Server that is targeted, which in this case is a Local DB instance of SQL Server 2012.