Question about SqlCommand.Parameters.Add() method.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pedestrian - 30 Aug 2006 08:44 GMT

I'm currently programming an ADO.NET application for SQL server.
I notice that the SqlCommand.Paraterers.Add() method require 4 parameters
which are parameterName, SqlDbType, Size, and SourceCOlumn. The question is
with Size parameter:

What is the corrent Size value for SqlDbType.Int, SqlDbType.Money and
SqlDbType.Real? I'm adding those type to the method.

Thanks...

Signature

Regards,
Pedestrian, Penang.

Reply to this Message

Otis Mukinfus - 30 Aug 2006 12:18 GMT

>I'm currently programming an ADO.NET application for SQL server.
>I notice that the SqlCommand.Paraterers.Add() method require 4 parameters
[quoted text clipped - 5 lines]
>
>Thanks...

If you use this overloaded method the length will be provided:

public SqlParameter Add (string parameterName,
SqlDbType sqlDbType)

or you can use the AddWithValue method:

public SqlParameter AddWithValue (string parameterName,
Object value)

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

Reply to this Message

pedestrian - 31 Aug 2006 01:18 GMT

Thanks for replying, Otis.

I'm using the 4 parameters overload method because I like to specify the
SourceColumn (in Sql server).
I found that Sp_help in Sql Server give the length of the type, is the length
the answer to the Size value in SqlParameter.Add method?

Signature

Regards,
Pedestrian, Penang.

Reply to this Message

Otis Mukinfus - 31 Aug 2006 10:33 GMT

>Thanks for replying, Otis.
>
>I'm using the 4 parameters overload method because I like to specify the
>SourceColumn (in Sql server).
>I found that Sp_help in Sql Server give the length of the type, is the length
>the answer to the Size value in SqlParameter.Add method?

Yes. Please excuse my poor choice of words :o)
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

Reply to this Message

William (Bill) Vaughn - 31 Aug 2006 18:44 GMT

When the overloads don't have the right mix of property settings we have to
resort to multiple property set operations. You might just try setting the
length to the size of the Integer as stated in the help or 0. I expect it's
ignored anyway.

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

> Thanks for replying, Otis.
>
[quoted text clipped - 3 lines]
> length
> the answer to the Size value in SqlParameter.Add method?

Reply to this Message

pedestrian - 01 Sep 2006 00:45 GMT

Thanks Otis. All to best to you...

Thanks William. I guess you are right. I did set the Size to 8 for SqlDbType.
Int unintentionally and
it don't show me the error...

Have a nice days, guys.

Reply to this Message

Question about SqlCommand.Parameters.Add() method.

Free Magazines