Finally, got a chance to build an image using Visual Studio 2005 Beta 1. While writing some code I ran across something that I hadn’t seen in any of the documentation that I have read so far. I would typically use the following line to add a parameter to the SQL Command object.
sqlCmd = New SqlCommand
With sqlCmd
.Connection = sqlConn
.CommandTimeout = 30
.CommandType = CommandType.StoredProcedure
.CommandText = "spInsertFeedback"
.Parameters.Add("@EvaluatorName", EvaluatorName)
End With
According to the Intellisense that popped up, the Parameters.Add functionality has been made obsolete and now becomes.
sqlCmd = New SqlCommand
With sqlCmd
.Connection = sqlConn
.CommandTimeout = 30
.CommandType = Data.CommandType.StoredProcedure
.CommandText = "sp_GetCompanyName"
.Parameters.AddWithValue("@CustomerID", CustomerID)
End With
8:38:25 PM
|