Click here to Skip to main content
15,499,430 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     CRLF
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     CRLF
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     CRLF
Reason for my vote of 2 Extremely basic info