从数据表更新数据库时出错 [英] Error when updating database from datatable

问题描述

大家好，

从数据表更新数据库时出现此错误.

{更新无法找到TableMapping ["Table"]或DataTable"Table".}

这是我的代码(已修改):

Hi All,

I got this error when updating database from datatable.

{"Update unable to find TableMapping[''Table''] or DataTable ''Table''."}

Here is my code (modified) :

SqlCeDataAdapter da = new SqlCeDataAdapter("SELECT * FROM Name", con);
DataSet ds = new DataSet();
da.Fill(ds, "Name");
foreach (DataRow dr in ds.Tables["Name"].Rows)
{
    Console.WriteLine(dr["FirsName"] + "\t" + dr["NickName"] + "\t" + dr["Address"] + "\t" + dr["Gender"]);
    dr["Gender"]="Male";
}
da.Update(ds);
Console.Write("Press Enter to continue:");
Console.ReadLine();

有帮助吗?

谢谢

Any Help??

Thanks

推荐答案

使用commandBuilder会解决您的问题.

Use commandBuilder yr problem will be solved.

SqlCeDataAdapter da = new SqlCeDataAdapter("SELECT * FROM Name", con);
DataSet ds = new DataSet();
da.Fill(ds, "Name");
foreach (DataRow dr in ds.Tables["Name"].Rows)
{
    Console.WriteLine(dr["FirsName"] + "\t" + dr["NickName"] + "\t" + dr["Address"] + "\t" + dr["Gender"]);
    dr["Gender"]="Male";
}
SqlCommandBuilder sqlcmdBuild = new SqlCommandBuilder(da);
da.Update(ds.Tables["Name"]);
Console.Write("Press Enter to continue:");
Console.ReadLine(); 

希望这会起作用

Hope this will work

使用

da.Update(ds,"Name");

而不是

da.Update(ds);

这篇关于从数据表更新数据库时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！