C#

<br />
   RichTextBox r = f2.Controls[0] as RichTextBox;<br />
   if (r != null)<br />
   {<br />
     // append text here.<br />
   }

public RichTextBox MyRichTextBox
{
get {
  return richTextBox1;
}
}

///////////////////////////////////////////////////////////////////////////////<br />
<br />
/*** This is Main Form code ***/<br />
<br />
public SerialPort comport = new SerialPort();<br />
<br />
public Form f1;<br />
<br />
f1 = new ChildForm();<br />
f1.MdiParent = this;<br />
<br />
comport.DataReceived += new SerialDataReceivedEventHandler(port_DataReceived);<br />
<br />
<br />
private void btn_Senddata_Click(object sender, EventArgs e)<br />
{<br />
      comport.open();<br />
	comport.Write("This is the text to be transmitted");<br />
<br />
}<br />
<br />
public void port_DataReceived(object sender, SerialDataReceivedEventArgs e)<br />
{<br />
            string ReceivedData = comport.ReadExisting();<br />
<br />
            ReceiveLog(LogMsgType.Incoming, ReceivedData);<br />
<br />
if(f1.Controls[0].InvokeRequired)<br />
{<br />
f1.Controls[0].Invoke(new EventHandler(delegate<br />
                  { f1.Controls[0].AppendText(ReceivedData); <br />
}));<br />
}<br />
<br />
<br />
<br />
/*** This is Child Form (f1) code ***/<br />
<br />
RichTextBox MyRichTextBox  = new RichTextBox();//this is decalred ‘public’<br />
<br />
<br />
<br />
<br />
///////////////////////////////////////////////////////////////////////////////

string ReceivedData = comport.ReadExisting();
ReceiveLog(LogMsgType.Incoming, ReceivedData);
if(f1.MyRichTextBox.InvokeRequired)
{
  this.Invoke(new EventHandler(delegate
    { f1.MyRichTextBox.AppendText(ReceivedData); }
  ));
} else {
  f1.MyRichTextBox.AppendText(ReceivedData);
}

<br />
SELECT TOP 1 * FROM myTable WHERE code>@currentCode ORDER BY CODE<br />

<br />
SELECT TOP 1 * FROM myTable WHERE code<@currentCode ORDER BY CODE DESC<br />

<br />
SELECT TOP 1 * FROM myTable ORDER BY Code //First record<br />
SELECT TOP 1 * FROM myTable ORDER BY Code DESC//Last record<br />
<br />