C#

Student.aspx.cs
********************
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Student : System.Web.UI.Page
{
    Comapre objComapre = new Comapre();
    protected void Page_Load(object sender, EventArgs e)
    {
      DataTable First=new DataTable();
      DataTable Second = new DataTable();
      DataTable Compare = new DataTable();

      First = objComapre.GetStudentTableOne();
      Second = objComapre.GetStudentTableTwo();
      Compare=compareDataTables(First, Second);

      GridView1.DataSource = First;
      GridView1.DataBind();
      GridView2.DataSource = Second;
      GridView2.DataBind();
      GridView3.DataSource = Compare;
      GridView3.DataBind();
    }

    public DataTable compareDataTables(DataTable First, DataTable Second)
    {
        First.TableName = "FirstTable";
        Second.TableName = "SecondTable";

        //Create Empty Table
        DataTable table = new DataTable("Difference");

        try
        {
            //Must use a Dataset to make use of a DataRelation object
            using (DataSet ds = new DataSet())
            {
                //Add tables
                ds.Tables.AddRange(new DataTable[] { First.Copy(), Second.Copy() });

                //Get Columns for DataRelation
                DataColumn[] firstcolumns = new DataColumn[ds.Tables[0].Columns.Count];

                for (int i = 0; i < firstcolumns.Length; i++)
                {
                    firstcolumns[i] = ds.Tables[0].Columns[i];
                }

                DataColumn[] secondcolumns = new DataColumn[ds.Tables[1].Columns.Count];

                for (int i = 0; i < secondcolumns.Length; i++)
                {
                    secondcolumns[i] = ds.Tables[1].Columns[i];
                }

                //Create DataRelation
                DataRelation r = new DataRelation(string.Empty, firstcolumns, secondcolumns, false);

                ds.Relations.Add(r);

                //Create columns for return table
                for (int i = 0; i < First.Columns.Count; i++)
                {
                    table.Columns.Add(First.Columns[i].ColumnName, First.Columns[i].DataType);
                }

                //If First Row not in Second, Add to return table.
                table.BeginLoadData();

                foreach (DataRow parentrow in ds.Tables[0].Rows)
                {
                    DataRow[] childrows = parentrow.GetChildRows(r);
                    if (childrows == null || childrows.Length == 0)
                        table.LoadDataRow(parentrow.ItemArray, true);
                }

                table.EndLoadData();

            }
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }

        return table;
    }
}

Comapre.cs
***********

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// Summary description for Comapre
/// </summary>
public class Comapre
{
    //Get Connection string from Web.config file
    string strConnection = ConfigurationManager.ConnectionStrings["MystudentConnString"].ConnectionString.ToString().Trim();

    DataTable dsGetStudentOne = new DataTable();
    DataTable dsGetStudentTwo = new DataTable();


    public DataTable GetStudentTableOne()
    {
        try
        {
            string GetConnection = strConnection;
            SqlConnection strConnectionString = new SqlConnection();
            strConnectionString.ConnectionString = GetConnection;
            strConnectionString.Open();
            //Executing Stored Procedure 
            SqlCommand cmdsearch = new SqlCommand("SP_GetStudent_1", strConnectionString);
            cmdsearch.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter daAdapter = new SqlDataAdapter(cmdsearch);
            daAdapter.Fill(dsGetStudentOne);
            strConnectionString.Close();

        }
        catch
        {
        }
        return dsGetStudentOne;

    }

    public DataTable GetStudentTableTwo()
    {
        try
        {
            string GetConnection = strConnection;
            SqlConnection strConnectionString = new SqlConnection();
            strConnectionString.ConnectionString = GetConnection;
            strConnectionString.Open();
            //Executing Stored Procedure 
            SqlCommand cmdsearch = new SqlCommand("SP_GetStudent_2", strConnectionString);
            cmdsearch.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter daAdapter = new SqlDataAdapter(cmdsearch);
            daAdapter.Fill(dsGetStudentTwo);
            strConnectionString.Close();

        }
        catch
        {
        }

        return dsGetStudentTwo;

    }

}

Web.config file
********************
connectionStrings>

add name="MystudentConnString" connectionString="Data Source=Poweredge;User Id=sa;password=sa;Initial Catalog=MyStudent;" providerName="System.Data.SqlClient"/>

/connectionStrings>

Table1
*******

USE [MyStudent]
GO
/****** Object:  Table [dbo].[Student_1]    Script Date: 09/18/2008 20:35:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Student_1](
	[Stname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Age] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[DateofBirth] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[School] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[College] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

Table2
*******
USE [MyStudent]
GO
/****** Object:  Table [dbo].[Student_2]    Script Date: 09/18/2008 20:37:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Student_2](
	[Stname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Age] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[DateofBirth] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[School] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[College] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

SP_GetStudent_1
***************

USE [MyStudent]
GO
/****** Object:  StoredProcedure [dbo].[SP_GetStudent_1]    Script Date: 09/18/2008 20:38:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[SP_GetStudent_1]
as
begin
select * from Student_1 
end

SP_GetStudent_2
***************

USE [MyStudent]
GO
/****** Object:  StoredProcedure [dbo].[SP_GetStudent_2]    Script Date: 09/18/2008 20:39:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[SP_GetStudent_2]
as
begin
select * from Student_2
end

private void Tabstop(object sender, IncrementEventArgs args)
		{
			if (args.Plus)
			{
				this.TabIndex = this.TabIndex + 1;
				
			}
			else
			{
				this.TabIndex = this.TabIndex - 1;
				}


		}