I am fairly new to ASP.net having started with version 2. I have mostly used
the DataSource controls for manipulating data but i now need to some data
using ADO.net instead and a stored procedure in the SQL server database. As
far as i can work out, in order to insert a new row using ADO.net i need to
retreive the data base table into a datatable object, insert the row into the
DataTable and then run the update method of the DataAdapter object. So long
as i have a suitable DataCommand object and associated parameters set to the
InsertCommand property of the DataAdapter object then is will do the
business. This seems a very inefficient way to add a row to a table, it is
for an order entry system there are liekly to be hundreds of orders a day
entered. I don't want to have to read the whole orders table from the
database in order to just add a new record, so:
Is there a way to do this the doesn't involve me having to read anything
into a DataTable object, i.e. can i just create one with the relvent fields
etc and then add one row to it and then propagate this back to the DB in the
same way i would if i filled it from the DB.
If not would there be any problems with reading a very small subset of the
table into a datatable object and then using this to update the database
table, in other words will this delete all ther records in the database that
are not in the DataTable object.