C#

class A {}
class B : A {}
class C : A {}
...
B b = new B();
Change(ref b);
// At this point, b contains an instance of C!
...
void Change(ref A a)
   {
   a = new C();
   }

public void Test()
    {
    string MyString = "";
    int MyInt = 0;
    object oS = MyString;
    GetTypeAndSetToOne(ref oS);
    MyString = (string) oS;
    object oI = MyInt;
    GetTypeAndSetToOne(ref oI);
    MyInt = (int) oI;
    }

using System;

namespace ConsoleApplication5
{
    class Program
    {
        static void GetTypeAndSetToOne<T>(ref T Value)
        {
            if (Value is int)
            {
                Value = (T)(object)1;
                Console.WriteLine("int");
            }
            else if (Value is string)
            {
                Value = (T)(object)"1";
                Console.WriteLine("string");
            }
        }

        static void Main(string[] args)
        {
            string myString = "";
            int myInt = 0;
            GetTypeAndSetToOne(ref myString);
            GetTypeAndSetToOne(ref myInt);
            Console.WriteLine("MyString, type = {0}, value = {1}", myString.GetType(), myString);
            Console.WriteLine("MyInt, type = {0}, value = {1}", myInt.GetType(), myInt);
            Console.ReadLine();
        }
    }
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

using (SqlConnection cnn = new SqlConnection(strConnect))
    {
    cnn.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM LISTSTAFF()", cnn))
        {
        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
            DataTable dt = new DataTable();
            da.Fill(dt);
            gridview.DataSource = dt;
            }
        }
    }

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE LISTSTAFF 
AS
BEGIN
	SET NOCOUNT ON;
	SELECT * FROM tblStaff
END
GO

Member 2458467 wrote:

procedure does not return a value

Member 2458467 wrote:

gridview.DataSource =... how assign ?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]