[otomatis]

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

[tlhIn`toq]

Did you really name one of your tables "Table"?
Do you also name your dog "Dog", or a button "Button"?
That sort of thing is just asking for trouble and confusion.

Just a thought.. Since it seems to be a collection of people, maybe naming it "Employees" or "Students" or "Patients" as applies to your use of it might make a little more sense - and help you determine where you are going wrong.

[MrShoes]

I'm sure I've seen this before... isn't "Table" a reserved word?

[Skydiver]

I must be missing it. Where in the code posted in Post #1 is there a table named "Table"? From what I can see, there is a table named "Name".

This post has been edited by Skydiver: 07 September 2012 - 12:01 PM

[tlhIn`toq]

Ok - 3 of us have now asked the OP if the table is really named that.
And they haven't replied. That was probably the problem and they can't be bothered to say 'thanks' or 'oops'. Personally I'm letting this one go