Stored Procedure m. parameter
Dette BURDE virke, right ??jf. eksemplet : http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx
Men jeg modtager et tomt "recordset" - dvs text ikke bliver sat til noget... min Stored Procedure er komplex, men ligner:
"SELECT * FROM tbl WHERE @a = a AND @b = b"
[VB.NET]
Conn = DButil.OpenConnection
cmd = New SqlCommand("spSurvey_GetComplete", Conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@lang", language_ID))
cmd.Parameters.Add(New SqlParameter("@SurveyID", quiz_ID))
Dim reader As SqlDataReader = cmd.ExecuteReader()
While (reader.Read())
Dim text As String = (reader("SurveyID") + reader(1) + reader(2))
End While