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

As far as parameters go, neither SP has any, they just run as soon as you click "execute".

The example I was looking at told me to use CommandText as below:

Dim SQLCon As New SqlClient.SqlConnection
        Dim SQLCmd As New SqlCommand

        SQLCon.ConnectionString = "Data Source=name;Integrated Security = True;"
        SQLCon.Open()

        SQLCmd.CommandText = "Exec StandardNamesUpdate"
        SQLCmd.Connection = SQLCon

I don't think that's working though. I'll try to look into the ExecuteNonQuery method.