I want to find out how to set the parameters (In / Out) and execute a SQL
Server Stored Procedure using the following 2 methods in .Net environment
using ADO.Net.

1. ADOCommand / ADOConnection

2. SQLDataSetCommand / SQLConnection

The Stored Procedure will have In / Out parameters and return data
(records). It will have the following structure:

Select * From MyTable

The procedure also returns data from the statement (Select * From MyTable).

Thanks

Giri

Basically you create a connection first, then create the SQLDataSetCommand
on that connection, add parameters one by one and set their direction, data
type. Finally create a dataset or datatable and fill them with the result
returned from stored proc.

check microsoft.public.dotnet.framework.adonet. or http://www.gotdotnet.com
There are many examples there.

- Chu

Giri

Below is some code for you. It only demonstrates 'In' params. I hope it
helps.

Jonny

----------
    Private mSQL As SQLDataSetCommand

    'Stored procedure parameter names


    Private Const TABLE_NAME = "tblMember"
    Private Const SQL_CONNECT =
"server=localhost;PersistSecurityInfo=false;User ID=sa;database=MyDBName"

    Public Sub New()
        MyBase.New()
        'Create the DataSetCommand
        mSQL = New SQLDataSetCommand()
        mSQL.TableMappings.Add("Table",TABLE_NAME)
    End Sub

    Public Function GetMember(ByVal LogName As String, ByVal LogPassword As
String) As MemberData
        Dim Data As New MemberData()
        Dim SPROC As New SQLCommand("GetMember", New
SQLConnection(SQL_CONNECT))

        'Initialize the parameterized SPROC command object
        With SPROC
            .CommandType = CommandType.StoredProcedure
            'Attach SPROC parameters
            .Parameters.Add(New SQLParameter(PARM_LOGNAME,
SQLDataType.NVarChar, 50))
            .Parameters.Add(New SQLParameter(PARM_LOGPASSWORD,
SQLDataType.NVarChar, 50))
        End With

        'Retrieves the Member
        With mSQL
            .SelectCommand = SPROC
            .SelectCommand.Parameters(PARM_LOGNAME).Value = LogName
            .SelectCommand.Parameters(PARM_LOGPASSWORD).Value = LogPassword
            .FillDataSet(Data, Data.TABLE_MEMBER)
        End With
        Return Data

    End Function