+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Procedure support in sql server

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.

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

© combit GmbH