Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I just INSERT a new record into a SQL table?
Message
From
04/06/2007 04:31:26
 
 
To
03/06/2007 19:54:22
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
01230092
Message ID:
01230143
Views:
19
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform