C# Scripts

C# Scripts

File Operation

  1. C# - Delete files from a folder those are older than some number of days by using C Sharp
  2. C# - How to get Oldest file from a folder by using C Sharp
  3. C# - How to get the latest file from a folder by using C Sharp
  4. C# - How to copy all files in a folder to another folder in C Sharp
  5. C# - How to copy files and overwriting existing files if exists in a folder by using C Sharp
  6. C# - How to Move files from a folder to Another Folder in C Sharp
  7. C# - File.MoveTo Does not work - Cannot create a file when that file already exists. - C Sharp
  8. C# - How to move and rename files to another folder by adding datetime to file name by C Sharp
  9. C# - How to Copy files from a folder to another folder and add date-time to file names in C Sharp

Import Files( CSV or Text ) To Database

  1. C# - How to get file Properties and insert into SQL Server table by using C Sharp
  2. C# - How to Import or Load Text file to SQL Server Table by using C Sharp
  3. C# - How to Import multiple text files to SQL Server Table by using C Sharp
  4. C# - Importing Files to SQL Server Table with Dynamic Columns by using C Sharp
  5. C# - How to create SQL Server Table dynamically from Flat file and Load data to Table in C Sharp
  6. C# - How to Load data to SQL Server Tables from flat files according to file names by using C Sharp
  7. C# - How to Import Multiple CSV Files to SQL Server from a Folder in C Sharp

Export from Database to Files ( CSV or Text)

  1. C# - How to Export Data from SQL Server Table or View to Text File in C Sharp
  2. C# - How to Export Stored Procedure Results to Text File in C Sharp
  3. C# - How to write multiple CSV files to Single CVS File in C Sharp
  4. C# - How to Export all the tables from a database to flat files by using C Sharp
  5. C# - How to Export All tables of a database to Excel Files with Date-time in C#
  6. C# - How to Export large table data to multiple Excel Sheets on Single Excel file in C#

Excel  to Files (CSV or Text)

  1. C#- How to convert each excel sheet to CSV file from Excel Files in C#
  2. C# -  How to create CSV file per Excel File and Load All Sheets from Excel File to it in C#

Files (CSV To Text) To Excel

Import To SQL Server Database from Excel

  1. C# - How to Import Excel Sheet to SQL Server Table in C#
  2. C# - How to Create Table per Excel File and Import all Sheet's Data Dynamically in C#
  3. C# - How to Read Excel Sheet Data after Skipping Rows and Load to SQL Server Table in C#
  4. C# - Import Excel Files with Single or  Multiple Sheets to SQL Server Tables according to Excel File Name Dynamically in C#
  5. C# - Import Data To Tables according to Excel Sheet Names from Excel Files dynamically in C#
  6. C# - How to create table for each of Excel Sheet Dynamically and Import Data in C#
  7. C# - Import Multiple Excel Files with Multiple Sheets to Single SQL Server Table in C#
  8. C# - How to get Excel file's information and import to SQL Server Table in C#
  9. C# - Import Only Matching Column's Data to SQL Server Table from Excel Files Dynamically in C#
  10. C# - Import Excel Sheet Data with Excel File Name and Sheet Name in SQL Server Table in C#
  11. C#- How to Read Excel  Cell value in C#

Export to Excel from Database

Console Application

  1. C# - Why console window disappear immediately without display my output in C Sharp?
  2. C# - What is the difference between Console.Write and Console.WriteLine Methods in C Sharp

Read / Write to Database

String Operations