>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.
I know how frustrating it can be when you are starting out. Bonnie gave you an example that should help you. Once you get it figured out, though, you can do some really cool stuff with it!