Click here to Skip to main content
15,891,828 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionSelecting Images in aspx page Pin
psmukil3-Sep-06 20:27
psmukil3-Sep-06 20:27 
QuestionPersisting expanded/collapsed state of TreeView - how? Pin
nzmike3-Sep-06 19:09
nzmike3-Sep-06 19:09 
AnswerRe: Persisting expanded/collapsed state of TreeView - how? Pin
minhpc_bk4-Sep-06 15:20
minhpc_bk4-Sep-06 15:20 
QuestionUS asp.net & MS SQL hosting companies ? Pin
digsy_3-Sep-06 14:10
digsy_3-Sep-06 14:10 
QuestionStoreing hidden fields in a page for javascript to access Pin
hslew3-Sep-06 10:42
hslew3-Sep-06 10:42 
AnswerRe: Storeing hidden fields in a page for javascript to access Pin
Guffa3-Sep-06 11:53
Guffa3-Sep-06 11:53 
QuestionProgramatically parsing & extracting body of an HTML file Pin
Dsypher3-Sep-06 8:25
Dsypher3-Sep-06 8:25 
QuestionASP.net 2.0 detailsview insert problem Pin
aharrisreid3-Sep-06 7:44
aharrisreid3-Sep-06 7:44 
Using Visual Web Developer Express and ASP.net 2.0, I have an aspx page with a gridview showing all records from a dataset (from a SQL-server table connected via. ODBC). On the same page is a detailsview control showing details of a single record in the same dataset as the gridview above.
When I display the page in browser (while still in design mode) the page displays fine. I add a new row by clicking the "New" link on the detailsview control, enter data in all fields (except the auto-incremented pk field, which is not displayed), press "Insert" to commit, and get error message...
"ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'Categories' when IDENTITY_INSERT is set to OFF." The identity column in question is the primary key field iCategoryId, it starts at 1 and increments by 1 for each new row.

How can I set IDENTITY_INSERT to ON? As far as I can see, it is on already, because if I add rows manually (eg. via. enterprise manager), there is no problem with the primary-key field autoincrementing.

It makes no difference if I remove the gridview from the form.

Has anyone any ideas how to solve this problem? Any help would be appreciated.

Alan

QuestionAsp.net on the internet Pin
Marco_Hans3-Sep-06 7:34
Marco_Hans3-Sep-06 7:34 
Questionhot to get a runtime control during design time Pin
MarcoPan3-Sep-06 7:14
MarcoPan3-Sep-06 7:14 
AnswerRe: hot to get a runtime control during design time Pin
MarcoPan3-Sep-06 7:22
MarcoPan3-Sep-06 7:22 
QuestionExchange schema and Contact Category Pin
worky3-Sep-06 3:50
worky3-Sep-06 3:50 
Questionrefresh Pin
fouad8882-Sep-06 21:23
fouad8882-Sep-06 21:23 
AnswerRe: refresh Pin
Guffa3-Sep-06 0:10
Guffa3-Sep-06 0:10 
Questionproject i need Pin
ArjunJadeja2-Sep-06 20:56
ArjunJadeja2-Sep-06 20:56 
AnswerRe: project i need Pin
Colin Angus Mackay2-Sep-06 22:23
Colin Angus Mackay2-Sep-06 22:23 
QuestionEnter Pin
Socheat.Net2-Sep-06 16:18
Socheat.Net2-Sep-06 16:18 
AnswerRe: Enter Pin
Guffa3-Sep-06 0:06
Guffa3-Sep-06 0:06 
QuestionDropDownlist inside GridView Pin
vct2-Sep-06 10:08
vct2-Sep-06 10:08 
AnswerRe: DropDownlist inside GridView [modified] Pin
Naveed Kamboh4-Sep-06 0:36
Naveed Kamboh4-Sep-06 0:36 
Questiondynamically invoking a method in an assemly Pin
Sonu.T2-Sep-06 8:13
Sonu.T2-Sep-06 8:13 
AnswerRe: dynamically invoking a method in an assemly Pin
Guffa3-Sep-06 1:11
Guffa3-Sep-06 1:11 
GeneralRe: dynamically invoking a method in an assemly Pin
Sonu.T3-Sep-06 7:02
Sonu.T3-Sep-06 7:02 
GeneralRe: dynamically invoking a method in an assemly Pin
Guffa3-Sep-06 7:17
Guffa3-Sep-06 7:17 
Questiongridview data source(version-2.0) Pin
tanmaya1572-Sep-06 7:58
tanmaya1572-Sep-06 7:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.