using
System;
using System.Collections.Generic;
using System.Text;
using MySql.Data.MySqlClient;
using System.Configuration;
using System.Data;
namespace testMSQL
... {
class Program
...{
static void Main(string[] args)
...{
string connString = ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString;
using (MySqlConnection conn=new MySqlConnection(connString))
...{
try
...{
MySqlCommand cmd = new MySqlCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText="insert into tab (content) values(?content)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("content", "test3");
cmd.ExecuteNonQuery();
}
catch (Exception)
...{
throw;
}
}
}
}
}
using System.Collections.Generic;
using System.Text;
using MySql.Data.MySqlClient;
using System.Configuration;
using System.Data;
namespace testMSQL
... {
class Program
...{
static void Main(string[] args)
...{
string connString = ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString;
using (MySqlConnection conn=new MySqlConnection(connString))
...{
try
...{
MySqlCommand cmd = new MySqlCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText="insert into tab (content) values(?content)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("content", "test3");
cmd.ExecuteNonQuery();
}
catch (Exception)
...{
throw;
}
}
}
}
}