vb.net创建数据表? [英] vb.net creating data table?
本文介绍了vb.net创建数据表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何将10行与三列转换为DataSet / DataTable?
行如下所示:
项目1,$ 100,44
项目-2,$ 42,3
etc
解决方案
Dim Table1 As DataTable
Table1 = New DataTable(TableName)
Dim column1 As DataColumn = New DataColumn(Column1)
column1.DataType = System.Type.GetType(System.String)
Dim column2 As DataColumn = New DataColumn(Column2)
column2.DataType = System.Type.GetType(System.Int32)
Dim column3 As DataColumn = New DataColumn(Column2)
column3.DataType = System.Type.GetType(System.Int32)
Table1.Columns.Add(column1)
Table1.Columns。添加(column2)
Table1.Columns.Add(column3)
Dim Row1 As DataRow
Row1 = Table1.NewRow()
Row1.Items(Column1)=Item1
Row1.Items(Column2)= 44
Row1.Items(Column3)= 99
Table1.Rows.Add(Row1)
'对其他行重复
I'm using vb.net / winforms. How can I convert 10 lines with three columns into a DataSet/DataTable?
Lines are something like this:
Item-1, $100, 44
Item-2, $42, 3
etc
解决方案
Dim Table1 As DataTable
Table1 = New DataTable("TableName")
Dim column1 As DataColumn = New DataColumn("Column1")
column1.DataType = System.Type.GetType("System.String")
Dim column2 As DataColumn = New DataColumn("Column2")
column2.DataType = System.Type.GetType("System.Int32")
Dim column3 As DataColumn = New DataColumn("Column2")
column3.DataType = System.Type.GetType("System.Int32")
Table1.Columns.Add(column1)
Table1.Columns.Add(column2)
Table1.Columns.Add(column3)
Dim Row1 As DataRow
Row1 = Table1.NewRow()
Row1.Items("Column1") = "Item1"
Row1.Items("Column2") = 44
Row1.Items("Column3") = 99
Table1.Rows.Add(Row1)
' Repeat for other rows
这篇关于vb.net创建数据表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文