Stored Procedures in .NET

[sonyasam]

hi everyone:

Do anyone know how to create stored procudure of sql server in
vb.net IDE?

I tried in the Server Eeporer windows, after i creating a data
connection, i able to view the tables,views and stored
procedures ,but when i right-click "stored procedures", I can not
get the "New Stored Procedure" sub menuitem, what is the
reason? and i can't edit the exist stored procedure in
vb.net.

Can anyone give me a help?


Dora

 

[rowe_newsgroups]

hi everyone:

Do anyone know how to create stored procudure of sql server in
vb.net IDE?

I tried in the Server Eeporer windows, after i creating a data
connection, i able to view the tables,views and stored
procedures ,but when i right-click "stored procedures", I can not
get the "New Stored Procedure" sub menuitem, what is the
reason? and i can't edit the exist stored procedure in
vb.net.

Can anyone give me a help?

Dora

Why not just use Enterprise Manager?

Thanks,

Seth Rowe

 

[Mr. Arnold]

hi everyone:

Do anyone know how to create stored procudure of sql server in
vb.net IDE?

I tried in the Server Eeporer windows, after i creating a data
connection, i able to view the tables,views and stored
procedures ,but when i right-click "stored procedures", I can not
get the "New Stored Procedure" sub menuitem, what is the
reason? and i can't edit the exist stored procedure in
vb.net.

Can anyone give me a help?

You use SQL Server's Enterprise Manager. The IDE can't do everything.

 

[sonyasam]

Thanks Seth Rowe and Arnold for the help.It worked...