Hi,
I am trying to execute a parameterized command as follows:
***********************************************
cn.Open()
Dim sql As String = "Select creditlimit, vatcode from customers where Name = @v_name "
Dim cmd As New System.Data.SqlClient.SqlCommand(sql, cn)
cmd.Parameters.Add("v_name", "test")
Dim dr As SqlClient.SqlDataReader = cmd.ExecuteReader
dr.Read()
cn.close()
*************************************************
I am getting an error at the statement
Dim dr As SqlClient.SqlDataReader = cmd.ExecuteReader
as
*********************************************
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
***********************************************
It doesn't seem to have accepted the parameters.
Please let me know what mistake I am doing in the above declaration.
Thanks & Regards,
Shailaja
