怎么把程序裡得到的數據存入到datatable.help
如何把程序裡得到的數據存入到datatable.!!help
我現在程序裡得到了一個字符串,例:程序裡面有txtstring= "39od,08_style,sqasd ",怎麼把數據存入到datatable去。謝謝
------解决方案--------------------
Public Class Form1
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dt As DataTable ' 我这里没有加入列,是不能运行的
Dim dr As DataRow = dt.NewRow
Dim MultilineString As String ' 在这里我没办法给他赋值(多行字符串)
For Each str As String In MultilineString.Split(vbCrLf)
dr.ItemArray = str.Split( ", ") ' 加入数据
dt.Rows.Add(dr)
Next
End Sub
End Class
我現在程序裡得到了一個字符串,例:程序裡面有txtstring= "39od,08_style,sqasd ",怎麼把數據存入到datatable去。謝謝
------解决方案--------------------
Public Class Form1
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dt As DataTable ' 我这里没有加入列,是不能运行的
Dim dr As DataRow = dt.NewRow
Dim MultilineString As String ' 在这里我没办法给他赋值(多行字符串)
For Each str As String In MultilineString.Split(vbCrLf)
dr.ItemArray = str.Split( ", ") ' 加入数据
dt.Rows.Add(dr)
Next
End Sub
End Class