C#

<code>
     // Create a new backup operation
     Backup bkpDatabase = new Backup();
    // Set the backup type to a database backup
    bkpDatabase.Action = BackupActionType.Database;
   // Set the database that we want to perform a backup on
      bkpDatabase.Database = "Your Selected Database"
    // Set the backup device to a file
   BackupDeviceItem bkpDevice = new BackupDeviceItem(BackupFileName.bak, DeviceType.File);
     // Add the backup device to the backup
             bkpDatabase.Devices.Add(bkpDevice);
     // Perform the backup
       bkpDatabase.SqlBackup(srvSql);
</code>

BackupDeviceItem bkpDevice = new BackupDeviceItem(BackUpSavePath, DeviceType.File);

mpavas wrote:

I have a data table which has multiple columns. I want to create another data table with only selected columns.

For Example

If my datatable1 has below columns:
Emp no, Name, Age, Date Of Birth, Join Date


I want to create another datatable with below columns
Name, Age, Date Of Birth

I do not want to loop the datatable and insert the values in another datatable.

prince nani wrote:

any sample programs on wrapper classes.