About my project [modified]
-
hi, i am doing one task in my project.i need to update the holidays in the frontend(ASP.NET).but when i am entering the data it is not getting saved and displaying data as "holiday id cannot allow null values". i checked in the backend there is no problem in that it is displaying correctly. only problem is front end. In the holiday id identity specifications i incremented the properties.eventhough error is coming. insert into HolidayList(Holiday,Date,Day) values (@Holiday,@Date,@Day); select HolidayId = SCOPE_IDENTITY(); the query used in the sqlserver.in this we are not declaring the holidayid but when we are executing it automatically gets incremented.suppose there are 6 values in table if we enter the next value it automatically displays as 7 value and getting exeuted. but when coming to the front end it is not saving the data.when we are clicking on the save the page is getting refreshed. please give me the solution.it is very urgent for me. thanks Amala
modified on Tuesday, December 28, 2010 10:11 AM
-
hi, i am doing one task in my project.i need to update the holidays in the frontend(ASP.NET).but when i am entering the data it is not getting saved and displaying data as "holiday id cannot allow null values". i checked in the backend there is no problem in that it is displaying correctly. only problem is front end. In the holiday id identity specifications i incremented the properties.eventhough error is coming. insert into HolidayList(Holiday,Date,Day) values (@Holiday,@Date,@Day); select HolidayId = SCOPE_IDENTITY(); the query used in the sqlserver.in this we are not declaring the holidayid but when we are executing it automatically gets incremented.suppose there are 6 values in table if we enter the next value it automatically displays as 7 value and getting exeuted. but when coming to the front end it is not saving the data.when we are clicking on the save the page is getting refreshed. please give me the solution.it is very urgent for me. thanks Amala
modified on Tuesday, December 28, 2010 10:11 AM
You need to post some code here. Until then, it is virtually impossible to figure out the exact problem.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it. My latest tip/trick
-
hi, i am doing one task in my project.i need to update the holidays in the frontend(ASP.NET).but when i am entering the data it is not getting saved and displaying data as "holiday id cannot allow null values". i checked in the backend there is no problem in that it is displaying correctly. only problem is front end. In the holiday id identity specifications i incremented the properties.eventhough error is coming. insert into HolidayList(Holiday,Date,Day) values (@Holiday,@Date,@Day); select HolidayId = SCOPE_IDENTITY(); the query used in the sqlserver.in this we are not declaring the holidayid but when we are executing it automatically gets incremented.suppose there are 6 values in table if we enter the next value it automatically displays as 7 value and getting exeuted. but when coming to the front end it is not saving the data.when we are clicking on the save the page is getting refreshed. please give me the solution.it is very urgent for me. thanks Amala
modified on Tuesday, December 28, 2010 10:11 AM
mandarapuamala wrote:
the query used in the sqlserver
And how does the table-definition look? What columns and datatypes does it have?
mandarapuamala wrote:
"holiday id cannot allow null values". i checked in the backend there is no problem in that it is displaying correctly.
Any triggers that are defined on the table?
mandarapuamala wrote:
but when coming to the front end it is not saving the data.when we are clicking on the save the page is getting refreshed.
Are you doing an
insertor anupdateat that point?mandarapuamala wrote:
please give me the solution.it is very urgent for me.
This is a free site and questions are answered by volunteers like you, in their spare time. Demanding them to hurry would be inappropriate. You could also plough through the
SCOPE_IDENTITY[^]-documentation on MSDN :)I are Troll :suss:
-
mandarapuamala wrote:
the query used in the sqlserver
And how does the table-definition look? What columns and datatypes does it have?
mandarapuamala wrote:
"holiday id cannot allow null values". i checked in the backend there is no problem in that it is displaying correctly.
Any triggers that are defined on the table?
mandarapuamala wrote:
but when coming to the front end it is not saving the data.when we are clicking on the save the page is getting refreshed.
Are you doing an
insertor anupdateat that point?mandarapuamala wrote:
please give me the solution.it is very urgent for me.
This is a free site and questions are answered by volunteers like you, in their spare time. Demanding them to hurry would be inappropriate. You could also plough through the
SCOPE_IDENTITY[^]-documentation on MSDN :)I are Troll :suss:
I would suggest to use relevant title so that other people can benefit it :)