Visual Web Developer SQL

[Giarc86]

I need to create a blog type of site in VWD but i cant get the insert, update and delete options to work...
I asume its because the primary key is not set in the table...But i have forgotten how to assign the primary key in the IDE
What data type am i supposed to use and what should there properties be?

Thanks

 

[OoMk0o5i3]

Did you enable the Create UPDATE, INSERT and DELETE statements? It is somewhere in the DataSource wizard.

In regards with the primary key you can just right click on the column name in the db editor and select primary key. In the properties of the field you can enable auto increment as set the step vaue = 1.

 

[Giarc86]

Thats the problem the CREATE, UPDATE and DELETE is grayed out

EDIT: Ok ive sorted it out thanks