Click here to Skip to main content
15,907,231 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to print a recording Pin
ago248611-Apr-18 0:37
ago248611-Apr-18 0:37 
QuestionSerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 3:28
ibrahimayhans28-Mar-18 3:28 
AnswerRe: SerialPort DataReceived Event Read Byte ? Pin
Richard MacCutchan28-Mar-18 3:54
mveRichard MacCutchan28-Mar-18 3:54 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 4:00
ibrahimayhans28-Mar-18 4:00 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
OriginalGriff28-Mar-18 4:17
mveOriginalGriff28-Mar-18 4:17 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 4:24
ibrahimayhans28-Mar-18 4:24 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
OriginalGriff28-Mar-18 4:26
mveOriginalGriff28-Mar-18 4:26 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 4:28
ibrahimayhans28-Mar-18 4:28 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
OriginalGriff28-Mar-18 4:43
mveOriginalGriff28-Mar-18 4:43 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 4:48
ibrahimayhans28-Mar-18 4:48 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
OriginalGriff28-Mar-18 5:01
mveOriginalGriff28-Mar-18 5:01 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 4:30
ibrahimayhans28-Mar-18 4:30 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
Richard MacCutchan28-Mar-18 4:40
mveRichard MacCutchan28-Mar-18 4:40 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 4:44
ibrahimayhans28-Mar-18 4:44 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
Richard MacCutchan28-Mar-18 5:28
mveRichard MacCutchan28-Mar-18 5:28 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 5:37
ibrahimayhans28-Mar-18 5:37 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
Richard MacCutchan28-Mar-18 6:03
mveRichard MacCutchan28-Mar-18 6:03 
AnswerRe: SerialPort DataReceived Event Read Byte ? Pin
Gerry Schmitz28-Mar-18 4:12
mveGerry Schmitz28-Mar-18 4:12 
AnswerRe: SerialPort DataReceived Event Read Byte ? Pin
Eddy Vluggen28-Mar-18 5:13
professionalEddy Vluggen28-Mar-18 5:13 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
ibrahimayhans28-Mar-18 5:21
ibrahimayhans28-Mar-18 5:21 
GeneralRe: SerialPort DataReceived Event Read Byte ? Pin
OriginalGriff28-Mar-18 5:56
mveOriginalGriff28-Mar-18 5:56 
AnswerRe: SerialPort DataReceived Event Read Byte ? Pin
Luc Pattyn28-Mar-18 8:23
sitebuilderLuc Pattyn28-Mar-18 8:23 
QuestionHow to strip special characters from a field and replace with blanks Pin
Member 1375136828-Mar-18 3:17
Member 1375136828-Mar-18 3:17 
I am not a c# developer. I am creating an ETL in Visual Studio 2017 and trying to add a scripted transformation container to strip the /'s out of a name field. VS creates the base code and tells you where to add the code.

This is the beginning:
egion Help:  Introduction to the Script Component
/* The Script Component allows you to perform virtually any operation that can be accomplished in
 * a .Net application within the context of an Integration Services data flow.
 *
 * Expand the other regions which have "Help" prefixes for examples of specific ways to use
 * Integration Services features within this script component. */
#endregion

#region Namespaces
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
#endregion

/// <summary>
/// This is the class to which to add your code.  Do not change the name, attributes, or parent
/// of this class.
/// </summary>
[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]
public class ScriptMain : UserComponent
{
    #region Help:  Using Integration Services variables and parameters
    /* To use a variable in this script, first ensure that the variable has been added to
     * either the list contained in the ReadOnlyVariables property or the list contained in
     * the ReadWriteVariables property of this script component, according to whether or not your
     * code needs to write into the variable.  To do so, save this script, close this instance of
     * Visual Studio, and update the ReadOnlyVariables and ReadWriteVariables properties in the
     * Script Transformation Editor window.
     * To use a parameter in this script, follow the same steps. Parameters are always read-only.
     *
     * Example of reading from a variable or parameter:
     *  DateTime startTime = Variables.MyStartTime;
     *
     * Example of writing to a variable:
     *  Variables.myStringVariable = "new value";
     */
    #endregion

    #region Help:  Using Integration Services Connnection Managers
    /* Some types of connection managers can be used in this script component.  See the help topic
     * "Working with Connection Managers Programatically" for details.
     *
     * To use a connection manager in this script, first ensure that the connection manager has
     * been added to either the list of connection managers on the Connection Managers page of the
     * script component editor.  To add the connection manager, save this script, close this instance of
     * Visual Studio, and add the Connection Manager to the list.
     *
     * If the component needs to hold a connection open while processing rows, override the
     * AcquireConnections and ReleaseConnections methods.
     * 
     * Example of using an ADO.Net connection manager to acquire a SqlConnection:
     *  object rawConnection = Connections.SalesDB.AcquireConnection(transaction);
     *  SqlConnection salesDBConn = (SqlConnection)rawConnection;
     *
     * Example of using a File connection manager to acquire a file path:
     *  object rawConnection = Connections.Prices_zip.AcquireConnection(transaction);
     *  string filePath = (string)rawConnection;
     *
     * Example of releasing a connection manager:
     *  Connections.SalesDB.ReleaseConnection(rawConnection);
     */
    #endregion

    #region Help:  Firing Integration Services Events
    /* This script component can fire events.
     *
     * Example of firing an error event:
     *  ComponentMetaData.FireError(10, "Process Values", "Bad value", "", 0, out cancel);
     *
     * Example of firing an information event:
     *  ComponentMetaData.FireInformation(10, "Process Values", "Processing has started", "", 0, fireAgain);
     *
     * Example of firing a warning event:
     *  ComponentMetaData.FireWarning(10, "Process Values", "No rows were received", "", 0);
     */
    #endregion

    /// <summary>
    /// This method is called once, before rows begin to be processed in the data flow.
    ///
    /// You can remove this method if you don't need to do anything here.
    /// </summary>
    public override void PreExecute()
    {
        base.PreExecute();
        /*
         * Add your code here
         */
    }


Where it says add your code here I have tried multiple suggestions I have found online, but it doesn't like the syntax. I don't know if I have to declare the field, or what I'm missing. The most promising looked like the Regex function, but it will not recognize it regardless of how I type it. Any help here would be extremely appreciated!
AnswerRe: How to strip special characters from a field and replace with blanks Pin
Gerry Schmitz28-Mar-18 5:50
mveGerry Schmitz28-Mar-18 5:50 
AnswerRe: How to strip special characters from a field and replace with blanks Pin
#realJSOP28-Mar-18 8:08
professional#realJSOP28-Mar-18 8:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.