DataGridView绑定DataTable的建议方式

发布时间 2023-10-10 12:32:45作者: soliang

DataGridView绑定DataTable的建议方式

1. 将DataTable 绑定到BindingSource

2. 将BindingSource绑定到DataGridView

3. DataGridView修改完要从Datatable取值时,同步过去时,BindingSource和DataGridView两个都要执行EndEdit()

public partial class Form1 : Form
    {
        DataTable mTable = new DataTable();
        BindingSource mbs = new BindingSource();
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            mTable.Columns.Add("Name",typeof(string));
            mTable.Columns.Add("Age", typeof(float));
            mTable.Columns.Add("Dept", typeof(string));
            mTable.Columns.Add("IsDeleted", typeof(bool));
            mTable.Rows.Add("Jack", 21, "C1", false);
            mTable.Rows.Add("Rose", 21, "C2", false);
            mTable.Rows.Add("Tom", 21, "C1", false);
            mTable.Rows.Add("Micky", 21, "C1", false);
            mTable.Rows.Add("Steven Chou", 21, "C1", false);
            mbs.DataSource = mTable;
            grd.DataSource = mbs;
        }

        private void BtnDel_Click(object sender, EventArgs e)
        {
            mTable.Rows.Remove(mTable.Rows[grd.CurrentRow.Index]);
        }

        private void BtnSave_Click(object sender, EventArgs e)
        {
            grd.EndEdit();
            mbs.EndEdit();

            int N = mTable.Rows.Count;            
        }
    }