SQL Insert Comma Delimited string

[BrianDH]

String = “val1, val2, va3, va4�
Insert value into col1 (String)

I am looking for an example of an insert statement that parses a string with
multi values separated by a comma. I want to parse these values and put one
Value, per row, into the same column.

Thanks

BrianDH

[Chris, Master of All Things Insignificant]

Do you want to use a stored procedure? Otherwise you will need to parse it
in VB code and send in multiple insert statements. (At least I know of no
other way)

Chris

"BrianDH" <Br*****@discus sions.microsoft .com> wrote in message
news:55******** *************** ***********@mic rosoft.com...

String = "val1, val2, va3, va4"
Insert value into col1 (String)

I am looking for an example of an insert statement that parses a string
with
multi values separated by a comma. I want to parse these values and put
one
Value, per row, into the same column.

Thanks

BrianDH

[BrianDH]

This is a one time deal. We have a string in a web form of about 45 email
address. what I want to do is parse the sting into a new table and stop
using this string and start managing these via the DB.

So yes use VB code.

"Chris, Master of All Things Insignifican" wrote:

Do you want to use a stored procedure? Otherwise you will need to parse it
in VB code and send in multiple insert statements. (At least I know of no
other way)

Chris

"BrianDH" <Br*****@discus sions.microsoft .com> wrote in message
news:55******** *************** ***********@mic rosoft.com...

String = "val1, val2, va3, va4"
Insert value into col1 (String)

I am looking for an example of an insert statement that parses a string
with
multi values separated by a comma. I want to parse these values and put
one
Value, per row, into the same column.

Thanks

BrianDH

[Chris, Master of All Things Insignificant]

Use the String.Split(", ") to break them up into an array. Then loop through
and insert them into the DB one by one.

Chris

"BrianDH" <Br*****@discus sions.microsoft .com> wrote in message
news:5C******** *************** ***********@mic rosoft.com...

This is a one time deal. We have a string in a web form of about 45 email
address. what I want to do is parse the sting into a new table and stop
using this string and start managing these via the DB.

So yes use VB code.

"Chris, Master of All Things Insignifican" wrote:

Do you want to use a stored procedure? Otherwise you will need to parse
it
in VB code and send in multiple insert statements. (At least I know of
no
other way)

Chris

"BrianDH" <Br*****@discus sions.microsoft .com> wrote in message
news:55******** *************** ***********@mic rosoft.com...

> String = "val1, val2, va3, va4"
> Insert value into col1 (String)
>
> I am looking for an example of an insert statement that parses a string
> with
> multi values separated by a comma. I want to parse these values and
> put
> one
> Value, per row, into the same column.
>
> Thanks
>
> BrianDH
>

[Cor Ligthert]

BrianDH,

And what is the problem?

Cor

[BrianDH]

Done!

Dim emailString As String = "val1, val2, val3, val4, val5"
Dim srString() = Split(emailStri ng, ";")
Dim intCount As Integer = srString.Length
Dim X As Integer = 0
Dim myCommand As New SqlCommand
Dim myTrans As SqlTransaction
Dim myConnString As String =
"Server=Server; Database=Databa se;UID=;PWD=;"
Dim myConnection As New SqlConnection(m yConnString)
'Open connection
myConnection.Op en()
' Start Transaction
myTrans = myConnection.Be ginTransaction( )
myCommand.Conne ction = myConnection
myCommand.Trans action = myTrans
Do Until X = intCount
myCommand.Comma ndText = "Insert into TableName (EmailAddress)
VALUES ('" & srString(X) & "')"
myCommand.Execu teNonQuery()
X = X + 1
Loop
' Commit transaction
myTrans.Commit( )
' Close Connection
myConnection.Cl ose()

"BrianDH" wrote:

String = “val1, val2, va3, va4�
Insert value into col1 (String)

I am looking for an example of an insert statement that parses a string with
multi values separated by a comma. I want to parse these values and put one
Value, per row, into the same column.

Thanks

BrianDH

[Cor Ligthert]

And Brian,

What was the reason (problem) in this I asked that you have sent the
question?

It are more classes which are used, so which one did give you problems?

Cor

[Cor Ligthert]

Complete humbug typing

That you have sent the message = Why you have sent the message