Visual C#中的数据绑定操作

核心提示： 得到了ComboBox组件对本地数据库的数据绑定程序，也就十分方便的得到ComboBox组件绑定Sql Server 2000源程序代码（Combox02.cs）具体如下：public class Form1 : Form{private ComboBox ComboBox1 ;priva

得到了ComboBox组件对本地数据库的数据绑定程序，也就十分方便的得到ComboBox组件绑定Sql Server 2000源程序代码（Combox02.cs）具体如下：

public class Form1 : Form{private ComboBox ComboBox1 ;private Button button1 ;private System.Data.DataSet myDataSet ;private System.ComponentModel.Container components = null ;public Form1 ( ){file://打开数据链接，得到数据集GetConnect ( ) ;InitializeComponent ( ) ;}file://清除程序中使用过的资源protected override void Dispose ( bool disposing ){if ( disposing ){if ( components != null ) {components.Dispose ( ) ;}}base.Dispose ( disposing ) ;}private void GetConnect ( ){// 设定数据连接字符串，此字符串的意思是打开Sql server数据库，服务器名称为server1,数据库为data1string strCon = "Provider = SQLOLEDB.1 ; Persist Security Info = False ; User ID = sa ; Initial Catalog = data1 ; Data Source = server1 " ;OleDbConnection myConn = new OleDbConnection ( strCon ) ;myConn.Open ( ) ;string strCom = " SELECT * FROM person " ;file://创建一个 DataSetmyDataSet = new DataSet ( ) ;file://用 OleDbDataAdapter 得到一个数据集OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ;file://把Dataset绑定person数据表myCommand.Fill ( myDataSet , " person " ) ;file://关闭此OleDbConnectionmyConn.Close ( ) ;}private void button1_Click ( object sender , System.EventArgs e ){ComboBox1.DataSource = myDataSet ;ComboBox1.DisplayMember = "person.xm" ;ComboBox1.ValueMember = "person.xm" ;}static void Main ( ) {Application.Run ( new Form1 ( ) ) ;}}