SQL Stored Procedure

[rkmeena]

Hi............

How can i pass and access the array variable in Stored Procedures

[bLuEmEzzy]

show us your code... tnx

[rkmeena]

Here is my code..

CREATE PROC SP_GetList
@SNo[10] INT
AS
DECLARE @i INT
BEGIN
WHILE @i <> @SNo
BEGIN
SELECT * FROM LIST WHERE SNo=@SNo
@i=@i+1
END
END

[bLuEmEzzy]

dt = New DataTable
            SQLCmd = New SqlCommand
            With SQLCmd
		  .Parameters.AddWithValue("@SNo", ObjectSNo)
                .Connection = YourConnection
                .CommandType = CommandType.StoredProcedure
                .CommandText = "YourStoredProcedureName"
                dr = .ExecuteReader
                dt.Load(dr)
            End With
            YourConnection.Close()
            YourConnection.Dispose()