You need to convert the data to xml and you can use OPENXML to insert all the data to the table at once. Here is an nice article about that
[
^]
But becareful about how much data you are loading at once because if you are working on WPF application it's a windows application when all the data is loaded at once your system may throw out of memory exception. This defers from system to system as each system will have different configurations. so it's better to load data in chunks for Windows applications.