C#

for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
   oRng = oSht.get_Range("A" + iRow.ToString(), strLastCol + iRow.ToString());
   oRng.Value2 = (System.Array)dt.Rows[iRow].ItemArray;
}

1. File | New | Graph
2. Click the SerialPort icon on the toolbar, this will add a port to the graph window (multiple ones are supported).
3. Click the little drop-down arrow of the new button and select Properties.
4. Edit the port settings to what you require (note you must change the Color as this defaults to White and will not display on the graph).
5. Click the little drop-down arrow and select open, this will open the port and is ready to receive data.

// Create server<br />
            BinaryServerFormatterSinkProvider provider = new BinaryServerFormatterSinkProvider();<br />
            provider.TypeFilterLevel = System.Runtime.Serialization.Formatters.TypeFilterLevel.Full;<br />
            IDictionary props = new Hashtable();<br />
            props["port"] = mySettings.TCPPort;    <br />
            TcpChannel channel = new TcpChannel(props, null, provider);<br />
            ChannelServices.RegisterChannel(channel, false);<br />
            RemotingConfiguration.RegisterWellKnownServiceType(typeof(MyMessenger), "MyRemoteService", WellKnownObjectMode.Singleton);<br />
<br />
// Get copy for myself<br />
messenger = (MyMessenger)Activator.GetObject(typeof(MyMessenger), "tcp://localhost:" + mySettings.TCPPort + "/MyRemoteService");

leckey wrote:

I'm bitter about several things today