WinForm TextBox資料繫結

來源:互聯網
上載者:User
         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 表單上綁定到相同資料來源的資料繫結控制項進行同步的

=======================================================================

  DataSet ds = DataRepository.UsersProvider.GetAll().ToDataSet(true);
            BindingSource bs = new BindingSource();
            bs.DataSource = ds.Tables[0];

           bindingNavigator1.BindingSource = bs;            
           dataGridView1.DataSource = bs;
           textBox1.DataBindings.Add("Text", bs, ds.Tables[0].Columns[0].ColumnName);
           textBox2.DataBindings.Add("Text",bs, ds.Tables[0].Columns[1].ColumnName);

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.