Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
penguin15793
Starting Member
10 Posts |
 Posted - 2008-05-19 : 09:00:35
|
| I'm using vs2008 programming in the latest vb.net and am pretty new to sql server. I looked up tuts and such to save changes to databases after I understood on how to connect to them get them to display and such. This is my code when I hit the "Save" button. It worked last time I was working on the program, now it doesn't, when I load up the program sometimes (i'm not sure why or under what circumstances) it'll load up the changes I made to the database through the datagrid and saved, but others it won't. What am I doing wrong? Here's my code: Private Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click Try Me.Validate() Me.FinancialBindingSource.EndEdit() Me.FinancialTableAdapter.Update(Me.myDataSet.Financial) Catch ex As Exception MsgBox("Update failed") End Try End Subedit: It saves, but not completely. By that I mean, it'll save, but i'm not sure if it actually saves to the database or not. It will load back up with the data that I modified fine..unless I change any code in the program. Even if I just add a comment, the data reloads with the original data. However, if I don't touch code, it'll save my data fine. Why does it do this? |
|
|
penguin15793
Starting Member
10 Posts |
Posted - 2008-05-20 : 12:26:03
|
| bump? |
 |
|
|
|
|
|
saving changes to database, errors