I am having a grid view which have 100s of record to insert in sql server data base for all checked check box of each row what is the best method to do this so that even performance won't degrade. If htere is some sql query for sql server 2005 please let me know