Database

select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where Table_Name = 'TestTable'
 and Constraint_Type = 'FOREIGN KEY'

public class Class1
{


   public DataTable GetData()
   {
      int Code;

      String strCon = "blablablablablablabla";

      SqlConnection con = new SqlConnection(strCon);

      SqlCommand cmdselect = new SqlCommand();

      cmdselect.CommandType = CommandType.StoredProcedure;

      cmdselect.CommandText = "student_SelectAll";

      cmdselect.Connection = con;

      DataTable DT = new DataTable();


      try
      {
          con.Open();

          DT = cmdselect.ExecuteNonQuery();

      }
       catch(SqlException)
      {
           throw;
      }
       finally
      {
          con.Close();
      }

      return DT;

   }

  }

Class1 obj = new Class1();

          DataTable DT = new DataTable();

           DT =  obj.GetData();

           txtname.Text = DT.Columns[0];

           txtlastname.Text = DT.Columns[1];
           //and bla bla blabla

create function GetEventType (@EventID int)
returns varchar(12)
AS
declare @desc         varchar(50)  
declare @eventHeading varchar(12)  
begin  
   select @eventHeading = [EventHeading]
   from   tblEvents   
   where [EventID] = @EventID
   --
   set @desc = 'Unknown event type'
   if (@eventHeading = 'Info')  set @desc = 'Information'  
   if (@eventHeading = 'Warn')  set @desc = 'Warning'  
   if (@eventHeading = 'Error') set @desc = 'Error'		  
   ---
   return (@desc)
end