Solved

SQL input form

Posted on 2013-01-07
6
399 Views
Last Modified: 2013-01-21
I need to create a simple form that a user can use to input data into a table in SQL 2008 R2.  The columns are as follows:

DATE      
APPLICANT      
LOCATION      
REMARKS      
QUANTITY      
COUNT      
CONTAINER      
GRADE      
CERTIFICATE NUMBER      
CAR NUMBER      
QUANTITY THOUSAND WEIGHT      
TIME INSPECTION BEGUN      
TIME INSPECTION COMPLETED

What would be the best way to do this??

Thanks!!
0
Comment
Question by:HDM
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 100 total points
ID: 38751086
0
 
LVL 42

Assisted Solution

by:sedgwick
sedgwick earned 100 total points
ID: 38751143
i'd create winform with gridview control which binded to the table in your sql server DB.
the gridview will be editable so user can input new data for all fields.

add Submit button which submits all the data into your sql DB using table adapter.

check this code for example:
Insert, Update, Delete with DataGridView Control in C# (Windows Application)  
0
 
LVL 19

Accepted Solution

by:
Manoj Patil earned 100 total points
ID: 38751195
See this simple registration example with sample code
http://www.aspdotnet-suresh.com/2010/10/how-to-get-output-parameters-return-by.html
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 12

Assisted Solution

by:Jared_S
Jared_S earned 100 total points
ID: 38751483
Everyone's suggesting solutions that will work, but before you settle on a solution make sure you look at the details view control and/or forms view control (if you want to modify the layout of the form).

These two forms behave slightly differently than the gridview and will make for a more convenient user experience.

All you need to do to add any of these is just create a new webform.aspx file and add a sqldatasource control. If the data is all in a single table, you can click the advanced setting, and as long as your table has a primary key, VS will create the insert and update commands for you.

Next just drop your dataview/formview/gridview onto your form and select your sqldatasource as it's data source.
0
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 100 total points
ID: 38753589
To do that Link that table in MS Access and in that create form based on Link table using Wizard.
0
 

Author Comment

by:HDM
ID: 38758974
Lots of good direction here.  I will look over and return and report.

Thanks!!
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question