Member Avatar for rkmeena

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

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

  • 2 Contributors
  • 3 Replies
  • 73 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by bLuEmEzzy

Recommended Answers

All 3 Replies

Member Avatar for bLuEmEzzy

show us your code... tnx

Member Avatar for 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

Member Avatar for 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()
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.