Of course it depends on your usage/requirements but I like the Control Parameters as they hook up to a page control such as a dropdown and automatically grab its value - great for user input based queries.Session Parameters (hook up to a session variable) are also great for passing things like sessionid, user login, and other persistent data to the query.Alternately, simply create the parameters dynamically at runtime in code.
I have a grid that is bound to a SQL Data Source control. I have a Command Item Template for editing the records. Update(); ...doesn't update the value :(I still haven't figured this out. Can this article help me with this issue: I have a procedure in Oracle, that create a temporary table with output data. Now you can ask questions directly to me on my new site ASPForums. Net Question Answer site, specially started to allow visitors of this site ask their doubts and queries. Just click the Ask Now button and ask your question now.
The procedure P_TECT_UPD_EXAM_ID expects two parameters as input: "in_MPID" and "in_User Id" I am also wondering how to map those values to the input parameters for the procedure as the names are different?