How to write the form values in Database using C#

[Aienstaien]

How to write the form values in Database using C#, I have a simple form (text fields and pull down menus), I have not keep more customization in my existing form and I want to insert the values from the form into an sql database. This is because i have just now started my ASP.NET classes. Do we need to simply insert the values in the database as we inserted into table or there any specific method to do it.

[Dodge]

In your submit button, you have to hook onto an "OnClick" event (in visual studio, double click the button, and it'll create it for you), in there, I managed to get the program to connect to the sql database but how do I set up the insert statement? I have dropdown, radiobuttons and text fields, you can get all the values from your text field and then insert the data into your database using whatever data access method you prefer.

[machok]

Start by creating a new Windows Application titled Data Form Example. C# does not make use of header files; it uses namespaces to accomplish this purpose. Choose Add Windows Form from the Project menu to display the Add New Item dialog box, click the Data Form Wizard icon, change the name to fclsDataForm.cs Like every Win32 application source, we will start with the inclusion of some header files. The Data Form Wizard is run by adding it to your project as a form template.

[Chingum]

Don't you alreay use Request.fomr to retrive this value. Also once you stored these values in application variables they are available from anywhere. You need to defined a connection to the Contacts database, your drop-down list will be empty. Click the New Connection button to display the Data Link Properties dialog box.NOTE that I would put this rather in session as application variables are shared by all sessions and this could result in a problem if multiple users are logging at the same time.