Procedure support in sql server

English Forum
1

Hi i need help to use sql server procedure to create reports is it supported can you help me to get one example.

thankyou for the help.

2

Dear Parson,
thank you for your note.

Below is sample code for using stored procedure´s in this sample we use our DbCommandSetDataProvider():

[code]SqlConnection mConn = new SqlConnection(“connectionString”);
mConn.Open();
SqlCommand mCommand = new SqlCommand(“YourStoredProcedureName”, mConn);
mCommand.CommandType = CommandType.StoredProcedure;
mCommand.Parameters.AddWithValue(“ParamName”, “Value”);

        combit.ListLabel20.DataProviders.DbCommandSetDataProvider prov = new combit.ListLabel20.DataProviders.DbCommandSetDataProvider();
        prov.AddCommand(mCommand, "Table1");

        combit.ListLabel20.ListLabel LL = new combit.ListLabel20.ListLabel();

        LL.DataSource = prov;
        LL.Design();[/code]

For further information about our providers, we would recommend to look into the .NET Help and by watching our .NET samples.

Kind regards

Erdal Alacali
Technical support
combit GmbH