>>>

SQLCon.ConnectionString = "Data Source=server;Initial Catalog=database;Integrated Security = True;"
>>>        SQLCon.Open()
>>>        SQLCmd = New SqlCommand("StandardNamesUpdate", SQLCon)
>>>        SQLCmd.CommandType = CommandType.StoredProcedure
>>>        SQLCmd.ExecuteNonQuery()
>>>        SQLCon.Close()
>>>

>>>
>>>When I run the program it pauses about as long as it takes for the SP to run in SQL Server, and then my e-mail is generated so it may be working. Now I need a way to check to see if it's working for sure, can I assign it to a text box and have it show me the number of rows affected? After that, how do I get it to copy the results of the second SP so I can have it pasted into the e-mail?
>>
>>You may want to do a bit more reading on ADO.NET methods and go through examples in MSDN. I made another quick Bing search, found this link that provides more links - you may want to start from them
>>http://wonald.com/ado-net-performance-executereader-vs-executenonquery-vs-executescalar-93.htm
>
>Well I found out my code is working for the update SP, it shows me the same number of affected rows as when I run the SP manually. Now all I need to do is run the second SP so that it's able to be copied like the grid view in SQL Server... I looked at your link but didn't find any examples for that, partly because I don't know exactly what it's called.
>
>Can you control that stuff in VB? Have it output to some sort of unseen gridview and then copy it?

To get result as dataset you can use two main methods - first is to ExecuteReader (this was in my link - I put comparision between 3 main methods) and second approach is to create dataset and use its Fill method to fill it with data.

Start from reading on ExecuteReader.