Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Running stored procedures/copying results in VB.net
Message
 
 
To
21/09/2011 14:21:57
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01524129
Message ID:
01524189
Views:
45
>>>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.
>
>That I did read and I used that in the code:
>
>
SQLCmd = New SqlCommand("StandardNamesCount", SQLCon)
>        SQLCmd.CommandType = CommandType.StoredProcedure
>        SQLCmd.ExecuteReader()
>
>But that's when I couldn't figure out how to copy it to the clipboard from there, or if it would even copy in a gridview type style like I'm trying to do.
>
>Then I also did the gridview method and had it fill, but again, no idea how to copy the contents from there.

Are you working with ASP.NET application or Windows forms? For the GridView Dataset is better - GridView will be based on DataSet.

I have some old working code in ASP.NET I can probably share, but it's not something I can explain in few words - although you may also find samples on the Web of how to make an application (ASP.NET or Windows forms) using GridView.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform