public  static void SqlBulkCopyMeth(string TableName, DataTable Dt,string SqlDeleteText)
         {
           //Dt存放了要插入的表中的所有数据

          //SqlDeleteText是删除一个表中记录的SQL语句
                 using (SqlTransaction transaction=MySqlConn.BeginTransaction())
                 {
                    SqlCommand sqlcom = MySqlConn.CreateCommand();
                    sqlcom.Transaction = transaction;
                    sqlcom.CommandText = SqlDeleteText;
                     using (SqlBulkCopy bulk = new SqlBulkCopy(MySqlConn,SqlBulkCopyOptions.KeepIdentity,transaction))
                     {
                         if(Dt.Rows.Count>0)
                         {
                             bulk.BatchSize=Dt.Rows.Count;
                             bulk.DestinationTableName=TableName;
                         }
                         try
                         {
                             sqlcom.ExecuteNonQuery();
                            
                             bulk.WriteToServer(Dt);
                             transaction.Commit();
                         }
                         catch
                         {
                             transaction.Rollback();

                         }
                     }
                    
                   
                     }
                 }