Create Stored Procedure and modify table property in VB.Net & SQL

[Guest]

1. How do i create a stored procedure in VB.Net and then execute it in VB.Net?
2. How do I modify a table property in VB.Net?

 

[rowe_newsgroups]

1. How do i create a stored procedure in VB.Net and then execute it in VB.Net?

You have to use Sql to create a stored procedure, generally through a
tool such as Query Analyzer or the Management Studio (for Sql Server
at least). To execute it you will need to use ADO.NET, the best place
for you to learn about how to use ADO.NET is to do some searching on
google for some tutorials.

2. How do I modify a table property in VB.Net?

Again you'll probably want to use a tool such as Sql Server Management
Studio to do the modifications. You can however use with direct Sql
statements passed via ADO.NET through visual basic code, but the GUI
environment of the management studio would (imo) be much easier.

Thanks,

Seth Rowe

 

[Guest]

Seth,
Thanks for suggestions.
I am looking for VB.Net sample code.

 

[rowe_newsgroups]

Seth,
Thanks for suggestions.
I am looking for VB.Net sample code.

All will require using Sql statements sent using ADO.NET, if you
search google like I suggested you should be able to find whatever you
need.

Thanks,

Seth Rowe

 

[Cor Ligthert[MVP]]

Ryan,

I thought that this was depending the version, however in VS version 2005,
(I thought that this was not in the express version).

Open your server explorer
Make a connection to the datatable
Open Programmability
Open in that by right clicking Stored Procedures, then you get a template
what shows the most used stored procedure structure in VB.Net

Cor