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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to call stored procedure by using VirualStudio

Author  Topic 

debradeng
Starting Member

46 Posts

Posted - 2006-10-23 : 03:46:07
I have created some SP by using SQL Server 2005,now I want use them instead of Dynamic SQL in one project.How to implement the process?

Thank you!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-23 : 03:48:42
Can you give us more informations? When you say I want use them instead of Dynamic SQL in one project did you mean How do I call those sps from application?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

debradeng
Starting Member

46 Posts

Posted - 2006-10-23 : 03:53:07
By using Visual Studio,I can see the tables and views,and in table adapter,I can see those queries.Now I have created SPs by using those SQL queries,how to replace them into existing SPs?

Do I make myself clear?

What is your suggestion,madhivanan?
Go to Top of Page

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-10-23 : 09:03:58
ADO.NET is your friend. http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/ADOPlusOverview.aspx

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page
   

- Advertisement -