?
Solved

best way to write into database

Posted on 2011-02-19
3
Medium Priority
?
260 Views
Last Modified: 2012-05-11

What is the best method to write data from a Web form into a table or database?
Currently I'm thinking of using stored procedure to write into and read from a table specially since there will be no way of SQL injection.

Is this a right approach? or there are better practical idea?

Thanks.
0
Comment
Question by:akohan
[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
3 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 800 total points
ID: 34934847
Stored procedure is the best practice as it allows for better maintenance and protects from sql injection attacks.
0
 
LVL 16

Assisted Solution

by:BurnieP
BurnieP earned 200 total points
ID: 34934866
Like Jacko said,  you cannot go wrong with Stored Procedure for it's effiency and security.

If you are familiar with Linq, it can also be a valid option.
0
 

Author Comment

by:akohan
ID: 34934945

Thanks.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

752 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