Click here to Skip to main content
14,934,046 members

Comments by PSU Steve (Top 7 by date)

PSU Steve 20-Jan-16 15:26pm View
   
If you can use 3rd party controls/components, you'll probably have better luck. We use Infragistics NetAdvantage controls in our WinForms application and their Excel engine allows us to do exactly what you're after.
PSU Steve 31-Jan-14 13:18pm View
   
Reason for my vote of 2 \n There's nothing here! The subject holds promise, but the lack of anything meaningful in this article, and the lack of an example or source, makes it near useless right now.
PSU Steve 6-Jan-12 16:14pm View
   
Deleted
I've always used the Add(String, SqlDbType) overload of the SqlParameterCollection.Add method so I can specify the parameter type.

e.g. .Parameters.Add("@MyField", SqlDbType.VarChar).Value = MyObject.MyProp

Is there a performance hit with AddWithValue since .NET or SQL ( I would think it's SQL) has to determine the type of parameter? If not, how about a "Set" method that first checked the SqlParameterCollection to see if a named parameter has already been added. If so, it sets the value. If not, it adds the parameter and sets the value. Eliminates the loop issue discussed in the previous comments. I might give that a try one of these days.
PSU Steve 2-Feb-11 8:53am View
   
Deleted
Reason for my vote of 5
Cool. Much better than my workaround of putting a flag-file in the BIN directory. Thanks!
PSU Steve 15-Nov-10 16:52pm View
   
Deleted
Reason for my vote of 2
Extremely basic info
PSU Steve 12-Oct-10 11:18am View
   
Deleted
Simple, yes, but way cool. I have to kick myself in the behind for not thinking of this. I have MessageBox code all over the place in my app. I'll be replacing it bit-by-bit with this. Thanks!!!
PSU Steve 14-Sep-10 9:42am View
   
Deleted
Reason for my vote of 1
I can't imagine there is anyone who doesn't know this.