Click here to Skip to main content
15,920,633 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: How to search and show with Text Box from Access Database in VB.Net 2010? Pin
Maciej Los9-Oct-14 11:10
mveMaciej Los9-Oct-14 11:10 
AnswerRe: How to search and show with Text Box from Access Database in VB.Net 2010? Pin
Otekpo Emmanuel9-Oct-14 14:16
Otekpo Emmanuel9-Oct-14 14:16 
GeneralRe: How to search and show with Text Box from Access Database in VB.Net 2010? Pin
Kelven DeJaVu11-Oct-14 6:08
Kelven DeJaVu11-Oct-14 6:08 
QuestionDataAnnotations - Multiple Acceptable Values Pin
Dominick Marciano8-Oct-14 7:32
professionalDominick Marciano8-Oct-14 7:32 
AnswerRe: DataAnnotations - Multiple Acceptable Values Pin
Richard Deeming9-Oct-14 22:45
mveRichard Deeming9-Oct-14 22:45 
GeneralDroptiles Pin
KokDavy8-Oct-14 4:58
KokDavy8-Oct-14 4:58 
GeneralRe: Droptiles Pin
Tim Carmichael8-Oct-14 7:27
Tim Carmichael8-Oct-14 7:27 
QuestionCompare tables and show the difference Pin
byka8-Oct-14 2:35
byka8-Oct-14 2:35 
AnswerRe: Compare tables and show the difference Pin
Praneet Nadkar8-Oct-14 2:51
Praneet Nadkar8-Oct-14 2:51 
GeneralRe: Compare tables and show the difference Pin
byka8-Oct-14 3:08
byka8-Oct-14 3:08 
GeneralHighchart server side settings and update Pin
KokDavy6-Oct-14 13:09
KokDavy6-Oct-14 13:09 
GeneralRe: Highchart server side settings and update Pin
Dave Kreskowiak6-Oct-14 17:43
mveDave Kreskowiak6-Oct-14 17:43 
QuestionThe state value of an object ? Pin
dilkonika4-Oct-14 16:52
dilkonika4-Oct-14 16:52 
AnswerRe: The state value of an object ? Pin
Dave Kreskowiak4-Oct-14 18:53
mveDave Kreskowiak4-Oct-14 18:53 
GeneralRe: The state value of an object ? Pin
dilkonika5-Oct-14 3:39
dilkonika5-Oct-14 3:39 
GeneralRe: The state value of an object ? Pin
Dave Kreskowiak5-Oct-14 5:00
mveDave Kreskowiak5-Oct-14 5:00 
QuestionAdding records and save changes simultaneosly for 2 tables Pin
dilkonika3-Oct-14 11:04
dilkonika3-Oct-14 11:04 
AnswerRe: Adding records and save changes simultaneosly for 2 tables Pin
Eddy Vluggen3-Oct-14 12:49
professionalEddy Vluggen3-Oct-14 12:49 
AnswerRe: Adding records and save changes simultaneosly for 2 tables Pin
Eddy Vluggen6-Oct-14 9:12
professionalEddy Vluggen6-Oct-14 9:12 
I haven't used EF before, so this might not apply. Then again, using BindingSources takes away some repetitive and boring code, but also introduces a bit of a black box.

Your resulting copy-table would also include its own PK and have the original PK as a FK as shown in your example. That means waiting until the record is inserted into table 1, before it can be inserted into table 2. Means you probably can't simply "link" them.

A simpeler idea is to use (spit*) triggers. You simply copy the entire record into an exact copy of the table. The fun thing is that it allows you to reuse the queries designed for table1 on table2. Also works at the database-layer, taking another responsibility away from the client.

*) It is required to spit when talking about triggers.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

Questioni want add/edit/delete access table in database on vb2010 Pin
Member 105203861-Oct-14 1:01
Member 105203861-Oct-14 1:01 
AnswerRe: i want add/edit/delete access table in database on vb2010 Pin
Richard MacCutchan1-Oct-14 4:37
mveRichard MacCutchan1-Oct-14 4:37 
SuggestionRe: i want add/edit/delete access table in database on vb2010 Pin
ZurdoDev2-Oct-14 5:00
professionalZurdoDev2-Oct-14 5:00 
QuestionMove a file according to a name inside the file itself. Pin
val566230-Sep-14 19:08
val566230-Sep-14 19:08 
AnswerRe: Move a file according to a name inside the file itself. Pin
Eddy Vluggen2-Oct-14 4:44
professionalEddy Vluggen2-Oct-14 4:44 
QuestionProblem with entity objects after refreshing model from database Pin
dilkonika30-Sep-14 11:34
dilkonika30-Sep-14 11:34 

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.