C#

asif_aslam wrote:

Hi,

I want to know,How to know Store Procedure Input and Output parameters.
What I want.

When I pass any Store Procedure Name.it's return that Store Procedure Input and Output parameters.

Help me out

it's very arrgent.

Thanks

select specific_name, parameter_name, data_type, character_maximum_length, parameter_mode from information_schema.parameters where specific_name = @spName<br />

string myform = actual_returned_string;

switch(myform)
{
    case "test1":
    {
        MyTest1 t1 = new MyTest1();
	break;
    }
 
    case "test2":
    {
	MyTest2 t1 = new MyTest2();
	break;
    }
 
    default:
	break;
}

using System.Reflection;
 
public System.Windows.Forms.Form GetFormByName(string _name)
{
    Type t = Type.GetType(_name);
    if (t != null)
    {
	ConstructorInfo c = t.GetConstructor(Type.EmptyTypes);
	Object o = c.Invoke(new Object[0]);
	return o as System.Windows.Forms.Form;
    }
    else
    {
	return null;
    }
}

string namespace = //???
string myform = namespace+actual_returned_string;
 
System.Windows.Forms.Form actForm = GetFormByName(myform);

Colin Angus Mackay wrote:

I don't know why you got voted a 2 for that - I thought the reflection idea was sound.

ednrgc wrote:

Probably because the answer was above the person's comprehension.

string newphone = Regex.Replace(phone, 
@"^((?<country>[1])([ ]|.|-))(\(|\[)?(?<area>\d{3})(\)[ ]?|\][ ]?|.|-)?(?<prefix>\d{3})(.|-|" +
"[ ])?(?<suffix>\d{4})[ ]?(x|X|#|.)?(?<ext>\d{0,5})$", 
"${country} (${area}) ${prefix}-${suffix} #${ext}");