|
-
Jul 27th, 2011, 07:28 PM
#1
Thread Starter
Lively Member
[RESOLVED] Database not updating
Hello, I am working with an MSSQL database, but I have a problem ( which previously, I've not encountered ).
Basically, whenever I try to update a row in my database, it works, but as soon as I restart the application, the changed information resets.
Example:
Code:
Dim UN As String = DirectCast(Items(1), String)
Dim R As LeafDataSet1.UsersRow = DB.Users.FindByUsername(UN)
If Not R Is Nothing Then
R.Username = "Test"
End If
Users.Update(DB)
Items(1) is the username. R basically does a select statement, and then if R is found, it changes the username to 'Test'. This works, but when I restart my server and try the new username, it goes back to my previous username (I.E it doesn't work).
Any more information I'll be happy to provide. Thank you.
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
|