Hi,
I have a table whit fields: keyid , fire , key1
I insert record this table white miltiline textbox,
every line in multiline textbox insert in new row in table:
i use this code for insert:
Dim lines As String() = Me.TextBox2.Text.Split(New [Char]() {ControlChars.Lf}, StringSplitOptions.RemoveEmptyEntries)
Dim x As Integer = lines.Length
Dim read As TextReader = New System.IO.StringReader(TextBox2.Text)
Dim rows As Integer = x
Dim text1 As String() = New String(rows - 1) {}
For r As Integer = 0 To rows - 1
text1(r) = read.ReadLine()
Dim constr As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
...
Go to the complete details ...