I have textbox like =101,102,103,104
I want to save this value in ArrayList in following format
GVNo
-----
101
102
103
104
Later save in following table in gvno column
My table is issuedDetailId, detailId, gvno` in SQL Server 2008 and vb.net 2010
then how do i store in detail table using for loops i never used arralylist before. and gvno field in table is numeric type
Dim vasList() As String = Split(TextBox1.Text,",")
This code will store the splitted text into the arraylist,
Dim xArrayList As ArrayList = New ArrayList(TextBox1.text.Split(","))
If all you want to save your string entries straight to the database I think you should do something like this:
Dim test As String = "string1, string2, string3, string4"
With MyDBConnection
Dim transaction As OleDbTransaction
Try
Call .Open()
transaction = .BeginTransaction()
With .CreateCommand()
.Transaction = transaction
For Each entry As String In test.Split(","c)
.CommandText = String.Format("INSERT INTO [Table] ([Column]) VALUES ({0})", entry)
Call .ExecuteNonQuery()
Next
End With
Call transaction.Commit()
Catch ex As Exception
' Handle exception here
Call transaction.Rollback()
Finally
Call .Close()
End Try
End With
This will take the strings and insert them as is into the database. As you are taking user input you should really use a parameters in your query instead of a simple string like I am doing here...
If you need to do validation the string, use the '.split' function before accessing the database. You can do something like Dim MyArray() as string = MyInput.Split(","c) to dump the values into an array.
Hope this helps you.
