Unable to add SqlParameter to SqlCommand

Question

This is a strange one to me.

The signature of the Add parameter method requires a SqlType but when I use that

//Create and open a connection to SQL Server 
SqlConnection connection = new SqlConnection(DatabaseHelper.ConnectionString);
connection.Open();

//Create a Command object
SqlCommand command = new SqlCommand( "stpInsertFile", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@LastMod", System.Data.SqlTypes.SqlDateTime);

it shows this error:

'System.Data.SqlTypes.SqlDateTime' is a 'type', which is not valid in the given context

Rowland Shaw · Accepted Answer · 2014-10-01 16:14:36Z

3

You should be using the SqlDbType enumeration, not SqlTypes so, something like:

command.Parameters.Add("@LastMod", SqlDbType.DateTime);

answered Oct 1, 2014 at 16:14

Rowland Shaw

38.2k15 gold badges104 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David · Accepted Answer · 2014-10-01 16:14:58Z

3

You're adding a SqlType (which is just a type) but the Add method expects a SqlDbType (which is an enum):

command.Parameters.Add("@LastMod", System.Data.SqlDbType.DateTime);

answered Oct 1, 2014 at 16:14

David

221k42 gold badges245 silver badges337 bronze badges

1 Comment

JohnnyBizzle Over a year ago

Ok thanks for the explanation. I think I was staring at the screen too long!

tbddeveloper · Accepted Answer · 2014-10-01 16:14:42Z

1

The signature you're looking at is Add(string,SqlDbType),that isn't SqlType. You're using the wrong type there. You should be using SqlDbType

Or as Christos mentioned, you can give it the value and have it figure things out.

answered Oct 1, 2014 at 16:14

tbddeveloper

2,4571 gold badge23 silver badges42 bronze badges

Collectives™ on Stack Overflow

Unable to add SqlParameter to SqlCommand

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related