Be seen. Boost your question’s priority for more expert views and faster solutions
dim arVals() as string
dim SQL as string
arVals = Split(TabDelimitedString, vbTab)
'set up a command object w/ connection string ... details omitted
SQL = "Insert Into MyTable(Field1, Field2, ...FieldN) Values (@Val1, @Val2, ...@ValN)"
cmd.CommandText = Sql
'next block is psuedocode
foreach Val in arVals
cmd.Parameters.Append New Param for this value
next
cmd.executeNonQuery
dim arVals() as string
dim SQL as string
dim i as Int32
arVals = Split(TabDelimitedString, vbTab)
'set up a command object w/ connection string ... details omitted
SQL = "Insert Into MyTable(Field1, Field2, Field3, Field4) Values (@Val1, @Val2, @val3, @Val4)"
cmd.CommandText = Sql
cmd.Parameters.append (new SqlClient.SqlParameter("@Val1", SqlDBType.DateTime
cmd.Parameters.append (new SqlClient.SqlParameter("@Val2", SqlDBType.Float
cmd.Parameters.append (new SqlClient.SqlParameter("@Val3", SqlDBType.Float
cmd.Parameters.append (new SqlClient.SqlParameter("@Val4", SqlDBType.Float
for i = 0 to (arVals.LBound-1 ) /4
cmd.Parameters("@Val1).Value = arVals(i*4)
cmd.Parameters("@Val2).Value = arVals(i*4) +1
cmd.Parameters("@Val3).Value = arVals(i*4) +2
cmd.Parameters("@Val4).Value = arVals(i*4) +3
cmd.ExecuteNonQuery
next i
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
The string is tab-delimited ... should each element be a different row? Or each a different field in a single row?