WinForm:对TextBox数据绑定的浏览

        private DataTable dtStore;
        
private System.Windows.Forms.TextBox txtID;
        
private System.Windows.Forms.TextBox txtName;
        
private System.Windows.Forms.BindingManagerBase BindingDataManager;
        
private void frmDemo_Load(object sender, System.EventArgs e)
        
{
            initForm();
        }

        
private void btnFirst_Click(object sender, System.EventArgs e)
        
{
            BindingDataManager.Position 
= 0;
        }


        
private void btnPre_Click(object sender, System.EventArgs e)
        
{
            BindingDataManager.Position 
-= 1;
        }


        
private void btnNext_Click(object sender, System.EventArgs e)
        
{
            BindingDataManager.Position 
+= 1;
        }


        
private void btnLast_Click(object sender, System.EventArgs e)
        
{
            BindingDataManager.Position 
= BindingDataManager.Count -1;
        }

        
private void initForm()
        
{
            
string strConn = @"Server=(local)\NETSDK;User id=sa;Pwd=sa;Database=Northwind";
            StringBuilder sbSQL 
= new StringBuilder();
            sbSQL.Append(
"select EmployeeID, FirstName + ' ' + LastName as EmployeeName ");
            sbSQL.Append(
"from Employees");

            SqlDataAdapter da 
= new SqlDataAdapter( sbSQL.ToString(), conn );

            dtStore 
= new DataTable();
        
            da.Fill( dtStore );    
            
            txtID.DataBindings.Clear();
            txtName.DataBindings.Clear();

            txtID.DataBindings.Add( 
"Text", dtStore, dtStore.Columns[0].ColumnName );
            txtName.DataBindings.Add( 
"Text", dtStore, dtStore.Columns[1].ColumnName );

            BindingDataManager 
= this.BindingContext[ dtStore ];
        }
BindingManagerBase是对Windows 窗体上绑定到相同数据源的数据绑定控件进行同步的
posted @ 2006-06-03 13:55  Tim工作室  阅读(2621)  评论(1编辑  收藏  举报