For this you can easily create a protected method and use databind to display the username in the txt User Name Text Box.
The Bind("User Name") will get the username from the database and display it on the screen and it will also send the username back to the database when you update.
Now, consider a situation where you don't want to display the username from the database but you want to display the current user in the txt User Name Text Box.
I also changed the type to Float in the db and Double in the model, but what finally got it working was having the nullable property.
If anybody else has a better solution I'll welcome any other answers.
Maybe do the same thing with the value of Markup Txt, just to see how it looks.
SOLVED - made the Markup column Nullable in the database and model.
The example shows how you can use a Db Transaction object to add transaction context when using the Sql Data Source control to update data.
The following code example demonstrates how to display data that is retrieved from a Microsoft SQL Server database in a Drop Down List control and update the record using a Text Box control.
Update(); ...doesn't update the value :(I still haven't figured this out.
NET/C# application I have an update panel that takes time to update. Please Wait" Message during the time of the calculations?
Do you have a way that I can track the @original Order ID and @Order Total parameter's value before the update occurs?