Data Entry page only in VB.Net /.ASP

Question

5.00/5 (1 vote)

See more:

I have good skills and background with Visual Basic and writing SQL calls to an Access Database. I use Visual Studio 2010 and prefer to stick to VB as much as I can, unless I can find some code snippet to get me started if I need to use a different language.

I have been asked by my employer to create a web page that would function as follows.

Upon visiting the page, the user would see a data entry form. This will use text boxes, check boxes and perhaps, but not likely a pre-populated dropdown box. The visitor would fill in items on the form and submit. I would do a data validatation to be sure that certain form items were filled in. This data would be saved to a database that other applications would work with to process what the user entered.

I think from everything I've read that .ASP has the potential for this, but everything I read about the Studio 2010 version seems to indicate that only the gridview is available and then, only to view data. I do not want the user to see any data. Also, most of this seems to be oriented for C#.

I've visited Scaffolding for a process to use, but that too seems to be more about displaying data and then letting the user make edits to it.

Ideally, once this project has been up, other forms will created that would have some dynamic data depending on why the person is visiting the website to enter data.

My alternative is to create a FrontPage form, let the user submit that and then read the email sent by Frontpage and parse the data.

Can someone point me in the right direction?

Many thanks in advance!

Posted 25-Aug-11 3:21am

TomSeemore

Add a Solution

Comments

Wayne Gaylard 25-Aug-11 9:34am

I use VS 2010 and I can create a Web Application(ASP.Net) that has all the tools such as textbox, dropdownlist button etc. What project are you trying to start?

TomSeemore 25-Aug-11 10:29am

Pretty much what I explained above. I'm just having a hard time wrapping my head around how to do this, but the sample videos below MSDN Web Developer Samples seems to have a good head start.

4 solutions

Solution 4

So, I've spent most of the day reading the linked articles above and watching and working along with the video posted by Microsoft on MSDN Web Developer Samples. In the end, the project leads to data being entered in a Gridview and managed on the server side by that. This is all well and good, but I'm looking at a page with check boxes, text boxes etc. Controls that I used to put on a form, run a SQL and save them to a database. Any further ideas toward a direct route of gathering data as I said and then saving it in a database?

Many thanks in advance. (Even a specific book or website recommendation would be helpfu. I've googled "Data entry web page" and variations of it like crazy.)

Posted 25-Aug-11 10:26am

TomSeemore

Solution 1

Not to sound snide, but every ASP.NET book I've ever browsed though has chapters covering data entry. There is also so much information here and on the web covering multiple techniques for this that I simply can't believe all you have found are read-only GridViews.

FrontPage is outdated, deprecated technology.

Posted 25-Aug-11 3:34am

Not Active

Updated 25-Aug-11 4:01am

v2

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)

Simon_Whale · Accepted Answer · 2011-08-25T03:36:00

Solution 2

I would look here to start with if you want to learn about creating data entry pages

MSDN Web Developer Samples[^]

Posted 25-Aug-11 3:36am

Simon_Whale

TheyCallMeMrJames · Accepted Answer · 2011-08-25T03:39:00

What you're talking about is very doable on many stacks. You should be able to find many samples around this.

ASP.NET is certainly a quick route. FrontPage form parsing will be harder to write than a simple scaffolded MVC site.

If you're looking at ASP.NET MVC and wondering if it seems like a lot of work, it might lots, especially for just one, create-only view of the data. MVC is a framework for projects and has a lot more purpose/intent than just data entry. It's like taking a dump truck to drop the kids off for daycare in your case.

Of course if you know MVC really well, this is also a 10 minute task when you use scaffolding. If you don't, you have a steep learning curve.

Perhaps you can find an appropriate route using Linq to SQL[^]? These skills would also be very complimentary to your work in VB WinForms development.

Finally...I have no idea how you're only finding info that suggests you can only make read-only grid views on ASP.NET. How do you think they built this site?

Cheers.