>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.