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.
| Author |
Topic |
|
kenone
Starting Member
14 Posts |
 Posted - 2006-03-07 : 03:21:52
|
| I have created a stored procedure(using Query Analyser) in SQL Server and I want to call it in my VB.NET program...How can I do it???please help |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-03-07 : 03:50:09
|
| go thru this linkhttp://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/VB_DOT_NET/Q_21415723.html |
 |
|
|
bhar
Starting Member
9 Posts |
Posted - 2006-03-24 : 05:26:06
|
| Hi,I will give few lines of sample code.Dim str_con As String ="Data Source =SYS1;Integrated Security=SSPI;Intial Catalog=FinAccounting"Dim comSelect As SqlCommandmycon=New SqlConnection(str_con)comSelect=New SqlCommand("GetAccounts",mycon)comSelect.CommandType=CommandType.StoredProcedureSo, GetAccounts is the stored procedure we need to write.Try this title: "Database Programming Using VB.Net and Sql server"by VK publishers. http://www.vkinfotek.comRegardsBhar |
|
|
|
|
|
|
call a stored procedure in vb.net