<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx</link><description>Recently I was sent a question about how to read from a serial port and save the information to a database so instead of following up privately I thought I'd post my answer here. There's a good article in the MSDN Library that has some hints on how to</description><dc:language>en-US</dc:language><generator>Telligent Evolution Platform Developer Build (Build: 5.6.50428.7875)</generator><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#10341301</link><pubDate>Sat, 18 Aug 2012 21:00:35 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10341301</guid><dc:creator>Daniel</dc:creator><description>&lt;p&gt;Hi Beth, is a great article!!!&lt;/p&gt;
&lt;p&gt;I have a question, In the program I added a column to the database is called &amp;quot;Time&amp;quot;&lt;/p&gt;
&lt;p&gt;How I can save the the time in this column in the same style that the data saved in the &amp;quot;message&amp;quot;?&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Dim message As MessageDataSet.MessageRow = Me.MessageDataSet.Message.NewMessageRow()&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;message.Message = myStringBuilder.ToString()&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Me.MessageDataSet.Message.Rows.Add(message)&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10341301" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#10079070</link><pubDate>Thu, 21 Oct 2010 18:51:38 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10079070</guid><dc:creator>ryanryan1970@hotmail.com</dc:creator><description>&lt;p&gt;my probleme is :&lt;/p&gt;
&lt;p&gt;i m working with serialport &lt;/p&gt;
&lt;p&gt;each week i have the deadscren(blue screen)&lt;/p&gt;
&lt;p&gt;how can i resolve the problem?&lt;/p&gt;
&lt;p&gt;ryanryan1970@hotmail.com&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10079070" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#10056890</link><pubDate>Wed, 01 Sep 2010 16:37:57 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10056890</guid><dc:creator>benny </dc:creator><description>&lt;p&gt;so nice.&lt;/p&gt;
&lt;p&gt;sir. i really want to know how to send data (text) from pc to led display with application like gui. that application build with vb&lt;/p&gt;
&lt;p&gt;i&amp;#39;m using microcontroller at89s51 with basic language.&lt;/p&gt;
&lt;p&gt;i have finish build led matrix. but i dont know how to design gui interface. &lt;/p&gt;
&lt;p&gt;please give me solution. beni-aceh &lt;/p&gt;
&lt;p&gt;indonesian benny_mrd@yahoo.co.id&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10056890" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#9685768</link><pubDate>Tue, 02 Jun 2009 18:53:48 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9685768</guid><dc:creator>Blake</dc:creator><description>&lt;p&gt;Thanks for the info, really helpful.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=9685768" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#9374482</link><pubDate>Sun, 25 Jan 2009 04:31:22 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9374482</guid><dc:creator>Shailesh</dc:creator><description>&lt;p&gt;Your article was very helpful in helping me write my first Serial Port programming App in VB.Net (VS2005). I only infd a very funny issue - which i am unable to solve. &lt;/p&gt;
&lt;p&gt;When I write the code similar to your code in a Windows App (vb.net) - it works fine. But, if i have to write it as a Windows Service (but ofcourse i do not call the Invoke UpdateControls - i just use the Received string from the DataReceived event for my logic). I noticed that the Windows App recieves the data correctly, and the Windows Service App receives the data but there are breaks in the data (Enter lines). I use the same ReadExisting method. &amp;nbsp;I am not sure if i should use any other of the ReadMethods. Do you have any advice?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=9374482" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#8847191</link><pubDate>Mon, 11 Aug 2008 00:41:34 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8847191</guid><dc:creator>Neil</dc:creator><description>&lt;p&gt;Thank you very much Beth for the serial code. I've converted it in VB2008 for use with a container filling machine I'm designing. It's given me the insight I needed.&lt;/p&gt;
&lt;p&gt;As this is my first attempt at a software controlled machine, the serial port is proving to be tricky. It would be good to use the serial port from VB2008 but I can't find any info on the subject. Do you know of any such document? If not, I'll just have to stick with you girl!&lt;/p&gt;
&lt;p&gt;Thank you again,&lt;/p&gt;
&lt;p&gt;Neil@polevolt.co.uk&lt;/p&gt;
&lt;p&gt;PS I'm restoring a 1972 TVR Vixen&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8847191" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#8789035</link><pubDate>Tue, 29 Jul 2008 17:54:48 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8789035</guid><dc:creator>David</dc:creator><description>&lt;p&gt;Thank you for posting this.&lt;/p&gt;
&lt;p&gt;I'm trying to write my first VB program and after mind numbing hours of trying to find something useful, I finally have!&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8789035" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#7580784</link><pubDate>Sun, 10 Feb 2008 15:06:58 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:7580784</guid><dc:creator>Jos</dc:creator><description>&lt;p&gt;Hee Cool stuff,&lt;/p&gt;
&lt;p&gt;Im not good at this, so i have a question!&lt;/p&gt;
&lt;p&gt;I want to control not only the input from a port, but also the output, i want to send out a decimal or binary number to a port. But how do i do this?&lt;/p&gt;
&lt;p&gt;And I want to use Microsoft DLL's (Windows DLL's when possible) &lt;/p&gt;
&lt;p&gt;When you have a awnser you can mail me at: jluijten1@student.han.nl&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=7580784" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#6902832</link><pubDate>Sun, 30 Dec 2007 04:32:15 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:6902832</guid><dc:creator>Antonio </dc:creator><description>&lt;p&gt;Bethy&lt;/p&gt;
&lt;p&gt;Thank you very much for the videos you sent to me.&lt;/p&gt;
&lt;p&gt;Now, and for the first time my &amp;nbsp;application is working very well without producing any error.&lt;/p&gt;
&lt;p&gt;Thaaaaaaaaanks.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=6902832" width="1" height="1"&gt;</description></item><item><title>re: Reading from a Serial Port and Saving to a Database</title><link>http://blogs.msdn.com/b/bethmassi/archive/2007/05/05/reading-from-a-serial-port-and-saving-to-a-database.aspx#4626898</link><pubDate>Wed, 29 Aug 2007 13:03:37 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:4626898</guid><dc:creator>Sushil</dc:creator><description>&lt;p&gt;Thank you for this article. it really proved beneficial in an application i am working on. couldn't have done it without you.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=4626898" width="1" height="1"&gt;</description></item></channel></rss>