c#带参数的sql语句写入mysql,

下面是别人解决问题的总结:

问题解决了。总结一下:
1.mysql数据库驱动有两种:mysql-connector-odbc和mysql-connector-net,
前者不支持参数,后者支持,这是我测试的结果;
2.参数变量使用跟SqlServer一样,只需把@变为?,
如,mysql中写为:insert into test values ( id, title, type,now())”;
3.使用mysql-connector-net驱动很简单,到网上下载mysql-connector-net-5.2.3-src,
解压后,把mysql.data.dll添加到项目的bin文件夹即可使用;
4.连接本机mysql数据库方法例子如下—mysql-connector-net:

1)Using Web.config

<connectionstrings>
<add name=”WhateverName” connectionString=”server=localhost;user id=root; password=yourPassword;database=yourDatabase;;charset=utf8;“/>
</connectionstrings>

charset=utf8字符集

2)using statements

using MySql.Data.MySqlClient;

下面附上测试通过的代码:
string connStr = WebConfigurationManager.
ConnectionStrings[“WhateverName”].ConnectionString;
MySqlConnection conn = new MySqlConnection(connStr);
if (conn != null)
conn.Open();
else
return;

string SQL_INSERT_TOPIC = “insert into test values (null, title, type,now())”;
string PARM_TITLE = ” title”;
string PARM_TYPE = ” type”;
MySqlParameter[] parms = new MySqlParameter[]
{
new MySqlParameter(PARM_TITLE,MySqlDbType.VarChar,80),
new MySqlParameter(PARM_TYPE,MySqlDbType.VarChar,1)
};
parms[0].Value = “welcome to beijing”;
parms[1].Value = “C”;

MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = SQL_INSERT_TOPIC;

foreach (MySqlParameter pram in parms)
cmd.Parameters.Add(pram);

cmd.ExecuteNonQuery();
conn.Close();

5.连接本机mysql数据库方法例子如—mysql-connector-odbc

 

转自:

http://dotnetperls.com/Content/OdbcConnection-Example.aspx

发表评论

电子邮件地址不会被公开。 必填项已用*标注