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 窗体上绑定到相同数据源的数据绑定控件进行同步的

转载于:https://www.cnblogs.com/timsoft/articles/416511.html