how to use visual studio 2008 to send network packets to database

[that_dude_tj]

i was able to send packets from my traffic generator to the pc, inorder for me to confirm the packets were sent i used wireshark as a visual aid. from there i saved the file as cvs and then paste data into excel sheet. once in this format i was able to do a stored procedures which put the data in a sql database. now i know there has to be a better way to both read and write captured packets to ANY database. any suggestions with steps

[realJSOP]

Instead of doing all that middle code (create a cvs file), why don't you buffer the records in memory and call a stored proc to add the data as it's received? One thread plugs the data into the buffer, and one thread pulls it out and puts it in the database.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[that_dude_tj]

ok imma give that a try thanks

[that_dude_tj]

I am not sure how to buffer the records in memory from.., i can you explain how

[realJSOP]

Create a stack of data objects, and push new ones onto the stack, and pop old ones off.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001