insert the bulk records to the table using loop

i have a table called 'studentdetails'. i dont want to insert the record one b开发者_StackOverflow社区y one during button click,instead i want to insert some hundred records using looping statement.Any idea??

If you are using .net then using DataSet's AcceptChanges() you can achieve this.

This url shows you an example http://msdn.microsoft.com/en-us/library/system.data.dataset.acceptchanges.aspx