sql server table update

[clyde11]

Hi all,
first, I'm quite new to C#/asp.net/sql-server...

now, i'm writing an asp.net web application using c#,
(Visual studio 2003)
in some point i want to give the user an option
to update rows in a sql-server table,

i'm kind of don't really know what is the best way to attack this issue,
should I’ll get parameters from a box and parse them into an update query,
should I’ll right a stored procedure that gets arguments and will update the table ?
or should i do it (if possible) through a data set I’m using,
besides, is there any common/popular/build in .net way of updating a table ?


Best,
P.

 

[Walid]

Yes there is common/popular/build way in .net to update (deal with, in general) Databases. It is called ADO.NET.

The data must come in a DataTable ( or DataSet if you need 2) let the user change whatever and send it back through a DataAdapter's Update method. If you are new to this subject, you can save yourself a lots of frustration and read a good .NET tutorial. C# Step By Step is a very good one. Good luck

Walid Magd (MCP)

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch