I have been looking for an answer to what shouldn't be too hard of a question to answer, yet nobody can answer it. I have found literally hundreds of people asking the same question with 0 replies every single time.

The question? how do you save data from a datagridview to an SQL database?

is it even possible? seems stupid that it wouldn't be possible, but since nobody knows how, I'm starting to wonder.

I would REALLY like to make a program that can access and save data to an SQL database using VB 2005 express edition and sql express server.. is it not possible?

I have watched several hour long videos on the subject. I have read tons of documention. I have searched endlessly, all to no avail. nothing works.

how would someone programically save data to an SQL database in VB 2005? what commands would there be? is there somewhere on the internet where there is an example that acutally works? is there some unknown setting that needs to be set to enable the writing to the database? I get no errors with the code and it returns a number indicating the number of lines written to the database, which is suppose to mean it was successful, but I close out the program, reopen, and it wasn't saved.

This is beginning to be VERY frustrating as I have a company who wants me to write a simple database program for them, and it would be easy if only I could somehow save data to it. (I will also need to figure out how to access the database remotely, another thing I see 0 info on the net about, but that is later on)

Thanks for taking the time to read this, and please, if you know anything that might help, please respond.