How to save Datatable records into database using single server trip

Is there any way of saving all the records of a DataTable to database , with a sin开发者_运维百科gle call to database?

---

if you are using DataSet you could use DataAdapter.Update Method

http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update.aspx