Can't update a table

I can't update a table in my app, i did this once, but i didn't save the changes, and now i cant do it, i don't even remember if i needed something more in my code, i'm updating using the TableAdapter.

I'm using .NET 2.0 and the changes in the table are made directly trough the Datagrid, the update statement is like this:

ClientTableAdapter.Update(Club_DataDataSet.Client);

Thank you, I'd appreciate your help

ooooh i think i found what the problem was

I added the database to my project, but if i copy the data file to the project the source points to the DB in my project, and it doesn't seem to be updating when i run the app in VS because the dataset, tableadapter and bindingsource are pointing to the same DB but in SQL Server.( i mean, NOT in the data file in my project jeje)

Everything works fine when the app is installed. ..at least in my own PC, i haven't tried in another computer

i just found and read something about that and i think it help me a lot to understand some things about local data files

...i'm new at databases using VS, so if i'm wrong in anything i wrote in this post, please let me know

|||

Ok....what's wrong? i added the data file to my project, but my app can't load the DB if i stop the SQL service in my computer, and neither if i install my app in another PC (i just tried that today) that doesn't have SQL installed (that's my main goal) ...i mean, the DB it's suppose to be in my project, IT IS in the folder...i was told that clickonce allows to use an SQL DB as an Access DB...in what aspects? or what i'm i doing wrong?

And when i added the data file, the only files i can add is Northwind and Pubs and maybe some others...but why i can't add my own DBs? , it sends the "...can't open file..." error message if a choose another file

Please help me, i think i'm really lost at this

Thank you