SQLCmd is not recognized... what library does it need?

[ismirnov]

Hello,
I'm rather new to asp.net and vb.net. I'm trying to execute a stored procedure on itemdeleting event. When I use SQLCmd it is not recognized. What library should I include to make it work? Thanks so much!

 

[Menthos]

sqlCmd does not exist - sqlCommand does.

You may be getting confused when creating a new object instance - I personally use sqlCmd as my instance identifier e.g

Dim sqlCmd as New sqlCommand(sqlStr, sqlConn)

 

[ss7thirty]

Also note this is a member of System.Data.SQLClient

Dim sqlCmd As new System.Data.SqlClient.SqlCommand(strSQL, sqlCon)

 

[ismirnov]

Thank you so much! no wonder I couldn't find anything googling it....lol