|
Subject:
|
Insert data row in SQL SERVER 2000
|
|
Posted By:
|
dimeanel
|
Post Date:
|
1/25/2006 6:32:11 AM
|
I have SQL procedure made in SQL Sever 2000, this procedure insert data strings into SQL table. I can not write VB.NET code which will take same data strings from text box in windows forms and running SQL procedure put it in new row in SQL server table.
|
|
Reply By:
|
planoie
|
Reply Date:
|
1/25/2006 8:32:19 AM
|
Usually, you create a SqlCommand object, set the command text to the stored procedure, set the command type to the Procedure enum then create the necessary parameters on the command object to represent the procedures parameters.
Here's the MSDN article on the SqlCommand class:
http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlCommandClassTopic.asp
-Peter
|
