calling store procedure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

calling store procedure

Author

Topic

Jayeeta Mitra
Starting Member

11 Posts

Posted - 2008-03-10 : 15:00:33

How can I call a store procedure created in my database from .Net?Pls help.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2008-03-10 : 15:25:21

You should try that new website Google, it is very cool.. you can search the whole internet!!

If you simply search for ".net stored procedure tutorial" this excellent article is the very first result:

http://www.developer.com/db/article.php/3438221

and here's more:

http://www.google.com/search?q=.net+stored+procedure+tutorial

Just out of curiosity, how do you come to discover SQL Team?

- Jeff
http://weblogs.sqlteam.com/JeffS

Jayeeta Mitra
Starting Member

11 Posts

Posted - 2008-03-10 : 15:45:59

just by searching google for some sql queries.anyway,thanks a lot

osirisa
Constraint Violating Yak Guru

289 Posts

Posted - 2008-03-12 : 12:47:56

Dim conString As String = "Data Source= "Your datasource- SQL Server" Security=SSPI;persist security info=False;"
Dim sql As String = "exec sp_Your Stored procedure name"
Dim sqlConnection As New SqlConnection(conString)
Dim sqlCommand As New SqlCommand(sql, sqlConnection)
sqlConnection.Open()
sqlConnection.Close()

Hope this help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources