C# with MySQL INSERT parameters

by

You may use AddWithValue method like:

string connString = ConfigurationManager.ConnectionStrings["default"].ConnectionString;
MySqlConnection conn = new MySqlConnection(connString);
conn.Open();
MySqlCommand comm = conn.CreateCommand();
comm.CommandText = "INSERT INTO room(person,address) VALUES(@person, @address)";
comm.Parameters.AddWithValue("@person", "Myname");
comm.Parameters.AddWithValue("@address", "Myaddress");
comm.ExecuteNonQuery();
conn.Close();

OR

Try with ? instead of @, like:

string connString = ConfigurationManager.ConnectionStrings["default"].ConnectionString;
MySqlConnection conn = new MySqlConnection(connString);
conn.Open();
MySqlCommand comm = conn.CreateCommand();
comm.CommandText = "INSERT INTO room(person,address) VALUES(?person, ?address)";
comm.Parameters.Add("?person", "Myname");
comm.Parameters.Add("?address", "Myaddress");
comm.ExecuteNonQuery();
conn.Close();

Hope it helps…

More Related Contents:

  1. Bulk copy a DataTable into MySQL (similar to System.Data.SqlClient.SqlBulkCopy)
  2. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0
  3. How To Access Two Databases in a Single connection String in C#?
  4. Exception: There is already an open DataReader associated with this Connection which must be closed first
  5. Bulk-deleting in LINQ to Entities
  6. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  7. MySqlCommand Command.Parameters.Add is obsolete
  8. LINQ to SQL multiple tables left outer join
  9. Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
  10. Convert DateTime for MySQL using C#
  11. Get the id of inserted row using C#
  12. Why do I get “System.Data.DataRowView” instead of real values in my WinForms Listbox?
  13. Local database, I need some examples
  14. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  15. Entity Framework creates a plural table name, but the view expects a singular table name?
  16. How can I update a cell value in a dB table, using SQL Server CE and C# (Visual Studio 2010)
  17. Received an invalid column length from the bcp client for colid 6
  18. How to create an Access database at runtime in C#?
  19. MySql Last Insert ID, Connector .net
  20. How to COUNT rows within EntityFramework without loading contents?
  21. How do I test database-related code with NUnit?
  22. Authentication with old password no longer supported, use 4.1 style passwords
  23. Index (zero based) must be greater than or equal to zero
  24. Can I commit changes to actual database while debugging C# in Visual Studio?
  25. Connection to MySQL from .NET using SSH.NET Library
  26. Will a using block close a database connection?
  27. How to use String property as primary key in Entity Framework
  28. What is the fastest way to read data from a DbDataReader?
  29. Incorrect string value: ‘\xEF\xBF\xBD’ for column
  30. Is it possible to perform joins across different databases using LINQ?

Leave a Comment