¸üÐÂaccessÊý¾Ý¿âµÄÎÊÌâ

ÏÂÃæÊÇ´úÂ룺

OleDbDataAdapter da = new OleDbDataAdapter("select * from Grade", objConnection);
DataSet ds = new DataSet();
da.Fill(ds, "Grade");
DataTable myDataTable = ds.Tables["Grade"];

// update table
ds.Tables["Grade"].Rows[1]["CL1"] = "CCCCCC";
da.Update(ds,"Grade");

ÔÚÖ´Ðе½×îºóÒ»¾äµÄʱºòÌáʾÎÒ¡°Update requires a valid UpdateCommand when passed DataRow collection with modified rows".

ÎÒ¾ÍÊÇÏëÓÃDatasetÕâÖÖ·½Ê½¸üУ¬ÇëÎÊÔõô¸ü¸ÄÄØ£¿

---

ÄãµÄ±í½á¹¹µÄÎÊÌâ°Ñ.. Ìùϱí½á¹¹

---

µ±´«µÝ¾ßÓÐÒÑÐÞ¸ÄÐеÄDataRow ¼¯ºÏʱ£¬¸üÐÂÒªÇóÓÐЧµÄUpdateCommand
AccessÀïÏàÓ¦µÄ±íÊÇ·ñÓÐÖ÷¼ü

---

ds.Tables["Grade"].Rows[1]["CL1"] = "CCCCCC";¹À¼ÆÊÇÕâ¾ä³öÎÊÌâÁË

---

ÐèÒªÐ޸ĹýµÄÊý¾Ý±í£¡£¡£¡
ÄãÌá½»µÄÊÇûÓÐÐ޸ĹýµÄ°É

---

ÒýÓÃ

ÄãµÄ±í½á¹¹µÄÎÊÌâ°Ñ.. Ìùϱí½á¹¹

ÏÂÃæÊÇÎҵıí½á¹¹£º
CL1 CL2 CL3 CL4 ID
No F 50 6 4
A F 80 2 5
B M 9 8 6
C F 78 3 7
D M 345 4 8

---

ÒýÓÃ

µ±´«µÝ¾ßÓÐÒÑÐÞ¸ÄÐеÄDataRow ¼¯ºÏʱ£¬¸üÐÂÒªÇóÓÐЧµÄUpdateCommand
AccessÀïÏàÓ¦µÄ±íÊÇ·ñÓÐÖ÷¼ü

Ö÷¼üÓ¦¸Ã¾ÍÊÇIDÄÇÒ»ÁÐÊÇ×Ô¶¯Éú³ÉµÄ¡£

---

ÒýÓÃ

ds.Tables["Grade&