Getting comma seperated string in arraylist

Question

0.00/5 (No votes)

See more:

Hello friends,
I have clientid and comma separated string (a,b,c).
How can I get comma separated string in an array?
How can I save every part of string into the database?

Any idea?

Thanks in advance

Posted 4-Aug-11 0:08am

dhage.prashant01

Updated 4-Aug-11 1:09am

v2

Add a Solution

Comments

dhage.prashant01 4-Aug-11 7:24am

I want it to take in array list, so that later it helps me to save each element of array into the database

Any idea, how can I do it?

4 solutions

Solution 2

Try as below.

For C#

C#

string input = "1,2,3,4,5";
string[] stringArray = input.Split(',');

For Javascript

JavaScript

var mySplitResult = myString.split(",");

Posted 4-Aug-11 0:20am

RaisKazi

Updated 4-Aug-11 0:25am

v4

Solution 1

You can use string.Split() method. This will return an array of strings.

Posted 4-Aug-11 0:15am

Suresh Suthar

v2

Solution 4

Hiii
Try this
string.split()...............................

Posted 4-Aug-11 1:32am

Ashika s

Comments

Manfred Rudolf Bihy 12-Aug-11 11:01am

Your '.' key is stuck again?

dhage.prashant01 8-Feb-12 0:45am

lolz..

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Toniyo Jackson · Accepted Answer · 2011-08-04T00:20:00

Solution 3

Try this.

string[] arr;
arr = "123,456,678".Split(',');

OP: I'm doing code in VB.NET tell me, user enters a,b,c,d in text box, how can I insert a b c d separately into database

Dim arr As String()
arr = "123,456,789".Split(",")

Dim strval As String = ""
For i As Integer = 0 To arr.Length - 1
  strval = arr(i)
  // do your insert operation here 
Next

Posted 4-Aug-11 0:20am

Toniyo Jackson

Updated 4-Aug-11 1:55am

v2

Comments

dhage.prashant01 4-Aug-11 7:24am

I want it to take in array list, so that later it helps me to save each element of array into the database

Any idea, how can I do it?

Toniyo Jackson 4-Aug-11 7:33am

This also you can use like this. arr[0],arr[1],arr[2],arr[3]...

dhage.prashant01 4-Aug-11 7:39am

Problem is I don't know the size of array in advance
for example I have string a,b,c,d
I want to save it in array as u said
but how can i determine the size?

Toniyo Jackson 4-Aug-11 7:41am

arr.Length

dhage.prashant01 4-Aug-11 7:44am

You did not get my point.
when you declare array, to need to mention its size.
but in my case, i don't have idea about size in advance.
User can input any text in comma separated format and each part of string I wan to save into database

Toniyo Jackson 4-Aug-11 7:46am

Why you want to mention the size in advance?

dhage.prashant01 4-Aug-11 7:50am

Ok I'm doing code in VB.NET
tell me, user enters a,b,c,d in text box, how can I insert a b c d separately into database

Toniyo Jackson 4-Aug-11 7:56am

See the updated answer. If you are using VB.Net, just add the VB.Net tag in the question.

dhage.prashant01 4-Aug-11 8:01am

Dim arr As String()
it means you have declared array of string if I'm not wrong?

Toniyo Jackson 4-Aug-11 8:03am

Of course

dhage.prashant01 4-Aug-11 8:06am

Well thanks
That was I looking for

Toniyo Jackson 4-Aug-11 8:07am

You are welcome :)

dhage.prashant01 4-Aug-11 8:11am

One more, when I insert each part of string I want to get the record id in another array list.
Because later this id+clientid I will save in other table