Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Brittney10
Posting Yak Master
154 Posts |
 Posted - 2011-03-10 : 13:51:23
|
| First, my database is transaction based, which tracks shipments. There is a field "Status" which can get updated by the users to show the Status of a package. When a user goes to edit the Status of a shipment, he/she does not just update the record, but a new record is inserted. So what i have is a form that pulls in pre-populated data for a record (Buyer, Address, Phone, Status, etc...), the user can then change the Status of the shipment. However, this needs to be committed to the db as a inserted record, rather than an edited record. I want to see line-by-line each transaction record. However, in ASP.NET i cannot figure out how to insert this record in to the db, since the form is initially in edit mode. Any thoughts? |
|
|
Brittney10
Posting Yak Master
154 Posts |
Posted - 2011-03-10 : 13:54:51
|
| I'm using Visual Studio 2010/ASP.Net/C# |
 |
|
|
|
|
|
insert data after editing record's info