How To fill Data into temporary table from existing table

See more:

SQL-Server-2005

C#

ASP.NET

, +

Hello All,
I have created a temporary table through programming.I want to show data of this temporary table into grid view in asp.net.I want that this temporary table will show data from existing table's data.how it will be possible to fill temporary table from existing table in front end.

coding for Temporary table is:---

private DataTable CreateDataTable()
    {
        DataTable myDataTable = new DataTable();

        DataColumn myDataColumn;

        myDataColumn = new DataColumn();
        myDataColumn.DataType = Type.GetType("System.Int32");
        myDataColumn.ColumnName = "id";
        myDataTable.Columns.Add(myDataColumn);

        myDataColumn = new DataColumn();
        myDataColumn.DataType = Type.GetType("System.String");
        myDataColumn.ColumnName = "Req_Name";
        myDataTable.Columns.Add(myDataColumn);

        myDataColumn = new DataColumn();
        myDataColumn.DataType = Type.GetType("System.Int32");
        myDataColumn.ColumnName = "Req_Amt";
        myDataTable.Columns.Add(myDataColumn);

        myDataColumn = new DataColumn();
        myDataColumn.DataType = Type.GetType("System.DateTime");
        myDataColumn.ColumnName = "Req_date";
        myDataTable.Columns.Add(myDataColumn);

          myDataColumn = new DataColumn();
          myDataColumn.DataType = Type.GetType("System.Int32");
        myDataColumn.ColumnName = "Req_head_ID";
        myDataTable.Columns.Add(myDataColumn);

          myDataColumn = new DataColumn();
          myDataColumn.DataType = Type.GetType("System.Int32");
        myDataColumn.ColumnName = "Req_lib_head_id";
        myDataTable.Columns.Add(myDataColumn);

          myDataColumn = new DataColumn();
        myDataColumn.DataType = Type.GetType("System.String");
        myDataColumn.ColumnName = "req_quantity";
        myDataTable.Columns.Add(myDataColumn);
         

        return myDataTable;
    }