Click here to Skip to main content
14,605,926 members
   

C#

 
AnswerRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 3:50
mveOriginalGriff18-Mar-20 3:50 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 4:11
Memberago248618-Mar-20 4:11 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 4:17
mveOriginalGriff18-Mar-20 4:17 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 4:24
Memberago248618-Mar-20 4:24 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:01
mveOriginalGriff18-Mar-20 5:01 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:12
Memberago248618-Mar-20 5:12 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:13
mveOriginalGriff18-Mar-20 5:13 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:16
mveOriginalGriff18-Mar-20 5:16 
OK, the edited version makes a little more sense.
You need to split your command into two: Do the INSERT, then build a new Command to do the SELECT (some DB engines don't like command chaining). As long as you use the same connection and you don't close it in between the INSERT and SELECT, you'll be fine.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:30
Memberago248618-Mar-20 5:30 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:33
Memberago248618-Mar-20 5:33 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:39
mveOriginalGriff18-Mar-20 5:39 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:42
Memberago248618-Mar-20 5:42 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:52
mveOriginalGriff18-Mar-20 5:52 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:56
Memberago248618-Mar-20 5:56 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 6:01
mveOriginalGriff18-Mar-20 6:01 
GeneralRe: problem retrieving info from one table to insert it into another Pin
Luc Pattyn18-Mar-20 6:04
sitebuilderLuc Pattyn18-Mar-20 6:04 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 6:11
mveOriginalGriff18-Mar-20 6:11 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 6:51
Memberago248618-Mar-20 6:51 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 6:57
Memberago248618-Mar-20 6:57 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 7:05
mveOriginalGriff18-Mar-20 7:05 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 22:28
Memberago248618-Mar-20 22:28 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 22:37
mveOriginalGriff18-Mar-20 22:37 
QuestionC# ATTNDACE Pin
villanueva bryan17-Mar-20 12:01
Membervillanueva bryan17-Mar-20 12:01 
AnswerRe: C# ATTNDACE Pin
OriginalGriff17-Mar-20 12:33
mveOriginalGriff17-Mar-20 12:33 
Questionproblem to retrieve an info in a sql request / problème pour recéper une info dans une requête sql Pin
ago248616-Mar-20 6:53
Memberago248616-Mar-20 6:53 

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.