Stored procedure error

[sakhi kul]

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...!

[sknake]

I can't see what you're doing wrong. I did the same thing and it works as expected:

IF OBJECT_ID('sp_Test', 'P') IS NOT NULL DROP PROCEDURE sp_Test
GO
CREATE PROCEDURE sp_Test
(
  @id int
)
AS
BEGIN
  Select * From sysobjects
END

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
		Dim conn As New SqlClient.SqlConnection("Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;")
		conn.Open()
		Dim cmd As New SqlClient.SqlCommand("sp_test", conn)
		cmd.CommandType = CommandType.StoredProcedure
		cmd.Parameters.Add(New SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int)).Value = 1
		Dim dr As SqlClient.SqlDataReader = cmd.ExecuteReader()
		Dim dt As New DataTable()
		dt.Load(dr)
		dr.Close()
		cmd.Dispose()
		conn.Dispose()

		MessageBox.Show(dt.Rows.Count.ToString())
	End Sub

See if that works and then compare it against your code.

[Ramesh S]

Hi sakhi kul,

Post full VB.NET code. It will help to identify the issue.

Are you putting the above VB.NET code segment in a For loop?

Where do you fill your data set. after for loop?

[sakhi kul]

Hi , I am developing a Centralized Admission System in which Students fill their entrance form & collages will provide theirs information about all reservations seats etc.
After entrance result will declared & allotments based on these merit list & merit number. Student fill option form in which he/she gives 5 options of collages where he/she want to take admission.

The error comes in this allotment process...

I have following tables
1.collage_detail( I mainly deal with sc,open,vj.. seats)
2.student_deatail( In this process cast is imp. , s_id is primary key)
3. option list(opt1,opt2,opt3,op4,op5 : collage id student opt for..)
4.result(mainly mertinumber is imp)

So firstly i retrieve all information regarding allotment like student cast, & I want to check weather this cast seats are available in particular collages for which student opt,
I write code in while loop which run 5 times( If student get allotted in first option then loop will break)

when I run above code 2 time the error occurred at datareader
I am using same command object & connection object.Is this the reason of error..?

cmd.commandtext="SELECT * FROM collage_detail WHERE c_id=@opt1"

 While i < 5
                    Dim ot As Integer = op(i)
                    cmd.Parameters.AddWithValue("@opt1", op(i))

                    ' cmd.Parameters.Add("@cid", SqlDbType.Int).Value = ot

                    'cmd.Parameters.AddWithValue("@sid", sid)
                    Dim readcounter As SqlDataReader = cmd.ExecuteReader()
                    readcounter.Read()

                    Dim avseat As Integer = readcounter(0)
                    If avseat > 0 Then
                        Dim adcon As String = "INSERT INTO allotement(s_id,c_id) VALUES(@sid1,@c_id)"
                        cmd.CommandText = adcon
                        Dim con3 As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\CAP.mdf;Integrated Security=True;User Instance=True")
                        con3.Open()
                        cmd.Parameters.AddWithValue("@c_id", op(i))
                        Dim s As Integer = r("s_id")
                        cmd.Parameters.AddWithValue("@sid1", s)

                        cmd.Connection = con3
                        cmd.ExecuteNonQuery()

                        chk = 1
                    Else

                        i = i + 1
                    End If
                    '  opt1 = r("opt2")

                    If chk = 1 Then
                        i = 5
                    End If
                End While

I run above code many times ( and in this code i didn't use stored procedure) but it gives me error that "Bad Request"
Please Reply!