Have do I save data in an Access database using Visual Studio 2005 Express, C# .NET?

Question

I hope you are a C# .NET professional, because this is a nasty problem ;-)

I'd like to design an application that connects to an Access database.

Using Visual Studio 2005 Express Edition, I added the Access database to the Data Connections window (and the .mdb file is also shown in the solution explorer).

Next to that, I added a new DataSet related to the .mdf file.

Using this handy drag and drop technique I quickly added a DataGridView to my Designer surface.

If I run the program in Debug mode, add new records and hit the Save button, it seems to save the dataset back into the database (this idea is confirmed by the fact that the tableAdapter.Update() method returns a non-zero value).

However, if I rerun the program or look into my database using Access, nothing has changed.

Does anyone know what's going on?

Notice that I don't have this problem if I use an SQL database

Answer 1

Hi,



You might want to check that the Intenet Guest Account (IUSR_YOURCOMPNAME) has write access to the directory where your Access database is located. This account is used when connecting anonymously to IIS through a browser. :)

Answer 2

If I am not wrong, Access file is MDB, not MDF.



MDF is SQL Database file.



So I think you have the data update done into the SQL database rather than Access. (And you thinking is done on Access)

Answer 3

I majored in lit in college. i might say for this poem, you like some historic past on the poet. It starts off out kinda unhappy, with the view. 'Futures i've got divorced' maximum like refers to abandoned hopes and targets. The 'do no longer look back' and knife reference is probable approximately getting over painful thoughts. That it no longer cuts implies desire. Or in all probability numbness. The stuff on complacency probable ability he feels he enable somebody down by utilising no longer doing something he ought to have finished. as a result the accusatory voices. The final paragraph is a little greater complicated. My experience is that the narrator discovered his existence instructions and acted as a result, as a result the significant reward. This guy feels like a soldier to me. one that believes that no longer taking action at some needed 2d led to others harm. Now he's grew to become that approach around, and located some peace. He gave up previous and futile tries and took a various way of residing, and he's beginning as much as detect his existence greater precious. i do no longer many times like poems, yet my mothers and fathers spents 1000's that they did no longer have so i ought to learn how to interpret then. i'm greater approximately novels, nonetheless. back, you will probable earnings from understanding something of this author's existence. This one is exceedingly very own, previous the final experience of the sweetness and cruelty of the international I often see in lesser poems.