how to pass the data from dataset to CR?
i write a stored procedure for fetching a particular field on my database which look like this:
CREATE PROCEDURE [dbo].[TOC_Branch_Address]
@BID VARCHAR (50)
from S_TOC_Branch S
where S.Branch_ID = @BID
the application is like this: everytime the branch login, they will own their unique branch ID, then now i want to use the SP to fetch the address and pass the value print at my report header.
the problem i faced now is : how to pass the branch id using data adapter to my report (@BID)?
i using data adapter for this
daAddress.SelectCommand.CommandText = "TOC_Branch_Address" ;
daAddress.selectCommand.CommandType = CommandType.StoredProcedure;
so, i assume it will fetch my banch address according to @BID, so now how to move to the crystal report??