Save c# Web form to access datbase

Question

0.00/5 (No votes)

See more:

, +

Hello
I have created a ASP.NET web application, I have created 3 pages that require user input. These forms have labels, check boxes, text boxes, drop down list etc..
I am looking the user to fill out these forms then enter their first and last name at the bottom of each page and then click save to save the entire data entered. (labels, text boxes and button)
I then want to display these pages in a grid view on another page I have created, so the user can modify these if needed.
What is the best way to do this???
I initially wanted to save the entire web form to a ms database I created, then load this data into grid view. I was able to save the text fields but not the check boxes and drop down lists. Also some of the data on the page is fixed in the code, it doesn't require any user input.
Any help on this would be appreciated thanks.

Posted 7-Apr-14 2:27am

Member 10729814

Updated 7-Apr-14 3:09am

v2

Add a Solution

Comments

Suk@nta 7-Apr-14 9:23am

it will be better if you put your save function code

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Schatak · Answer 1 · 2014-04-07T03:17:00

Solution 1

You can google it by yourself and can find number of solution:
Try following
http://www.aspdotnet-suresh.com/2010/10/how-to-get-output-parameters-return-by.html[^]

http://csharpdotnetfreak.blogspot.com/2012/01/user-registration-form-aspnet.html[^]

Posted 7-Apr-14 3:17am

Schatak

Comments

Member 10729814 7-Apr-14 9:30am

I have googled it, they are both for sql its ms access OLE DB

Suk@nta · Answer 2 · 2014-04-07T03:22:00

Solution 2

If you want to save the checkbox value then you have to set the datatype of column to bit in database table . bcz checkbox value is boolean type

and in database table bit type as boolean.
for dropdown list nvarchar type is ok and the value should be dropdown1.text

and for checkbox ..checkbox1.Value

let me know it help you or not

Posted 7-Apr-14 3:22am

Suk@nta

Updated 7-Apr-14 3:28am

v2

Comments

Member 10729814 7-Apr-14 9:27am

what would it be for label?

Suk@nta 7-Apr-14 9:38am

just label1.text
and table nvarchar type

Schatak 7-Apr-14 9:29am

Try links in Solution one, you will get the idea