Hi, anyone know how to read the value one by one?

like an email

To: nacy,jack,tom,cat

how do i read the value one by one after the comma sign and insert them to database?

so the result is i will insert

nacy
jack
tom
cat

into the database respectively.please kindly advise. Thanks alot

You can parse character delimited strings using the String.Split() method.

Here is a VB.NET sample:

Dim myString As String
Dim myStringArray() As String
myString = "nacy,jack,tom,cat"
myStringArray = myString.Split(","c)

Now you can iterate thru the elements of the array and do whatever you like with each value.

-Peter

Hai friend,

string delimiterStr =",";
char [] delimiter;
string [] split = null;
delimiter = delimiterStr.ToCharArray();
split = date.Split (delimiter);
for(int i =0;i<split.length;i++)
{
Insert the data split[i];
}

Try this. It may help you.

Thanks

Gowtham Sen

Sorry change date as your string.
Hai friend,
string mystring = "ram,jaga,sen,gowtham";
string delimiterStr =",";
char [] delimiter;
string [] split = null;
delimiter = delimiterStr.ToCharArray();
split = Mystring.Split (delimiter);
for(int i =0;i<split.length;i++)
{
Insert the data split[i];
}

Try this. It may help you.

Thanks


Gowtham Sen