Split function in vb.net

Question

Hi  I have one txt file where data is there like - name1 address1 contactnumber1 name2address2 contactnumber2 ............ ......... ....... now i am inserting this data in database table using split function but it's working for first line only. How it will go to next line???

rachayita jaiswal · Answer

Hi I myself got this split function. thanks for reply

rachayita jaiswal · Answer

Dim filename As String = C:\Users\Rachayita\Desktop	est_rach.txt Dim query As String Dim data As String = System.IO.File.ReadAllText(filename) Dim latitude longitude address1 address2 As String Dim test As String() = data.Split() latitude = test(0).ToString() longitude = test(1).ToString() address1 = test(2).ToString() address2 = test(3).ToString() query = insert into test_rach values (' + latitude + '' + longitude + '' + address1 + '' + address2 + ') Dim dtConnection As New OdbcConnection(ConfigurationManager.ConnectionStrings(DBConnection).ToString) dtConnection.Open() Dim cmd As New OdbcCommand(query dtConnection) cmd.ExecuteNonQuery() cmd.Parameters.Clear() dtConnection.Close() and text file data is - latitude1 longitude1 address11 address21 latitude2 longitude2 address12 address22 latitude3 longitude3 address13 address23

Jaganathan Bantheswaran · Answer

How are you inserting into DB? show us the code?