Microsoft Visual Web Developer allows you to create data entry forms for updating records and inserting new ones into a database with only a few lines of code.By using a combination of a data source control that encapsulates data access and controls that display records in an editable format, you can create a data entry page that allows users to edit existing records or insert new ones, all without any code.
A Visual Studio project with source code is available to accompany this topic: Download.
During this walkthrough, you will learn how to: The next step is to create and configure a data source control that can be used to query the database.
As when I assign updated Name to Label1 it displays the old product name value and not the one in the textbox.
But I can't see why it wouldn't be bringing back the new textbox values.
Also, I used the "enable editing" option on the Details View.
Thanks, Derek Hi, Derek i guess u r probably using the "original_" type query........do that rather just use a primary key to the database like "Info_no" & refrence the row to be updated with this key. Its not working It shows zero value when i assign to variable string. Thanks in advance You don't need to store the value in a textbox at all.Add("Member Id",s_uniqueid); // Store the string unique id string to session variable so far called Member Id Or Use querystring to transfer the values from one page to another If you are developing application using ajax, then you need to use Response. Here is my code: Details View & SQL Queries: " Delete Command="DELETE FROM [Users] WHERE [ID] = @ID" Insert Command="INSERT INTO [Users] ([Client ID], [User Name], [Password], [First Name], [Last Name], [Email], [Job ID], [Supervisor ID], [Hire Date], [Status]) VALUES (@Client ID, @User Name, @Password, @First Name, @Last Name, @Email, @Job ID, @Supervisor ID, @Hire Date, @Status)" Provider Name="" Select Command="SELECT [ID], [Client ID], [User Name], [Password], [First Name], [Last Name], [Email], [Job ID], [Supervisor ID], [Hire Date], [Status] FROM [Users] WHERE [ID] = @ID" Update Command="UPDATE [Users] SET [Client ID] = @Client ID, [User Name] = @User Name, [Password] = @Password, [First Name] = @First Name, [Last Name] = @Last Name, [Email] = @Email, [Job ID] = @Job ID, [Supervisor ID] = @Supervisor ID, [Hire Date] = @Hire Date, [Status] = @Status List WHERE [ID] = @ID" I'm not sure where to go from here. Thank you for your help, but this doesn't seem to have resolved the issue.I've tried to change the Update command in my SQLData Source for the Drop Down List (named Status List) but haven't had any luck. All other fields still update, except the Drop Down List (that I call Status List).Here is my detailsview: I tried adding a label to my page and then once updated Name had been assigned the value of the textbox I tried assigning that value to the label and it printed out the old product name not the one in the textbox.