save data to disc

Please help me?

I use sql express + C#, and when i execute my queries like "insert" into table, my data exist in dataset while i compile my project.
How i can save my data to my data source, and how i can see my data in my table in data source?

Please help me, how i can save my data from dataset into disc file mdf.

hi,

depending on your "use", you should check the InsertCommand of your object is accordingly set to your needs..

but, as you say you are using an Express edition of VS, chances are you actually save your "changes" to the datasource, but you "overwrite" the existing database physical files at each application start-up becouse of User Instances features and how you set the "Copy to Output Directory" property of the database's files... if you set it to "Copy Always", your changes will always be lost as the modified database's files will be overwritten at each application start-up by the old unmodified database physical files..

regards

|||Thank you Andrea, you are the best.|||It was very helpful for me!

thx