• 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

    • Google Pixel 10 series tipped to debut on August 13 by Sagar Naresh Bhavsar A few days ago, Google announced a pre-launch event for Pixel Superfans in the U.K., slated for this month. The event "Pixel Penthouse" will showcase Google's upcoming devices, including the Pixel 10 series phones. A total of 25 lucky fans, whom Google refers to as Superfans, will be selected to attend a 90-minute event in London on June 27. It was expected that fans would get a glimpse at the Pixel 10 series phones and the Pixel Watch 4. Now, a reliable leaker has added fuel to the fire, suggesting that the Pixel 10 series will launch in a couple of months. According to MysteryLupin on X/Twitter, the Pixel 10 could launch on August 13. Interestingly, this also suggests that Google is sticking with the same schedule as the Pixel 9 series launch. However, it is unclear if the leaker has revealed the launch date or the date of availability. This year, Google isn't expected to introduce drastic changes to the Pixel 10 series, something that is expected out of the Apple iPhone 17 series this year. However, the Pixel 10 series will get an upgraded TSMC-made Tensor G5 chipset and MediaTek modems instead of Qualcomm's. The Pixel 10 lineup will include four models, similar to last year: Pixel 10, Pixel 10 Pro, Pixel 10 Pro XL, and the Pixel 10 Pro Fold. Leaks have hinted at a similar design to the Pixel 9 series, but they are expected to get big camera upgrades. The Google Pixel 10 series could get a "Video Generative ML" feature that would allow users to edit their videos using AI tools. The phones could also get "Sketch to Image" and "Magic Mirror" features. Tensor G5 is also reportedly a capable chipset that will support 4K @60fps HDR video, as opposed to the 4K @30fps HDR video on the current Tensor G4 chipset. Additionally, the base Pixel 10 model is expected to get a telephoto lens. For now, all rumors must be taken with a pinch of salt. Let us know your thoughts on whether or not you'll be upgrading to the Pixel 10 this year.
    • Hi All, I wanted to know how I connect dual monitor (2 x 24 inch monitor) via HDMI or DP to my PC with no Graphics card Below are the PC Specs. I don't have any GFX card and currently utilising the integrated graphics. Processor : AMD Ryzen 7 7700 upto 5.30GHz 8C 16T OEM Motherboard : MSI B650 S Pro Wifi DDR5  
    • Definitely not the same telemetry collected for W10 as there is for W11, and W10 ran great compared to the dumpster fire that is W11 even today 4 years later. Windows 8 was not remarkable and arguably the most forgettable release to date.
    • Bazzite isn't a fork of SteamOS, it's a fork of Fedora Atomic that runs an interface similar to SteamOS. I'm also curious to hear what improvements it brings over actually running SteamOS on the Deck?
  • Recent Achievements

    • First Post
      ClarkB earned a badge
      First Post
    • Week One Done
      Epaminombas earned a badge
      Week One Done
    • Week One Done
      Prestige Podiatry Care earned a badge
      Week One Done
    • Week One Done
      rollconults earned a badge
      Week One Done
    • Week One Done
      lilred1938 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      137
    2. 2
      Xenon
      129
    3. 3
      ATLien_0
      124
    4. 4
      +Edouard
      102
    5. 5
      snowy owl
      97
  • Tell a friend

    Love Neowin? Tell a friend!