Comments by PSU Steve

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.

Comments by PSU Steve (Top 7 by date)