• 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

    • -- "So, how could the Trump team make such a mistake on something so politically important to them?" Because the Trump team didn't care enough about editing the embedded map on the website just like they didn't care enough about actually building a phone. They're just slapping Trump's name on some pre-built Chinese OEM Android phone and selling it to MAGA rubes. 🤣
    • Here in the UK we used to have a mobile network that would've been perfect for Trump. It was called ... Orange!
    • Trump's team takes down Trump Mobile coverage map that includes "Gulf of Mexico" by David Uzondu Image via Depositphotos.com When Donald Trump returned to office in January this year, one of the first things he did was sign an executive order to officially rename the Gulf of Mexico to the "Gulf of America". It was a signature move, but it seems his own team might have forgotten about it. The rollout for the new Trump Mobile service, a venture headed by his sons, is already facing issues with its pre-orders, and now has a whole new self-inflicted problem to deal with. A post from Travis Akers (@travisakers) has shown that the Trump Mobile official coverage map, intended to show potential customers their signal strength, prominently featured the name "Gulf of Mexico." It appears shortly after Akers's post went live, the Trump team took down the page, so if you visit trumpmobile.com/coverage, you would get a 404 error. Anyways, here's a screen recording of what the page looked like before the take down (double click to enlarge): So, how could the Trump team make such a mistake on something so politically important to them? From the recording, it looks like the coverage map is powered by Mapbox, a popular location platform for developers. Mapbox, by default, still uses "Gulf of Mexico" because its core map data is built on global sources like OpenStreetMap, which have not adopted the unilateral name change. Even though the official name is different in the US, these global datasets stick to the international consensus. Other tech companies, like Google, address this by changing their maps to display "Gulf of America" only for users in the US, a decision that annoyed the president of Mexico. The funny thing is, fixing this would have been pretty simple. Mapbox is quite flexible, and you can edit "natural features", including bodies of water. Here's how we did it (click to enlarge): The Trump Mobile coverage map has been offline for over five hours, as the Trump team presumably works to fix the issue and bring the page back online.
    • Maybe stop using that ###### once and for all? One can live withouth it. Anything META is cancer.
    • This also highlights the dangers of giving corporations unencrypted access to your documents / photos. It would appear this persons data has likely been scanned by Ai, which found something it didn't like, locking access to the account.
  • Recent Achievements

    • Week One Done
      rozermack875 earned a badge
      Week One Done
    • Week One Done
      oneworldtechnologies earned a badge
      Week One Done
    • Veteran
      matthiew went up a rank
      Veteran
    • Enthusiast
      Motoman26 went up a rank
      Enthusiast
    • Mentor
      M. Murcek went up a rank
      Mentor
  • Popular Contributors

    1. 1
      +primortal
      684
    2. 2
      ATLien_0
      266
    3. 3
      Michael Scrip
      194
    4. 4
      +FloatingFatMan
      177
    5. 5
      Steven P.
      140
  • Tell a friend

    Love Neowin? Tell a friend!