|
-
Jan 8th, 2007, 09:44 PM
#1
Thread Starter
Member
SQL Express not saving anything. Help!
OK. I've asked a few questions here and have had a few problems along the way, but I think my problems might be due to visual basic, not my programming! I am using VB Express 2005 with a SQL 2005 database.
At first, I tried programming the database as code. I can get the new rows to add to memory. When I use the update command, it returns a number equal to the number of rows I'm trying to add. It looks like everything is working fine, but the data is never added to the database.
I can use the "database explorer" and add data manually and it works OK there.
Next, I tried not writing any code and just creating a new database, attaching it as a datasource, and dragging it over to my form as a datagrid. Same thing. I can add files to the datagrid but nothing is ever saved back to the .mdf file.
I've tried reinstalling VB and all SQL components but it hasn't helped. I don't know if there's some sharing violation that it can't write to the file? I've tried creating new apps and new databases. Are there other files I need to delete in addition to uninstalling the app? I don't know what else to try. Any help at all would be appreciated!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|