c# ammend SQL data

Question

I am making a basic ticketing system in C# with basic coding experience. Most of my experience is in SQL.

I have the database and tables. I have stored procedures to create and amend tickets.

I am stuck (this is probably very basic) because:

On my EDIT ticket page, I populate various text boxes and drop downs from my existing data via inline SQL.
On my page, I can edit all the fields and dropdowns with new values. (i.e. change a ticket priority from when it was first logged)
I have a button, that calls my "update" stored procedure, however it updates only the NEW fields I have, any amendments to the existing fields are overwritten by the original values before submitting.

The original values are called on pageload, so I think the button reloads the page before submitting. I want it to submit all the values that are on the screen.

I think this must be something obvious, remember I am a novice so I may have missed something simple.

Moho · Accepted Answer · 2013-03-28 08:42:26Z

1

If what you're saying is you load values from the DB into the form controls in the PageLoad event handler, then yes, you're probably overwriting the changed values. To keep things as simple as possible for you, wrap the original values loading code in the following:

if( !IsPostBack )
{
   // load initial form values here from DB
}

I'd suggest you read about the ASP.NET page lifecycle: http://msdn.microsoft.com/en-us/library/ms178472(v=vs.90).aspx

answered Mar 28, 2013 at 8:42

Moho

16.8k1 gold badge36 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Geraint Llewelyn Over a year ago

Thank you very much, that appears to have worked in my tests. I will report back when I have got it working later today.

Collectives™ on Stack Overflow

c# ammend SQL data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related