Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

SQL input form

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
Curtis Long
Asked:
Curtis Long
5 Solutions
 
Éric MoreauSenior .Net ConsultantCommented:
0
 
Meir RivkinFull stack Software EngineerCommented:
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
 
Manoj PatilSr. Software EngineerCommented:
See this simple registration example with sample code
http://www.aspdotnet-suresh.com/2010/10/how-to-get-output-parameters-return-by.html
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Jared_SCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
To do that Link that table in MS Access and in that create form based on Link table using Wizard.
0
 
Curtis LongAuthor Commented:
Lots of good direction here.  I will look over and return and report.

Thanks!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now