Hi All,
i have a problem...I have a project from my collage to create a working database software using SQL compact 3.5 and writen on VB2008Express because it's free.....
All fine...until i recently decided to update a table in database... when i made my modifications in the grid view than hit the save button on the table manager it says that i'm not using a valid update rule.....
here's a part from the code...
Private Sub PuPRegistarBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PuPRegistarBindingNavigatorSaveItem.Click
Me.Validate()
Me.PuPRegistarBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.InfodataDataSet1)
End Sub
Right i'm trying to update any row and any column in a table....meaning to update everything in the table and clicking the save button and save the data to the database.....
PLEASE HELP!
ps: Also i have problem with my search engine...
I'm using a query for it...but it only searches for single word....I'd like to search two or more....
a sample of the query
SELECT npored, nnaaktaidata, [vhnomernamolbata/data], kadnomernapodzemlenimotiupi, nnakvartal, vazlojitel, vidinaimenovanie, [adm.adres]
FROM Reg_aktovete_uzakoniavane
WHERE (nnakvartal LIKE N'%' + @nnakvartal + N'%')
Best regards Viktor
i have a problem...I have a project from my collage to create a working database software using SQL compact 3.5 and writen on VB2008Express because it's free.....
All fine...until i recently decided to update a table in database... when i made my modifications in the grid view than hit the save button on the table manager it says that i'm not using a valid update rule.....
here's a part from the code...
Private Sub PuPRegistarBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PuPRegistarBindingNavigatorSaveItem.Click
Me.Validate()
Me.PuPRegistarBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.InfodataDataSet1)
End Sub
Right i'm trying to update any row and any column in a table....meaning to update everything in the table and clicking the save button and save the data to the database.....
PLEASE HELP!
ps: Also i have problem with my search engine...
I'm using a query for it...but it only searches for single word....I'd like to search two or more....
a sample of the query
SELECT npored, nnaaktaidata, [vhnomernamolbata/data], kadnomernapodzemlenimotiupi, nnakvartal, vazlojitel, vidinaimenovanie, [adm.adres]
FROM Reg_aktovete_uzakoniavane
WHERE (nnakvartal LIKE N'%' + @nnakvartal + N'%')
Best regards Viktor
Last edited: