WinForms中的PetaPoco

Question

如何使用PetaPoco提交在DataGridView中完成的更改？类似于：

namespace PetaPocoTest
{
    public partial class Form1 : Form
    {
        PetaPoco.Database db = new PetaPoco.Database("PgConnection");

        IEnumerable<customers> allCustomers;


        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            allCustomers = db.Query<customers>("SELECT * FROM customers");
            mGrid.DataSource = allCustomers .ToList();            
        }

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            db.Save("customers", "custumer_id", allCustomers);
        }
    }
}

Answer 1

试用我的答案Here

到目前为止，这是最简单、最容易的方法，可以做任何你想做的事情

Answer 2

我终于明白了。我只是在一些显而易见的事情上浪费了几个小时：

namespace PetaPocoTest
{
    public partial class Form1 : Form
    {
        PetaPoco.Database db = new PetaPoco.Database("PgConnection");

        IEnumerable<customers> allCustomers;


        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            allCustomers = db.Query<customers>("SELECT * FROM customers");
            mGrid.DataSource = allCustomers .ToList();            
        }

        private void simpleButton1_Click(object sender, EventArgs e)
        {
             foreach (var a in allCustomers)
             {
               db.Save("customers", "custumer_id", a);
             }
        }
    }
}