AR
Anupama Roy
Syncfusion Team
January 16, 2006 01:42 PM UTC
Hi Tom,
After setting up the command type and passing the parameters required for the stored procedure,have you specified any input/output parameter?
Since you have just given a part of your code,I am not able to reproduce this issue here.Please try replacing your similar statement with the below given code snippet and see how it goes.
Dim parm As SqlParameter
parm = UpDateStudent.Parameters.Add(New SqlParameter("@ProgID", SqlDbType.VarChar, 10))
parm.Direction = ParameterDirection.Input;
UpDateStudent.Parameters("@ProgID").Value = ProgID
Since the Data Retrieval with stored procedures is the same as using standard SQL,I believe that the error is with either setting the query string or with the CommandType.
Also please let me know whether you get the same error when you try binding with a .NET ComboBox?
Thanks,
Anu.