Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Running stored procedures/copying results in VB.net
Message
 
 
To
21/09/2011 09:25:07
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01524129
Message ID:
01524133
Views:
57
>I'm trying to automate a task here. Right now I have to run two SPs (one updates a table, the other displays the table), copy the data from the second one, and paste it into an e-mail to send to numerous people. I took care of generating the e-mail, but I need help running the stored procedures. I don't need to see the data anywhere, I just need them both to run and have it copy the output automatically.
>
>I tried Googling but I keep seeing a bunch of different ways to execute a store procedure. I started off with this but then saw examples that were way more involved, so I didn't think this was the right start:
>
>
 Dim SQLCon As New SqlClient.SqlConnection
>        SQLCon.ConnectionString = "Data Source=name;Integrated Security = True;"
>        SQLCon.Open()
I think you're on the right track if you want to use ADO.NET. Usually you don't specify connectionstring in the app directly, you read it from the config file. For now it will be OK. So, just use the sample you found - you need to add creation of the command object, parameters and then use ExecuteNonQuery method of the Command object.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform