如何使用SqlCeDataAdapter编辑datagridview？

Question

我有一个带有 datagridview 的 frmEdit ，它与此相关：

string sqlqry1 = "select p_Name from Items where p_Id=" + p_Id;
        using (SqlCeDataAdapter a = new SqlCeDataAdapter(sqlqry1, conn))
        {
            DataTable dt1 = new DataTable();
            a.Fill(dt1);
            dataGridView1.DataSource = dt1;
        }

How to edit cells and save them back to the db?，尝试使用这个：

using (SqlCeDataAdapter a = new SqlCeDataAdapter(sqlqry1, conn))
        {
            DataTable dt1 = new DataTable();
            a.Fill(dt1);
            dataGridView1.DataSource = dt1;
            a.Update(dt1);
        }

Nothing。

到底还有吗？

Answer 1

找到解决方案：

        SqlCeDataAdapter da;
        SqlCeCommandBuilder cmdBuilder;


        da = new SqlCeDataAdapter("select * from Items", conn);
        cmdBuilder = new SqlCeCommandBuilder(da);
        da.Fill(myDatabaseDataSet, "Items");
        myDatabaseDataSet.Tables["Items"].Rows[0]["p_Name"] = dataGridView1.Rows[0].Cells["p_Name"].Value.ToString();
        da.Update(myDatabaseDataSet, "Items"); 

Answer 2

DataTable dT;
BindingSource bS;

using (SqlCeConnection yourConnection = new SqlCeConnection("Data Source=|DataDirectory|\\YourDatabase.sdf"))
{
    dT = new DataTable();
    bS = new BindingSource();    

    string query = "SELECT * FROM table01";
    SqlCeDataAdapter dA = new SqlCeDataAdapter(query, yourConnection);
    SqlCeCommandBuilder cBuilder = new SqlCeCommandBuilder(dA);
    dA.Fill(dT);

    bS.DataSource = dT;
    dgv01.DataSource = bS;
}

由于该页面在谷歌上的排名，因此用一个工作示例来复活它。