Copy Specific Columns From One DataTable To Another

In this tutorial, I’ll show you how to copy specific columns from one datatable to another datatable in c#.

Suppose, I have a complex store procedure in my SQL Database, which returns 25 columns with a large amount of data. I use the store procedure in multiple forms so that I can’t change the store procedure. I want to copy specific columns from the DataTable to another in C#. I follow the method and it’s working fine.


public DataTable LoadMyData(Hashtable ht)
{
      _dbTable = new DataTable();
      _reader = new DataReader();
      DataTable _dt = _reader.GetDataTableByCommandFromStoredProc("SP_ATTENDANCE", ht); //get datatable by execute store procedure

      String[] columnList = new String[] { "AttnDate", "Status", "ActualInTime", "ActualOutTime", "OutStatus" }; //list of my specific columns 
      return _dbTable = new DataView(_dt).ToTable(false, columnList);
}