How to edit datagridview using SqlCeDataAdapter?
- by DanSogaard
I've a frmEdit with datagridview that's bouned to this:
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?, tried using this:
using (SqlCeDataAdapter a = new SqlCeDataAdapter(sqlqry1, conn))
{
DataTable dt1 = new DataTable();
a.Fill(dt1);
dataGridView1.DataSource = dt1;
a.Update(dt1);
}
Nothing.
Is there anyway?.
