Introduction:
A DataTable is a class of Disconnected architecture in the .NET Framework. It is found
in the System.Data namespace and represents a single table. We can create a
table and can add columns and rows of that table. Now, we will create an F# application
and use the DataTable class.
Step 1: Create an F# application.
Step 2: First go-to Solution Explorer and right click on References.
Step 3: Click on Add References. Then a
pop-up window with caption Add Reference will open:
Step 4: Click at .Net on Add
Reference window and select System.Windows.Forms, System.Drawing
and System.Data with holding down Ctrl key and click on ok.
Step 5: We write the following F# code
on progrma.fs file. Here I am creating a table and adding columns as ID,
F_NAME, L_NAME, SALARY. Look at the following code.
open
System
open
System.Data.SqlClient
open
System.Windows.Forms
open System.Data
open
System.Drawing
//----------- Creating Form and User Controls
let frm =
new Form(Height = 300, Width = 500)
let dg =
new DataGrid(Left = 20, Top = 20, Height = 200,
Width = 350)
dg.BackColor <- Color.LightGray
//----------- Adding DataGrid
frm.Controls.Add(dg)
//----------- Creating DataTable Object as dt
let dt =
new DataTable()
//----------- Creating Different Object of DataColumn
let dc1 =
new DataColumn("ID")
let dc2 =
new DataColumn("F_NAME")
let dc3 =
new DataColumn("L_NAME")
let dc4 =
new DataColumn("SALARY")
//----------- Adding Columns to DataTable
dt.Columns.Add(dc1)
dt.Columns.Add(dc2)
dt.Columns.Add(dc3)
dt.Columns.Add(dc4)
//----------- DataBinding
dg.DataSource <-dt
Output: