Copying SP results to clipboard

[ohok]

This is kind of a two part question. I'm trying to make a very simple automated program that will run two stored procedures (one that updates, one that displays the new results) and then copies the results to the clipboard and pastes it in a new e-mail. I already have the e-mail generating and grabbing whatever is on the clipboard, but I need help with the store procedures.

Every guide I look at on Google seems to show a slightly different way of working with SQL, but I threw this together and need to know if it's working. I don't get any errors and the program "hangs" about as long as it takes for the actualy SP to run, but how do I get the "rows affect" output into a textbox or something?

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

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

[mf12]

ExecuteNonQuery() will return the number of rows affected.
Just save it in a variable and use it to set your textbox's text, copy it to clipboard, or whatever.

[techgnome]

well.... if you read the documentation for ExecuteNonQuery you would find that it states:

Executes a Transact-SQL statement against the connection and returns the number of rows affected.

(emphasis added)

-tg

[ohok]

I know ExecuteNonQuery returns the number of rows affected, apparently I had a brain fart as to how to get it in the text box. Thanks.

The bigger question is the second SP, having it copy the results to the clipboard...

[ohok]

I used this for the second SP:

SQLCmd = New SqlCommand("StandardNamesCount", SQLCon)
        SQLCmd.CommandType = CommandType.StoredProcedure
        SQLCmd.ExecuteReader()

The end goal here is to not even see the results, just have them generate in the background and get copied to the clipboard. I also put a GridView on the form and can see the data, but I have no clue how to copy it via code.

[mf12]

It's pretty easy to do with a DataGridView, try this:

DataGridView1.SelectAll()
        Dim content As DataObject = DataGridView1.GetClipboardContent()
        Clipboard.SetDataObject(content, True) '2nd argument makes the data available after the app exits

[ohok]

Funny, I just stumbled upon that myself, only I did it a little differently:

Me.StandardNamesCountTableAdapter.Fill(Me.TBLMasterDataSet.StandardNamesCount)
        Me.DataGridView1.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText
        Clipboard.SetDataObject(Me.DataGridView1.GetClipboardContent)

I just came back to ask how to select it all, but looks like yours does that I'll try it and let you know.


EDIT: Yep, that works great, thanks.

One other small thing, any ideas about a progress bar? I know it's hard to make an accurate one so I was going to do the Marquee style, but as soon as the form loads, the bar is already moving.

Bah, never mind, I'll just make the cursor do the circle waiting thing.