What is the most efficent way in ADO.NET to add every row in a datatable to a table in SQL?<BR><BR>For example, I have a list of tasks in an excel spreadsheet. I load it into a datatable, and now want to enter each of those tasks into the Tasks table in my SQL server.<BR><BR>I know a few ways to do it now, but I&#039;m new to .NET and figured I&#039;d try and learn the "right" way.<BR><BR>Thanks!