C#

using System;
using System.Collections.Generic;
using System.Text;

namespace VirtualMethods
{
    class Program
    {
        static void Main(string[] args)
        {
            A a = new A();
            A aa = new AA();
            A ab = new AB();
            A ac = new AC();

            Console.WriteLine(a.GetValue());
            Console.WriteLine(aa.GetValue());
            Console.WriteLine(ab.GetValue());
            Console.WriteLine(ac.GetValue());

            Console.ReadLine();
        }
    }
}

class A
{
    public virtual string GetValue()
    {
        return "A";
    }
}

class AA : A
{
    public override string GetValue()
    {
        return "AA";
    }
}

class AB : A
{
    public override string GetValue()
    {
        return "AB";
    }
}

class AC : A
{
    public override string GetValue()
    {
        return base.GetValue();
    }
}

obalesu wrote:

please solve my problem.

<br />
System.Net.WebProxy objProxy = new System.Net.WebProxy("http://1.2.3.5:8080/", true);<br />
YourService.Proxy = objProxy;<br />

<br />
YourService.Proxy = null; <br />

using (SqlConnection sc = new SqlConnection())
        {
            StringBuilder sql = new StringBuilder(); // or simply use string instead
            sql.Append("exec sp_YourProc");
            string connStr = "...";
            sc.ConnectionString = connStr;
            sc.Open();
            using (SqlCommand sco = new SqlCommand())
            {
                try
                {
                    sco.CommandType = CommandType.Text;
                    sco.CommandText = sql.ToString();
                    sco.Connection = sc;
                    using (SqlDataReader sr = sco.ExecuteReader())
                    {
                        // Do something with the incoming data;
                    }
                }
                catch (SqlException exc)
                {
                    // ... Deal with exceptions
                }
            }

SqlParameter outParam = new SqlParameter("@myOutParam",SqlDbType.Int);<br />
outParam.Direction = ParameterDirection.Output;<br />
myCmd.Parameters.Add(outParam);