>Bonnie,
>
>Thanks for the help. I made the adjustments shown below, but VB is now objecting to my connection at runtime with "The ConnectionString property has not been initialized" though I'm using the name of my connection "Smooth", and it is at least compiling now!
>
> Dim sc As New SqlCommand
> Dim Smooth As New SqlConnection
> Dim ReturnValue As Integer
> sc = New SqlCommand("INSERT INTO Pix (FirstName, LastName) VALUES (@xyz, @abc)", Smooth)
> sc.Parameters.AddWithValue("@xyz", TextBox1.Text)
> sc.Parameters.AddWithValue("@abc", TextBox2.Text)
> Smooth.Open()
> ReturnValue = sc.ExecuteNonQuery()
> Smooth.Close()
>
>Thanks again,
>David.
But really where is the connectionstring for Smooth? You're instantiating it as a new SqlConnection. If you have it static (shared I think in VB) then do not define there as a new SqlConnection.
Cetin