OLEDB Parameterized Query

by

Here is an example of how the parameterized queries work with CSharp, OleDB.

try
{
    connw.Open();
    OleDbCommand command;
    command = new OleDbCommand(
        "Update Deliveries " +
        "SET Deliveries.EmployeeID = ?, Deliveries.FIN = ?, Deliveries.TodaysOrders = ? , connw);
    command.Parameters.Add(new OleDbParameter("@EMPID", Convert.ToDecimal(empsplitIt[1])));
    command.Parameters.Add(new OleDbParameter("@FIN", truckSplit[1].ToString()));
    command.Parameters.Add(new OleDbParameter("@TodaysOrder", "R"));
    catchReturnedRows = command.ExecuteNonQuery();//Commit   
    connw.Close();

}
catch (OleDbException exception)
{
    MessageBox.Show(exception.Message, "OleDb Exception");
}

This will work with any sql statement, you must assign the question mark “?” to each parameter, and then below you must create the parameters and add them in the order of how you laid out the question marks to get the right data into the right field.

More Related Contents:

  1. How to create Microsoft Access database in C# programmatically?
  2. Question about terminating a thread cleanly in .NET
  3. Make an Installation program for C# applications and include .NET Framework installer into the setup
  4. Word wrap for a label in Windows Forms
  5. OleDbCommand parameters order and priority
  6. How do I get the title of the current active window using c#?
  7. How to compare two rich text box contents and highlight the characters that are changed?
  8. DataGridView bound to a Dictionary
  9. Passing a value from one form to another form
  10. What’s the difference between Application.ThreadException and AppDomain.CurrentDomain.UnhandledException?
  11. MVP examples for Windows Forms
  12. Change border color in TextBox C#
  13. How to know user has clicked “X” or the “Close” button?
  14. Hiding unwanted properties in custom controls
  15. Remove the title bar in Windows Forms
  16. C#: How to add subitems in ListView
  17. Remove Row inside TableLayoutPanel makes a layout problem
  18. Synchronize Scroll Position of two RichTextBoxes?
  19. How to create a Button that can send keys to a conrol without losing focus – Virtual Keyboard
  20. How to insert a record into a access table using oledb?
  21. Toggle switch control in Windows Forms
  22. WinForms DataGridView – databind to an object with a list property (variable number of columns)
  23. How do I prevent print screen
  24. Prevent from displaying of Windows Security window
  25. How to use dependency injection in WinForms
  26. Make a form’s background transparent
  27. Fire Form KeyPress event
  28. Prevent Winforms Designer from Generating Property Values for Inherited Controls
  29. How to create a Button that can send keys to a control without stealing the focus – Virtual Keyboard
  30. Do we have transactions in MS-Access?

Leave a Comment