Can you show us what you already have?
It should be as simple as this:
SqlCommand sc = new SqlCommand("Insert into bob (xyz, abc) VALUES ( @xyz, @abc )", this.MyConnection);
sc.Parameters.Add("@xyz", MyTable.Rows[myrow]["xyz"]);
sc.Parameters.Add("@abc", MyTable.Rows[myrow]["abc"]);
sc.Connection.Open();
sc.ExecuteNonQuery();
sc.Connection.Close();
~~Bonnie
>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.