Click here to Skip to main content
15,850,545 members
Home / Discussions / C#
   

C#

 
Generalrecording problem Pin
ago248617-Mar-20 1:47
ago248617-Mar-20 1:47 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 2:24
mveOriginalGriff17-Mar-20 2:24 
GeneralRe: recording problem Pin
ago248617-Mar-20 3:07
ago248617-Mar-20 3:07 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 3:13
mveOriginalGriff17-Mar-20 3:13 
GeneralRe: recording problem Pin
ago248617-Mar-20 3:21
ago248617-Mar-20 3:21 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 3:34
mveOriginalGriff17-Mar-20 3:34 
GeneralRe: recording problem Pin
ago248617-Mar-20 3:40
ago248617-Mar-20 3:40 
GeneralRe: recording problem Pin
ago248617-Mar-20 3:43
ago248617-Mar-20 3:43 
I even tried this if, I have the same error


using (sql_cmd = sql_con.CreateCommand())
                           {
                              string txtQuery = "INSERT INTO Detail_temp (ref_det, qute_det, Designation, Prix_unitaire_HT, Prix_total_HT) VALUES (@ref_det, @qute_det, @Designation, @Prix_unitaire_HT, @Prix_total_HT)";
                             OleDbParameter refprod = sql_cmd.Parameters.AddWithValue("@ref_det", OleDbType.VarChar);
                             refprod.Value = TxtRefProduit.Text;
                             OleDbParameter qtecmd = sql_cmd.Parameters.AddWithValue("@qute_det", OleDbType.VarChar);
                             qtecmd.Value = TxtQteCmd.Text;
                             OleDbParameter design = sql_cmd.Parameters.AddWithValue("@Designation", OleDbType.VarChar);
                             design.Value = TxtDesignation.Text;
                             OleDbParameter prixU = sql_cmd.Parameters.AddWithValue("@Prix_unitaire_HT", OleDbType.Integer);
                             prixU.Value = TxtPrixUnitaire.Text;
                             OleDbParameter prixT = sql_cmd.Parameters.AddWithValue("@Prix_total_HT", OleDbType.Integer);
                             prixT.Value = total;


                              sql_cmd = new OleDbCommand(txtQuery, sql_con);
                              sql_cmd.ExecuteNonQuery();

                           }

GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 3:51
mveOriginalGriff17-Mar-20 3:51 
GeneralRe: recording problem Pin
ago248617-Mar-20 4:02
ago248617-Mar-20 4:02 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 4:17
mveOriginalGriff17-Mar-20 4:17 
GeneralRe: recording problem Pin
ago248617-Mar-20 4:24
ago248617-Mar-20 4:24 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 4:38
mveOriginalGriff17-Mar-20 4:38 
GeneralRe: recording problem Pin
ago248617-Mar-20 4:52
ago248617-Mar-20 4:52 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 5:08
mveOriginalGriff17-Mar-20 5:08 
GeneralRe: recording problem Pin
ago248617-Mar-20 5:28
ago248617-Mar-20 5:28 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 5:31
mveOriginalGriff17-Mar-20 5:31 
GeneralRe: recording problem Pin
ago248617-Mar-20 5:39
ago248617-Mar-20 5:39 
AnswerRe: recording problem Pin
ZurdoDev17-Mar-20 3:39
professionalZurdoDev17-Mar-20 3:39 
GeneralRe: recording problem Pin
OriginalGriff17-Mar-20 3:52
mveOriginalGriff17-Mar-20 3:52 
GeneralRe: recording problem Pin
ZurdoDev17-Mar-20 3:59
professionalZurdoDev17-Mar-20 3:59 
GeneralRe: recording problem Pin
Luc Pattyn17-Mar-20 13:08
sitebuilderLuc Pattyn17-Mar-20 13:08 
GeneralRe: recording problem Pin
ago248617-Mar-20 23:04
ago248617-Mar-20 23:04 
GeneralRe: recording problem Pin
Luc Pattyn17-Mar-20 23:18
sitebuilderLuc Pattyn17-Mar-20 23:18 
GeneralRe: recording problem Pin
ago248618-Mar-20 0:20
ago248618-Mar-20 0:20 

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.