How to Truncate Data in c#

Question

Hi All iam using Button Control When User Click the Button only Records is Erase in Table in the Below My Script where iam doing Wrong Let me Know. sql connction con = new sql connction (Data Source=sys2;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234); string s = Truncate Table TableName; sqladapter da = new sql Adapter(scon); Dataset ds = new Dataset (); da.fill(dsTableName);

Manoj Bhoir · Answer

Hi Venkat Why you are using DataSet and DataAdapter Here? Just use this code : SqlConnction con = new sql connction (Data Source=sys2;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234); string s = Truncate Table TableName; SqlCommand Com = new SqlCommand(s Con); Com.ExecuteNonQuery(); And you are done.

Pankaj Kumar Choudhary · Answer

Hello @Venkata there is some problems with your query. you are using sqladapter da = new sql Adapter(scon); i want to inform that this is used for retrieve data from table . instead of this please use Sqlcommand and use ExeecuteNonQuery operation because this Command is used for Perform DML query on the database so please update or modify your query as string s = Truncate Table TableName; SqlCommand Com = new SqlCommand(s Con); Com.ExecuteNonQuery();

Rajkiran Swain · Answer

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 ); }

Jitendra Kumar · Answer

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 (); http://www.c-sharpcorner.com/forums/thread/157844/truncate-command.aspx