![M?t s? thao t¨¢c v?i Data Binding Author : Xcross87 2007
Page 1 of 3
Data Binding l¨¤ c¨¢ch mapping c¨¢c th¨¤nh ph?n c?a m?t data source v¨¤o m?t th¨¤nh ph?n GUI v¨¤ t? ??ng
l¨¤m vi?c v?i d? li?u. V¨ª d? c¨® th? bind m?t c?t (col) v¨¤o m?t TextBox qua thu?c t¨ªnh Text ho?c c¨® th?
bind c? m?t table v¨¤o DataGrid nh? DataGridView.
C¨® 2 c¨¢ch b¨¬n WinForm control v¨¤o d? li?u :
? Simple
? Complex
Simple Data Binding
L¨¤ c¨¢ch li¨ºn k?t m?t-m?t gi?a m?t thu?c t¨ªnh c?a control v¨¤ m?t th¨¤nh ph?n c?a data source, v¨¤ s? d?ng
control ?? hi?n th? duy nh?t m?t gi¨¢ tr? m?t l?n.
Th? m?t v¨ª d? :
T?o Winform App project, t?i Form1 b?n cho th¨ºm 2 textbox v¨¤o.
Sau ?¨® trong s? ki?n : Form1_Load b?n ch¨¨n th¨ºm ?o?n code sau :
[code]
private void Form1_Load(object sender, EventArgs e)
{
string connString = @"Server = .SQLEXPRESS;
Integrated Security = true;
Database = Northwind";
string sql = @"SELECT * FROM employees ";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "employees");
textBox1.DataBindings.Add("text", ds, "employees.firstname");
textBox2.DataBindings.Add("text", ds, "employees.lastname");
}
[/code]
Sau ?¨® run th¨¬ th?y textbox1 l¨¤ gi¨¢ tr? firstname ??u ti¨ºn trong record v¨¤ textbox l¨¤ gi¨¢ tr? lastname t??ng
?ng.
Complex Data Binding
L¨¤ li¨ºn k?t m?t control v?i m?t ho?c nhi?u th¨¤nh ph?n data c?a data source, c¨® th? hi?n th? nhi?u h?n 1
gi¨¢ tr? m?t l?n.
T?o m?t WinForm App project. Th¨ºm v¨¤o m?t DataGridView, sau ?¨® hi?n ra DataGridView Task ch?n
Choose Data Source -> Add Project -> ch?n Database -> New Connection -> SQL Server, Northwind
Database -> Next ??n khi n¨¤o th?y m?c ch?n Table cho DataSet th¨¬ ch?n table : Customers r?i Finish
Build -> Ctrl + F5 xem k?t qu? thu ???c](https://image.slidesharecdn.com/cachsudungdatabinding-140404120250-phpapp02/85/Cach-su-dung-databinding-1-320.jpg)
![M?t s? thao t¨¢c v?i Data Binding Author : Xcross87 2007
Page 2 of 3
Binding Manager Class
T?o m?t WinForm App project.
??t v¨¤o 2 textbox v¨¤ 2 button
Trong ph?n code c?a Form1.cs b?n ch¨¨n code sau :
[code]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace SQLServerManger
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
// T?o BindingManager
private BindingManagerBase bMgr;
// S? ki?n Form1_Load
private void Form1_Load(object sender, EventArgs e)
{
// T?o connection string
string connString = @"Server = .SQLEXPRESS;
Integrated Security = true;
Database = Northwind";
// T?o Sql Query
string sql = @"SELECT * FROM employees ";
// T?o connectioon
SqlConnection conn = new SqlConnection(connString);
// T?o Adapter
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
// T?o DataSet
DataSet ds = new DataSet();
// L?p ??y DataSet
da.Fill(ds, "employees");
// Bind gi¨¢ tr? c?t firstname v¨¤o textbox1
textBox1.DataBindings.Add("text", ds, "employees.firstname");
// Bind gi¨¢ tr? c?t lastname v¨¤o textbox2
textBox2.DataBindings.Add("text", ds, "employees.lastname");
// C¨¤i Binding Manager v¨¤o DataSet ?? qu?n l?
bMgr = this.BindingContext[ds, "employees"];
}
// L?y record ti?p theo](https://image.slidesharecdn.com/cachsudungdatabinding-140404120250-phpapp02/85/Cach-su-dung-databinding-2-320.jpg)
![M?t s? thao t¨¢c v?i Data Binding Author : Xcross87 2007
Page 3 of 3
private void button2_Click(object sender, EventArgs e)
{
bMgr.Position += 1;
}
// Tr? l?i record tr??c
private void button1_Click(object sender, EventArgs e)
{
bMgr.Position -= 1;
}
}
}
[/code]
Ph?n n¨¤y m¨¬nh ch?ng c¨® g¨¬ bi?t nhi?u h?t ch? th? th?i. ??ng ngh? l¨¤ Data Binding d? nh¨¦, ph?c t?p l?m ?¨®.
Ch?ng qua l¨¤ code c?a Data Binding ???c Generate t? d?ng n¨ºn m¨¬nh c¨® th? l¨¤m thao t¨¢c ??n gi?n th?
n¨¤y. Nh?ng n?u th? n¨¤y th¨¬ c?ng kh?ng hay l?m v¨¬ kh?ng hi?u c¨¢ch th?c l¨¤m vi?c c?a n¨®. T¨®m l?i l¨¤ sao
c?ng ???c.
K?t th¨²c v? Data Binding.](https://image.slidesharecdn.com/cachsudungdatabinding-140404120250-phpapp02/85/Cach-su-dung-databinding-3-320.jpg)
![B¨¤i gi?ng ng?n ng? l?p tr¨¬nh c c++ ph?m h?ng th¨¢i[bookbooming.com]](https://cdn.slidesharecdn.com/ss_thumbnails/bigingngnnglptrnhcc-phmhngthibookbooming-com-121016234941-phpapp01-thumbnail.jpg?width=560&fit=bounds)
More Related Content
What's hot (20)
Viewers also liked (12)
Similar to Cach su dung databinding (20)
More from truong le hung (9)
Recently uploaded (18)
![[PPT11] B¨¤i 7 - ??c - V¨¤ t?i v?n mu?n m?....ppt](https://cdn.slidesharecdn.com/ss_thumbnails/ppt11bi7-c-vtivnmunm-250305063122-6e221a47-thumbnail.jpg?width=560&fit=bounds)
![[PPT11] B¨¤i 7 - ??c - C¨¤ Mau qu¨º x?.pptx](https://cdn.slidesharecdn.com/ss_thumbnails/ppt11bi7-c-cmauqux-250305070313-62766c8d-thumbnail.jpg?width=560&fit=bounds)
Cach su dung databinding
- 1. M?t s? thao t¨¢c v?i Data Binding Author : Xcross87 2007 Page 1 of 3 Data Binding l¨¤ c¨¢ch mapping c¨¢c th¨¤nh ph?n c?a m?t data source v¨¤o m?t th¨¤nh ph?n GUI v¨¤ t? ??ng l¨¤m vi?c v?i d? li?u. V¨ª d? c¨® th? bind m?t c?t (col) v¨¤o m?t TextBox qua thu?c t¨ªnh Text ho?c c¨® th? bind c? m?t table v¨¤o DataGrid nh? DataGridView. C¨® 2 c¨¢ch b¨¬n WinForm control v¨¤o d? li?u : ? Simple ? Complex Simple Data Binding L¨¤ c¨¢ch li¨ºn k?t m?t-m?t gi?a m?t thu?c t¨ªnh c?a control v¨¤ m?t th¨¤nh ph?n c?a data source, v¨¤ s? d?ng control ?? hi?n th? duy nh?t m?t gi¨¢ tr? m?t l?n. Th? m?t v¨ª d? : T?o Winform App project, t?i Form1 b?n cho th¨ºm 2 textbox v¨¤o. Sau ?¨® trong s? ki?n : Form1_Load b?n ch¨¨n th¨ºm ?o?n code sau : [code] private void Form1_Load(object sender, EventArgs e) { string connString = @"Server = .SQLEXPRESS; Integrated Security = true; Database = Northwind"; string sql = @"SELECT * FROM employees "; SqlConnection conn = new SqlConnection(connString); SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); da.Fill(ds, "employees"); textBox1.DataBindings.Add("text", ds, "employees.firstname"); textBox2.DataBindings.Add("text", ds, "employees.lastname"); } [/code] Sau ?¨® run th¨¬ th?y textbox1 l¨¤ gi¨¢ tr? firstname ??u ti¨ºn trong record v¨¤ textbox l¨¤ gi¨¢ tr? lastname t??ng ?ng. Complex Data Binding L¨¤ li¨ºn k?t m?t control v?i m?t ho?c nhi?u th¨¤nh ph?n data c?a data source, c¨® th? hi?n th? nhi?u h?n 1 gi¨¢ tr? m?t l?n. T?o m?t WinForm App project. Th¨ºm v¨¤o m?t DataGridView, sau ?¨® hi?n ra DataGridView Task ch?n Choose Data Source -> Add Project -> ch?n Database -> New Connection -> SQL Server, Northwind Database -> Next ??n khi n¨¤o th?y m?c ch?n Table cho DataSet th¨¬ ch?n table : Customers r?i Finish Build -> Ctrl + F5 xem k?t qu? thu ???c
- 2. M?t s? thao t¨¢c v?i Data Binding Author : Xcross87 2007 Page 2 of 3 Binding Manager Class T?o m?t WinForm App project. ??t v¨¤o 2 textbox v¨¤ 2 button Trong ph?n code c?a Form1.cs b?n ch¨¨n code sau : [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Text; using System.Windows.Forms; namespace SQLServerManger { public partial class Form1 : Form { public Form1() { InitializeComponent(); } // T?o BindingManager private BindingManagerBase bMgr; // S? ki?n Form1_Load private void Form1_Load(object sender, EventArgs e) { // T?o connection string string connString = @"Server = .SQLEXPRESS; Integrated Security = true; Database = Northwind"; // T?o Sql Query string sql = @"SELECT * FROM employees "; // T?o connectioon SqlConnection conn = new SqlConnection(connString); // T?o Adapter SqlDataAdapter da = new SqlDataAdapter(sql, conn); // T?o DataSet DataSet ds = new DataSet(); // L?p ??y DataSet da.Fill(ds, "employees"); // Bind gi¨¢ tr? c?t firstname v¨¤o textbox1 textBox1.DataBindings.Add("text", ds, "employees.firstname"); // Bind gi¨¢ tr? c?t lastname v¨¤o textbox2 textBox2.DataBindings.Add("text", ds, "employees.lastname"); // C¨¤i Binding Manager v¨¤o DataSet ?? qu?n l? bMgr = this.BindingContext[ds, "employees"]; } // L?y record ti?p theo
- 3. M?t s? thao t¨¢c v?i Data Binding Author : Xcross87 2007 Page 3 of 3 private void button2_Click(object sender, EventArgs e) { bMgr.Position += 1; } // Tr? l?i record tr??c private void button1_Click(object sender, EventArgs e) { bMgr.Position -= 1; } } } [/code] Ph?n n¨¤y m¨¬nh ch?ng c¨® g¨¬ bi?t nhi?u h?t ch? th? th?i. ??ng ngh? l¨¤ Data Binding d? nh¨¦, ph?c t?p l?m ?¨®. Ch?ng qua l¨¤ code c?a Data Binding ???c Generate t? d?ng n¨ºn m¨¬nh c¨® th? l¨¤m thao t¨¢c ??n gi?n th? n¨¤y. Nh?ng n?u th? n¨¤y th¨¬ c?ng kh?ng hay l?m v¨¬ kh?ng hi?u c¨¢ch th?c l¨¤m vi?c c?a n¨®. T¨®m l?i l¨¤ sao c?ng ???c. K?t th¨²c v? Data Binding.