1.连接字符串
<configuration>
<appSettings>
<add key="ConnectionString" value="server=127.0.0.1;port=3306;user=dbmanager;password=123456; database=AdVideodb;SslMode=None;charset=utf8" />
</appSettings>
</configuration>
charset=utf8 设置插入中文查询中文输出
2.c#连接代码
插入 更新删除 语句
myconn.Open();
MySqlCommand mySqlCommand = new MySqlCommand(sql, myconn);
int result = mySqlCommand.ExecuteNonQuery();
if (result == 1)
{
///
}
ExcuteNonQuery()返回受影响的行数
MySqlCommand mySqlCommand = new MySqlCommand(sql, myconn);
MySqlDataReader mysqlreader = mySqlCommand.ExecuteReader();
if (mysqlreader.Read())
{
users returnuser = new users();
returnuser.userid = mysqlreader.GetString("userid");
returnuser.usertype = mysqlreader.GetInt32("usertype");
returnuser.nickname = mysqlreader.GetString("nickname");
returnuser.image = mysqlreader.GetString("image");
returnuser.likenumcount = mysqlreader.GetInt32("likenumcount");
backmessage.status = 1;
backmessage.result = returnuser;
}
ExexuteReader()可以将查询结果读取到MysqlDataReader 对象中,并使用.read()一次读取一行,如果读取到返回true,可以使用while循环读取所有的行,但如果只有一行的话使用此函数比较方便
MySqlCommand mySqlCommand = new MySqlCommand(sql, myconn);
MySqlDataAdapter myda = new MySqlDataAdapter(mySqlCommand);
DataSet ds = new DataSet();
myda.Fill(ds);
DataTable dt = ds.Tables[0];
mysqlDataAdapter 函数执行并获取结果表格,然后填充到DataSet中
如有不对的地方欢迎指出