Wednesday, March 7, 2012

How to add an identity PK column to a View

For an ASP.net project, I have had a DropDownList with a static ArrayList.
The ArrayList will be defined from a View, where there is no Identity PK.

I also have used cbxDropDownListName.SelectedIndex to add new data to
a table, where an Indetity PK is used to reference the ArrayList.

I am wondering how can I add an identity PK to my view?

TIA,
Jeffrey

Why don't you select an identity column from one of the tables in the view? Pick an identity column that, by the view definition, would be unique in the view result set.

No comments:

Post a Comment