.NET development environment for Linux

เอาไว้ศึกษาเกี่ยวกับ Table (elbaT) ใน vb.net

http://vb.net-informations.com/datagridview/vb.net_datagridview_database.htm

http://www.codeproject.com/KB/grid/practicalguidedatagrids1.aspx#_Toc56951001


ศึกษาเกี่ยวกับ .Net & Linux

http://mono-project.com/Main_Page

VB.Net Example
vb2005
http://msdn.microsoft.com/en-us/vbasic/ms789075.aspx#winforms
vb2008
http://code.msdn.microsoft.com/vb2008samples
vb2010
http://code.msdn.microsoft.com/vb2010samples

VB.Net connect to vfp data
'TODO: This line of code loads data into the 'DataSet1.table1' table. You can move, or remove it, as needed.
''Me.Table1TableAdapter.Fill(Me.DataSet1.table1)
'' http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k%28EHINDEXOUTOFRANGE%29;k%28TargetFrameworkMoniker-%22.NETFRAMEWORK%2cVERSION%3dV4.0%22%29;k%28DevLang-VB%29&rd=true

Dim ConnectionString As String

ConnectionString = "Provider = VFPOLEDB;Data Source=D:\;Mode=Read;Collating Sequence=MACHINE;"

''"Provider=Microsoft.Jet.OLEDB.4.0;" & _
'' "Data Source=D:\;Extended Properties=dBase IV"
Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(ConnectionString)
dBaseConnection.Open()

Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT * FROM TABLE1", dBaseConnection)
Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader = dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)

While dBaseDataReader.Read
'MessageBox.Show(dBaseDataReader.FieldCount.ToString)
Console.WriteLine(dBaseDataReader.Item(0).ToString)
Console.WriteLine(dBaseDataReader.Item(1).ToString)
Console.WriteLine(dBaseDataReader.Item(2).ToString)
Console.WriteLine(dBaseDataReader.Item(3).ToString)
'Console.WriteLine(dBaseDataReader("Column1").ToString)
'Console.WriteLine(dBaseDataReader("Column2").ToString)
'Console.WriteLine(dBaseDataReader("Column3").ToString)
End While

dBaseConnection.Close()