Updating a Database

Question

User-2035247695 posted

How would you update data in an SQL database from a webpage using ASP.NET in C#? The SQL database uses a stored procedure with one table. Would you provide a code example when replying? <o:p></o:p>

Answer 1

User1293050055 posted

http://www.codeproject.com/Articles/414272/Stored-Procedures-DO-NOT-increase-performance

http://www.codeproject.com/Articles/39161/C-and-Table-Value-Parameters

http://msdn.microsoft.com/en-us/library/bb675163.aspx

Answer 2

User-134477160 posted

How would you update data in an SQL database from a webpage using ASP.NET in C#?

TableAdapter?

EF?

LINQ-TO-SQL?

Answer 3

User-166373564 posted

Hi,

If your stored procedure returns values that need to be sent back to the client (for example, values calculated in the stored procedure), create output parameters in your stored procedures. Members mapped to database-generated values need to be set to appropriate values after successful completion of INSERT or UPDATE operations.

You can learn how to assign stored procedures to perform updates, inserts, and deletes here.

you can also learn how to use ajax for updating database from client side here.

I think it will be give a good guide for you.

With regards