如何使用命令构建器 [英] how to use command builder
本文介绍了如何使用命令构建器的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何使用命令构建器,并且没有命令构建器来在后端tabel中显示数据
how to use command builder,and without command builder to sve data in back end tabel
推荐答案
下面的代码将帮助你........ ..
//了解更多关于F#的信息://fsharp.net
// --------------导入命名空间
open系统
打开System.Windows.Forms
open System.Drawing
open System.Data.SqlClient
open System.Data
// -------------连接字符串
让constr = @数据源= SERVER_NAME;初始目录=学生;集成安全性=真
// -------------创建表单和用户控件
let frm = new Form()
let dg = new DataGrid(Top = 20,Left = 30,Height = 180,Width = 300)
dg.BackColor< - Color.LightBlue
让btn =新按钮(顶部= 200,左边= 50,高度= 20,宽度= 60)
btn.BackColor< - Color.LightSeaGreen
btn.Text< - 更新
frm.Controls.Add(dg)
frm.Controls.Add(btn)
// ----------------创建DataAdapter
让da = new SqlDataAdapter(select *来自std_record,constr)
// ----------------创建数据集
let ds = new DataSet()
da.Fill(ds)|>忽略
dg.DataSource< - ds.Tables。[0]
// -----------------按钮点击
btn.Click.Add(fun _ - >
// ----------------创建CommandBuilder
let comndbuil = new SqlCommandBuilder(da)
da.Update(ds)|>忽略
MessageBox.Show(记录更新)|>忽略
)
Application.Run(frm)
更多帮助请访问以下链接.. .......
http://www.c-sharpcorner.com/U ploadFile / 718fc8 / updates-record-using-commandbuilder-class-in-fsharp / [ ^ ]
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/[^]
这篇关于如何使用命令构建器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文