Dynamically passsing Parameters in Stored Procedure Using C# RRS feed

  • Question

  • Dear all,

    I am having a stored procedure in Oracle with 5 parameters

    for E.g. the parameters are SNo,Name,SAge,Group1,Group2

    I need to pass the parameter values from C#

    I have a textbox for Sno,Name,SAge.

    For Group1,Group2 I am having a Checked list box , if we checked group1 the value is "Yes" else the values is "No"

    for this I have written a normal procedure call with parameters.add and specify the fieldname as @group1 , @group2.

    Now My need is from back end we may add more no of groups as such as group3, group4,group5... groupN.

    if then I need to change the C# code every time. but this should be done dynamically from C# code based on the parameters and based on the checkedlistbox values the parameter should be passed.

    How can it possible,

    Please help me , I needed it very urgent.

    Thanks in Advance,


    Tuesday, December 18, 2012 1:08 PM