Click here to Skip to main content
15,867,704 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Attendance Machine IP Connected / Disconnected Pin
Gerry Schmitz11-Nov-22 6:50
mveGerry Schmitz11-Nov-22 6:50 
GeneralRe: Attendance Machine IP Connected / Disconnected Pin
Eddy Vluggen11-Nov-22 13:25
professionalEddy Vluggen11-Nov-22 13:25 
QuestionMaking VC++ 6 DLL to work on VB6 App with no UNICODE issue Pin
whiteboat27-Oct-22 19:28
whiteboat27-Oct-22 19:28 
AnswerRe: Making VC++ 6 DLL to work on VB6 App with no UNICODE issue Pin
Victor Nijegorodov27-Oct-22 20:43
Victor Nijegorodov27-Oct-22 20:43 
GeneralRe: Making VC++ 6 DLL to work on VB6 App with no UNICODE issue Pin
whiteboat27-Oct-22 21:24
whiteboat27-Oct-22 21:24 
QuestionVBApp with a Crystal Report in it. Where do I find it when published. Pin
KreativeKai27-Oct-22 6:21
professionalKreativeKai27-Oct-22 6:21 
AnswerRe: VBApp with a Crystal Report in it. Where do I find it when published. Pin
Richard Deeming27-Oct-22 21:09
mveRichard Deeming27-Oct-22 21:09 
QuestionUpdate Parent and Child Table Pin
EngrImad27-Oct-22 0:37
EngrImad27-Oct-22 0:37 
Hello every one;

the below Code is to update Parent and Child table,
the relationship between tables was set to (Relation only) on Data Designer,
But on SQL Server, Update and Delete Rule set to (Cascade)

with this setup Parent table was Updating ok,
but child table return (Added/Modified) changes as nothing and did not get update


I tried all cases to Set (Update-Delete-Accept/Reject) relationship Rules On Dataset Designer but did not solve the issue
Could advise what to do here
thanks in advance


VB
ParentTableBindingSource.EndEdit
Dim My_Parent_Modified As DataTable = DataSet1.ParentTable.GetChanges(DataRowState.Modified)
Dim My_Parent_Added As DataTable = DataSet1.ParentTable.GetChanges(DataRowState.Added)
Dim My_Parent_Deleted As DataTable = DataSet1.ParentTable.GetChanges(DataRowState.Deleted)

If My_Parent_ Modified Is Nothing = False Then
'Some Coding here
End if
If My_Parent_ Added Is Nothing = False Then
'Some Coding here
End if
If My_Parent_Deleted Is Nothing = False Then
'Some Coding here
End if
DataSet1.ParentTable.AcceptChanges


ChildTableBindingSource.EndEdit
Dim My_Child_Modified As DataTable = DataSet1.ChildTable.GetChanges(DataRowState.Modified)
Dim My_Child_Added As DataTable = DataSet1.ChildTable.GetChanges(DataRowState.Added)
Dim My_Child_Deleted As DataTable = DataSet1.ChildTable.GetChanges(DataRowState.Deleted)

If My_Child_ Modified Is Nothing = False Then
'Some Coding here
End if
If My_Child_ Added Is Nothing = False Then
'Some Coding here
End if
If My_Child_Deleted Is Nothing = False Then
'Some Coding here
End if
DataSet1.ChildTable.AcceptChanges

Imad


modified 27-Oct-22 7:02am.

AnswerRe: Update Parent and Child Table Pin
Richard MacCutchan27-Oct-22 1:36
mveRichard MacCutchan27-Oct-22 1:36 
GeneralRe: Update Parent and Child Table Pin
EngrImad27-Oct-22 1:41
EngrImad27-Oct-22 1:41 
Questionhow to do Scheduled task settings in conditions Tab "wake the computer to run this task" Pin
Member 1578241728-Sep-22 21:17
Member 1578241728-Sep-22 21:17 
QuestionVB.NET Pin
traore noor22-Sep-22 13:50
traore noor22-Sep-22 13:50 
AnswerRe: VB.NET Pin
Dave Kreskowiak22-Sep-22 15:10
mveDave Kreskowiak22-Sep-22 15:10 
AnswerRe: VB.NET Pin
Richard Deeming22-Sep-22 21:35
mveRichard Deeming22-Sep-22 21:35 
AnswerRe: VB.NET Pin
Eddy Vluggen25-Sep-22 5:44
professionalEddy Vluggen25-Sep-22 5:44 
QuestionCREATE DNS SERVER SOFTWARE Pin
Os.kamal22-Sep-22 8:02
Os.kamal22-Sep-22 8:02 
AnswerRe: CREATE DNS SERVER SOFTWARE Pin
Dave Kreskowiak22-Sep-22 15:07
mveDave Kreskowiak22-Sep-22 15:07 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
trønderen22-Sep-22 15:22
trønderen22-Sep-22 15:22 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Dave Kreskowiak23-Sep-22 3:02
mveDave Kreskowiak23-Sep-22 3:02 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Os.kamal25-Sep-22 4:21
Os.kamal25-Sep-22 4:21 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Gerry Schmitz23-Sep-22 5:48
mveGerry Schmitz23-Sep-22 5:48 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Os.kamal25-Sep-22 4:22
Os.kamal25-Sep-22 4:22 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Os.kamal25-Sep-22 4:19
Os.kamal25-Sep-22 4:19 
QuestionInserting button name into the txt.text box (VB) Pin
GamerzfanArcade10-Sep-22 14:16
GamerzfanArcade10-Sep-22 14:16 
AnswerRe: Inserting button name into the txt.text box (VB) Pin
Richard MacCutchan10-Sep-22 21:17
mveRichard MacCutchan10-Sep-22 21:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.