Click here to Skip to main content
14,540,332 members
   

C#

 
AnswerRe: How to solve 100 Doors Kata using TDD in C# Pin
Bohdan Stupak19-Mar-20 5:12
professionalBohdan Stupak19-Mar-20 5:12 
Questionproblem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 3:13
Memberago248618-Mar-20 3:13 
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 
Ok my apologies, this is the error I get
System.Data.Oledb.Ole Exception (0x80040E14): Character found after the end of the Sql instruction


using (OleDbCommand cmd1 = sql_con.CreateCommand())
                   {

                       cmd1.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com);" + "SELECT SCOPE_IDENTITY()";

                       int id;
                       cmd1.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);

                       cmd1.ExecuteNonQuery();
                       id = (int)cmd1.ExecuteScalar();
                       TxtNunCmd.Text = id.ToString();

                   }

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 
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 

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.