Received Data from Serial Port and convert into parts and store in Access database

[saqsaq]

i am creating application receiving data from serial port in the following format :

2201m2226m23697dcccc6dddd5gggg5

i want to split this data in parts like

2201m
2226m
23697d
cccc6dd
dddd5g
gggg5

and save these data in Access database tabel in different field

kindly guide us i am new to VB.Net

[hb21l6]

hi,

if you know each variable length you need from the string, you will need to break it down with substring.

Dim myval as string = "2201m2226m23697dcccc6dddd5gggg5"
Dim substring1 As String = myval.Substring(0, 5) ' first five
Dim substring2 As String = myval.Substring(5, 5) ' second five
Dim substring2 As String = myval.Substring(10, 6) ' third six

etc


There are plenty of examples of how to write data to a database on this forum.

Dave

[saqsaq]

Hi Dave
can you share the link for example

[techgnome]

http://www.vbforums.com/showthread.p...ed-May-13-2011

-tg