hi, this is kavita. i want to send data from my html table into sqldatabase(suppose I have 10 record with 5 colums).is it possible.
please help me.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mahesh ChandPosted Dec 18, 2006, 2:48 PM
Absolutely.
There are several ways to do it. First, you can use a DataSet and DataAdapter approach to use Update method of the DataAdapter to save changes.
Alternatively, you can loop through your HTML table, collect data in variables, and build a SQL statement "INSERT INTO".. off the variables and execute the statement.
If you are using SP approach, pass variables as parameters.
See ADO.NET section on how to use DataAdapter, SQL statement, or stored procedures.