All I need to do is add one record to one SQL table using a VB.NET form and I'm getting very frustrated because I'm used to the simplicity of VFP's SQL PassThrough.

I don't need to display the contents of the table with Next, Previous etc.

My VB form already has a Connection, a DataSet, a BindingSource and a TableAdapter, none of which I can get to do what I want.

Worst comes to worst, I can write my data out to a disk file and read it into the SQL table by invoking a stored procedure that uses OPENROWSET with BULK, but there must be a better, easier and for me, simpler, way.

Thanks,
David.