Hello,

I'm working on a WindowsService using VB.NET that monitors a serial port and places data in a database. The problem is a lot of data can build up in this database. I was wondering if there is a way to add a row to a table without first filling a dataset, adding the row then updating the table. I've clocked it and it starts taking some time to load the table into the dataset each time, not to mention all the memory it eats up. I believe this is causing my program to crash.

Thanks for your help.

Will

why you work with dataset,you can directly deal with your datasource ,use CommandObjects(like SqlCommandObjects) and it's ExecuteNonQurey() method.
dont work with dataset object.
HtH.

--------------------------------------------
Mehdi.:)