Sunday, July 11, 2004

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