Hello,
I have a a website where I am executing a stored procedure in a SQL database. I have checked several threads on having parameters in code, but I am not able to get mine to work. I am not sure where I have gone wrong.
Here is my current code:
Protected Sub cmdSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdSubmit.Click
Dim strFromDate As String
Dim strToDate As String
Dim strProcCodes As String
Dim strICD9Codes As String
Dim strProvCodes As String
Dim cnn As SqlConnection
Dim cmd As SqlCommand
Dim rdr As SqlDataReader
Dim cnnString As String
Dim strOutputFile As String
Dim strPath As String
Dim strPathFile As String
txtMsg.Text = ""
txtMsg.Visible = False
strPath = "c:\Test\"
strOutputFile = Session("CurrentUser" ...
Go to the complete details ...