How to fill stored procedure in dataset.

jayaraj · July 14th, 2004, 04:09 AM

hi,

I can fill the stored procedure(with out parameters) in the dataset using dataset controls, But I want to fill
the stored procedure with parameters, I did't get it. Is it possible?
How? Because I want to create a crystal Reports using stored Procedure with parameters.

Thanx

By
Jayaraj.

bmains · July 14th, 2004, 05:04 PM

Hey,

You can set the stored procedure parameters for the data adapter, as such:

objadapter.selectcommand.parameters.add("@param", SQLDbType.Int, 10).Value = <value or variable>

You can use parameters, although through a typed data adapter, I don't know how. You may have to edit it manually.

Brian

xiongyong · July 14th, 2004, 10:53 PM

Yee! I agreed!

mahabat · August 2nd, 2004, 02:40 AM

set rs = cn.execure ("storeprocedur")

mahabat · August 2nd, 2004, 02:40 AM

Report.Database.SetDataSource rs