>>>>

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.
>>>
>>>The above is not very good example. Try this one (first result in BING):
>>>http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx
>>>
>>>Using Google also doesn't seem to bring good VB.NET examples - all examples I found so far were C#. Anyway, another one
>>>http://www.codeproject.com/KB/cs/simplecodeasp.aspx
>>
>>
>>The second link was pretty badly formatted and looks to have incorrect code in places, but I mixed and matched some stuff and came up with this:
>>
>>

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?