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()