|
Subject:
|
Creating stored procs with VB.NET
|
|
Posted By:
|
ninel
|
Post Date:
|
8/16/2006 1:30:10 PM
|
I have to create databases and stored procs based on a user's prompt through a web page.
Is there a way to create a stored proc within VB.NET?
Thanks,
Ninel
|
|
Reply By:
|
connect2sandep
|
Reply Date:
|
8/18/2006 3:56:50 PM
|
yes u can deploy a .net assmbly which can act as a sql server stored procedure in any .net language . it is similar to basic ado.net code with only difference that the connection object has a context =true in connection string. for more refer to sql server books online and msdn. u must use sql server 2005 and .net framework 2.0.
|
