how to do complex validation on huge volume of records before inserting into table..please see the explained scenario and suggest ideas

I think you can implement this using a stored procedure. you can capture full modifications done through grid and pass it using single database call on clicking the save. You can use table valued parameter to pass table of values or pass them as XML.

see

http://www.sommarskog.se/arrays-in-sql-2008.html

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page