C# Programming
02-15-2010, 10:03 AM
Hi,
I am using DAAB with stored procedures. I stored procedure is called from multiple functions.
Please guide how I can handle optional parameters with DAAB ? a stored procedure has 2 parameter and values are being passed by functiona1. In function2 I needed to declare 3rd parameter in same stored procedure. I set its default value (so that I may have not to pass it from function1) but even than functions1 stop working and show error message that no of parameters are not same.
I am just selecting data in stored procedure and I have not coded any set statement (like set ansi on or set norowcount) in it.
Please guide me.
thanks
I am using DAAB with stored procedures. I stored procedure is called from multiple functions.
Please guide how I can handle optional parameters with DAAB ? a stored procedure has 2 parameter and values are being passed by functiona1. In function2 I needed to declare 3rd parameter in same stored procedure. I set its default value (so that I may have not to pass it from function1) but even than functions1 stop working and show error message that no of parameters are not same.
I am just selecting data in stored procedure and I have not coded any set statement (like set ansi on or set norowcount) in it.
Please guide me.
thanks