Click here to Skip to main content
15,880,405 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello developers,

Friends i am working on a web application based on 3 tier architecture where we have seperate projects for BLL,DAL and Interface respectively.I am facing aproblem while i pass the name of the stored procedure to the bll for selecting the rows from the table,The command text doesnot pickup the name of the procedure however it does go through the function where i have initialized the command text property but still it throws an exception command property noty not initialised.Please help,
Regards,
Gourav sharma
Posted
Comments
[no name] 29-Apr-13 8:41am    
"Please help"... with what? The only thing we could help you with based on your narrative is to tell you to initialize the command text.

1 solution

Set the CommandText to name of the procedure and CommandType to StoredProcedure.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900