Click here to Skip to main content
16,015,679 members
Home / Discussions / C#
   

C#

 
AnswerRe: Create Custom File Property/Attribute Pin
OriginalGriff22-Mar-20 10:14
mveOriginalGriff22-Mar-20 10:14 
GeneralRe: Create Custom File Property/Attribute Pin
Kevin Marois22-Mar-20 13:02
professionalKevin Marois22-Mar-20 13:02 
AnswerRe: Abuse Standard File Property/Attribute Pin
Luc Pattyn22-Mar-20 10:36
sitebuilderLuc Pattyn22-Mar-20 10:36 
GeneralRe: Abuse Standard File Property/Attribute Pin
Kevin Marois22-Mar-20 13:04
professionalKevin Marois22-Mar-20 13:04 
Questionupdate problem Pin
ago248619-Mar-20 23:31
ago248619-Mar-20 23:31 
AnswerRe: update problem Pin
OriginalGriff20-Mar-20 0:03
mveOriginalGriff20-Mar-20 0:03 
GeneralRe: update problem Pin
ago248620-Mar-20 0:08
ago248620-Mar-20 0:08 
GeneralRe: update problem Pin
ago248620-Mar-20 2:52
ago248620-Mar-20 2:52 
Sir I am happy because I was able to find a solution, its not easy because I really did not know how to go about it to see what is wrong. but I was able to post my request in a texbox to see what was wrong. I do not know my code is clean but the update is done.
How to find the code?


C#
using (OleDbCommand cmd4 = sql_con.CreateCommand())
                                   {

                                       //setConnection();
                                       OleDbCommand QteStock = sql_con.CreateCommand();
                                       QteStock.CommandText = "SELECT Quantite FROM Catalogue";
                                       sql_con.Open();
                                       int LastQteStock = Convert.ToInt32(QteStock.ExecuteScalar());
                                       sql_con.Close();
                                       string query = "UPDATE Catalogue SET Quantite = (@quantite - @QteStc) WHERE Code_article = (@code_article)";
                                       cmd4.CommandText = query;
                                       MessageBox.Show(query);
                                       cmd4.Parameters.AddWithValue("@quantite", LastQteStock);
                                       cmd4.Parameters.AddWithValue("@QteStc", Qte_prod);
                                       cmd4.Parameters.AddWithValue("@code_article", ref_prod);
                                       sql_con.Open();
                                       cmd4.ExecuteNonQuery();
                                       sql_con.Close();

                                   }

GeneralRe: update problem Pin
OriginalGriff20-Mar-20 3:00
mveOriginalGriff20-Mar-20 3:00 
GeneralRe: update problem Pin
ago248620-Mar-20 3:10
ago248620-Mar-20 3:10 
Questionproblem to make a second recording Pin
ago248618-Mar-20 23:58
ago248618-Mar-20 23:58 
AnswerRe: problem to make a second recording Pin
OriginalGriff19-Mar-20 0:06
mveOriginalGriff19-Mar-20 0:06 
GeneralRe: problem to make a second recording Pin
ago248619-Mar-20 0:29
ago248619-Mar-20 0:29 
GeneralRe: problem to make a second recording Pin
OriginalGriff19-Mar-20 0:35
mveOriginalGriff19-Mar-20 0:35 
GeneralRe: problem to make a second recording Pin
ago248619-Mar-20 0:48
ago248619-Mar-20 0:48 
GeneralRe: problem to make a second recording Pin
OriginalGriff19-Mar-20 0:52
mveOriginalGriff19-Mar-20 0:52 
GeneralRe: problem to make a second recording Pin
ago248619-Mar-20 0:59
ago248619-Mar-20 0:59 
GeneralRe: problem to make a second recording Pin
ago248619-Mar-20 2:06
ago248619-Mar-20 2:06 
GeneralRe: problem to make a second recording Pin
OriginalGriff19-Mar-20 2:26
mveOriginalGriff19-Mar-20 2:26 
GeneralRe: problem to make a second recording Pin
ago248619-Mar-20 3:04
ago248619-Mar-20 3:04 
GeneralRe: problem to make a second recording Pin
OriginalGriff19-Mar-20 3:22
mveOriginalGriff19-Mar-20 3:22 
GeneralRe: problem to make a second recording Pin
ago248619-Mar-20 3:27
ago248619-Mar-20 3:27 
QuestionRe: problem to make a second recording Pin
ZurdoDev19-Mar-20 3:51
professionalZurdoDev19-Mar-20 3:51 
QuestionHow to solve 100 Doors Kata using TDD in C# Pin
User-862169518-Mar-20 5:30
User-862169518-Mar-20 5:30 
AnswerRe: How to solve 100 Doors Kata using TDD in C# Pin
Bohdan Stupak19-Mar-20 5:12
professionalBohdan Stupak19-Mar-20 5:12 

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.