Click here to Skip to main content
15,667,983 members
Home / Discussions / C#
   

C#

 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 4:11
ago248618-Mar-20 4:11 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 4:17
mvaOriginalGriff18-Mar-20 4:17 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 4:24
ago248618-Mar-20 4:24 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:01
mvaOriginalGriff18-Mar-20 5:01 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:12
ago248618-Mar-20 5:12 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:13
mvaOriginalGriff18-Mar-20 5:13 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:16
mvaOriginalGriff18-Mar-20 5:16 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:30
ago248618-Mar-20 5:30 
I just did it but I have an error: the function 'SCOPE_IDENTITY' not defined in the expression


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

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

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

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

}

GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:33
ago248618-Mar-20 5:33 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:39
mvaOriginalGriff18-Mar-20 5:39 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:42
ago248618-Mar-20 5:42 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 5:52
mvaOriginalGriff18-Mar-20 5:52 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 5:56
ago248618-Mar-20 5:56 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 6:01
mvaOriginalGriff18-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
mvaOriginalGriff18-Mar-20 6:11 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 6:51
ago248618-Mar-20 6:51 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 6:57
ago248618-Mar-20 6:57 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 7:05
mvaOriginalGriff18-Mar-20 7:05 
GeneralRe: problem retrieving info from one table to insert it into another Pin
ago248618-Mar-20 22:28
ago248618-Mar-20 22:28 
GeneralRe: problem retrieving info from one table to insert it into another Pin
OriginalGriff18-Mar-20 22:37
mvaOriginalGriff18-Mar-20 22:37 
QuestionC# ATTNDACE Pin
villanueva bryan17-Mar-20 12:01
villanueva bryan17-Mar-20 12:01 
AnswerRe: C# ATTNDACE Pin
OriginalGriff17-Mar-20 12:33
mvaOriginalGriff17-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
ago248616-Mar-20 6:53 
AnswerRe: problem to retrieve an info in a sql request / problème pour recéper une info dans une requête sql Pin
OriginalGriff16-Mar-20 6:59
mvaOriginalGriff16-Mar-20 6:59 

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.