How to Truncate Data in c#

DataTable dataTable = null; 

// your data needs to be here try { ConnectionStringSettings mConString = ConfigurationManager.ConnectionStrings["SiteSqlServer"]; 

// Optional truncating old table using (SqlConnection connection = new SqlConnection(mConString.ConnectionString)) 

{                 connection.Open(); // Delete old entries SqlCommand truncate = new SqlCommand("TRUNCATE TABLE MYTABLE", connection);        

         truncate.ExecuteNonQuery(); 

} 

SqlBulkCopy bulkCopy = new SqlBulkCopy(mConString.ConnectionString, SqlBulkCopyOptions.TableLock)

 { 

DestinationTableName = "dbo.MYTABLE", BatchSize = 100000, BulkCopyTimeout = 360 };      

       bulkCopy.WriteToServer(dataTable); 

} 

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

 }

If you are running your code against a sqlserver database then
use this command

string sqlTrunc = "TRUNCATE TABLE " + yourTableName SqlCommand cmd = new SqlCommand(sqlTrunc, conn); cmd.ExecuteNonQuery();