• 0

[ASP.NET and SQL] Stored Procedure and gridview update


Question

Hello,

I have a table called t_data containing the following columns:

id, iYear, iMonth, iValue, fk_t_relation_id

The fk_t_relation_id column is linked to the id of a project table so for a single year, 12 rows in t_data have the same fk_t_relation_id. In my gridview I use a stored procedure to show the data from each project on a single row with all the months in that row instead of 12 rows for a single year. The problem comes when I try to edit the values in my grid.

I use the following stored procedure:

ALTER PROCEDURE [dbo].[p_updateData]

@iYear int,
@id int,
@iJan int,
@iFeb int,
@iMar int,
@iApr int,
@iMay int,
@June int,
@July int,
@Aug int,
@Sept int,
@Oct int,
@Nov int,
@Dec int,

AS
BEGIN

UPDATE t_data
SET iValue = @iJan
WHERE fk_t_relation_id = @id AND
iYear = @iYear AND
iMonth = 1

UPDATE t_data
SET iValue = @iFeb
WHERE fk_t_relation_id = @id AND
iYear = @iYear AND
iMonth = 2

And so on for each month.

@id in my gridview corresponds to the id of the project in t_relation, or the value of fk_t_relation_id in t_data. The procedure works fine when testing it in SQL Server 2005 but I do get problems when testing it in my application. I get no error message but the update simply doesn't go through.

When running the application in debug mode and editing entries, it seems to only check the ItemTemplates and not the EditTemplates. The Datasource seems correct the and UpdateCommand points to the right stored procedure. I get no errors or exceptions either.

I have tried adding the values iJan, iFeb, etc. to the DataKeyNames in the <asp:gridview> tag but that didn't help.

I really have no clue as to how to fix this. Any help will be appreciated. Please do tell if you need more information as I am new to the subject.

2 answers to this question

Recommended Posts

  • 0

I would recommend to use the SQL Profiler to figure out the exact statement that SQL is receiving to execute.

Since you said its working when testing it in SQL, probably you're not filling the values correctly from the ASP.NET app. First use the sql profiler to determine exactly what SQL is being sent.

you just start the profiler, then do the update in your application and stop the profiler, so you can find the specific row in the profiler that was sent by the ASP.NET app.

hope this helps.

  • 0

Hey, thanks for the reply.

I tried using the Profiler but I did not have required the permissions since I am not the db owner. I did find another way to see what parameters were passed and how they were passed. It turns out the @iYear parameter wasn't passed correctly, it always returned a null value. Everything works now. :)

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Since I watch on a lot of devices and use the music service, I enjoy it. Like if I was just on PC then yeah use adblock. But I'm on watching on my phone, iPad, and TV and not always on my WiFi. The price is getting a little nuts at this point though.
    • Happens EVERY TIME a new version of WMP-HC comes out and you download it in the first few days of release. Happens a lot with other program updates that get listed in the software section here as well.
    • Hitman maker's first showcase will reveal its new James Bond game this week by Pulasthi Ariyasinghe IO Interactive is well known for its development of the Hitman series of stealth and assassination games. In a fitting twist, it was revealed back in 2020 that the studio has begun work on a James Bond game, and after years in development, it seems fans are finally getting a look at the project. Announced today, the project now has a title: 007 First Light. The brand-new game will be revealed in an exclusive showcase event. Coming in as the first ever IOI Showcase, it will be held on June 6 at 6pm PDT on the studio's own YouTube channel. "Join us for the first ever IOI SHOWCASE," said the studio in a social media post today. "Set your reminders and don't miss out on the exclusive reveals and information straight from the team!" Aside from 007 First Light information, the showcase will feature new content reveals for Hitman World of Assassination, the IO Interactive-published title MindsEye developed by Build a Rocket Boy, and more. The game is set to follow James Bond in his start as the MI6 special operative that everyone now knows him as. The origin story is said to be inspired by novels of Ian Fleming as well as the movie franchise, but it will be an original narrative by the developer. While we haven't even seen the game in action yet, IO Interactive CEO Hakan Abrak has already said that he hopes the game is successful enough to spawn a trilogy. "I don't want to speak too big about it, but I just hope we'll do a thing that will define James Bond in gaming for years to come," said Abrak last year. "And that is not only one game, but that we create a universe for gamers to own for many years to come that we can grow with that next to the Bond on the movies." While the studio hasn't revealed much more about 007 First Light since its original announcement, it has already been confirmed as coming for the Nintendo Switch 2 console. Other platforms have not been announced just yet, but it should land for PC, Xbox Series X|S, and PlayStation 5 consoles like the studio's other projects.
    • good grief .... first brittney murphy in the first run now him
    • I do not think that Windows 11 will pick up pace as October 2025 draws near. Even though I was a Windows Vista fan back in the day, this really reminds me of the (lack of) transition between Windows XP to Windows Vista. In the end, Microsoft had to backtrack and extend Windows XP support until Windows 7 was adopted.
  • Recent Achievements

    • Week One Done
      Nullun earned a badge
      Week One Done
    • First Post
      sultangris earned a badge
      First Post
    • Reacting Well
      sultangris earned a badge
      Reacting Well
    • First Post
      ClarkB earned a badge
      First Post
    • Week One Done
      Epaminombas earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      160
    2. 2
      ATLien_0
      124
    3. 3
      Xenon
      120
    4. 4
      snowy owl
      109
    5. 5
      +Edouard
      97
  • Tell a friend

    Love Neowin? Tell a friend!