Hi to all ,
I am developing website in asp.net2.0 using VB.
I wrote sored procedure,
ALTER PROCEDURE SELECTSC ( @cid INT ) AS BEGIN SELECT sc FROM collage_detail WHERE c_id=@cid END /* SET NOCOUNT ON */ RETURN
and in vb I wrote on button click,
cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "SELECTSC" 'ot contains integer value Dim ot As Integer = op(i) cmd.Parameters.Add("@cid", SqlDbType.Int).Value = ot
while running application it gives me error that Function or procedure SELECTSC too many arguments specified.
In collage_detail table I want value in sc column as per the c_id(collage id) . I will provide collage Id from array in while loop.
because I want to check for 5 different collages.
please give me any solution...!