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