how to use command builder

Belowing code will help you..........




// Learn more about F# at http://fsharp.net
//-------------- Importing Namespace
open System
open System.Windows.Forms
open System.Drawing
open System.Data.SqlClient
open System.Data

//------------- Connection String
let constr = @"Data Source=SERVER_NAME;Initial Catalog=STUDENT;Integrated Security=True"

//------------- Creating Form and User Controls
let frm = new Form()
let dg = new DataGrid(Top =20, Left =30, Height =180, Width =300)
dg.BackColor <- Color.LightBlue
let btn = new Button(Top = 200, Left =50,Height =20, Width =60)
btn.BackColor <- Color.LightSeaGreen
btn.Text <- "Update"
frm.Controls.Add(dg)
frm.Controls.Add(btn)

//---------------- Creating DataAdapter
let da = new SqlDataAdapter("select * from std_record", constr)

//---------------- Creating DataSet
let ds = new DataSet()
da.Fill(ds)|>ignore
dg.DataSource <- ds.Tables.[0]

//----------------- Button Click
btn.Click.Add(fun _->
//---------------- Creating CommandBuilder
let comndbuil = new SqlCommandBuilder(da)
da.Update(ds)|>ignore
MessageBox.Show("Record Updated")|>ignore
)
Application.Run(frm)



for More Help Visit on Following link...............
http://www.c-sharpcorner.com/UploadFile/718fc8/updating-record-using-commandbuilder-class-in-fsharp/[^]