Constraints on Database
-
I am relatively new to database concepts, so please forgive any incorrect terminology. I have created a custom query that gets a users data based on the user name they have entered, when i put this line in code:
Me.UsersTableAdapter1.FillByUserName(PasswordManagerDataSet1.Users, UNTextBox.Text)I get an error to do with constraints, but i don't understand why. Also i get a concurrency violation error when i try to update a record after filling a table using a custom query. Fill:Me.PasswordTableAdapter.FillPasswords(Me.PasswordManagerDataSet1.Password, User)I also get a constraints issue here. I am trying to update using the automatic stuff VS2005 adds (i.e. the save button in the navigation bar it adds). This is the save code:Me.Validate() Me.PasswordBindingSource.EndEdit() Me.PasswordTableAdapter.Update(Me.PasswordManagerDataSet1.Password)Please check out my articles: The ANZAC's articles
-
I am relatively new to database concepts, so please forgive any incorrect terminology. I have created a custom query that gets a users data based on the user name they have entered, when i put this line in code:
Me.UsersTableAdapter1.FillByUserName(PasswordManagerDataSet1.Users, UNTextBox.Text)I get an error to do with constraints, but i don't understand why. Also i get a concurrency violation error when i try to update a record after filling a table using a custom query. Fill:Me.PasswordTableAdapter.FillPasswords(Me.PasswordManagerDataSet1.Password, User)I also get a constraints issue here. I am trying to update using the automatic stuff VS2005 adds (i.e. the save button in the navigation bar it adds). This is the save code:Me.Validate() Me.PasswordBindingSource.EndEdit() Me.PasswordTableAdapter.Update(Me.PasswordManagerDataSet1.Password)Please check out my articles: The ANZAC's articles
The ANZAC wrote:
Me.UsersTableAdapter1.FillByUserName(PasswordManagerDataSet1.Users, UNTextBox.Text) I get an error to do with constraints, but i don't understand why.
What are the constraints in the database?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon