The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
