Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.46 KB | None | 0 0
  1. public void Insert(string name, string address)
  2. {
  3.     string query = "INSERT INTO Table VALUES (?name, ?address)";
  4.     try
  5.     {
  6.         connection.Open();
  7.         MySqlCommand cmd = new MySqlCommand
  8.         MySqlParameter param = new MySqlParameter("?name", name);
  9.         cmd.Parameter.Add(param);
  10.         param = new MySqlParameter("?address", address);
  11.         cmd.Parameter.Add(param);
  12.         cmd.ExecuteNonQuery();
  13.         connection.Close();
  14.     }
  15.     catch (Exception e)
  16.     {
  17.         Console.WriteLine(e.Message);
  18.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement