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

Procedure support in sql server


(Parson Sharma) #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.


(combit Support - Erdal Alacali) #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