我用C#调用MYSQL的存储过程,怎么写进数据库的都是乱码啊,请高手帮忙解释下,该怎么办呢?
存储过程:
CREATE DEFINER=`root`@`localhost` PROCEDURE `save_card`(in title varchar(100),in info text,in bookrecord varchar(100),in contentid int)
BEGIN
select * from bookcard;
insert into bookcard (title,info,bookrecord,contentid) values (title,info,bookrecord,contentid);
ENDC#调用:
MySqlCommand cmd1 = new MySqlCommand();
string myconnectstr1;
myconnectstr1 = "Database= pingtai;Data Source=localhost;User Id=root";
MySql.Data.MySqlClient.MySqlConnection conn1 = new MySqlConnection(myconnectstr1);
conn1.Open();
string str1;
string title = "标题!";
string content = "内容!";
str1 = "call save_card('"+title+"','"+content+"','nianjian-shandong-shandong-2006',3)";
cmd1 = new MySqlCommand(str1, conn1);
cmd1.ExecuteNonQuery();
存储过程:
CREATE DEFINER=`root`@`localhost` PROCEDURE `save_card`(in title varchar(100),in info text,in bookrecord varchar(100),in contentid int)
BEGIN
select * from bookcard;
insert into bookcard (title,info,bookrecord,contentid) values (title,info,bookrecord,contentid);
ENDC#调用:
MySqlCommand cmd1 = new MySqlCommand();
string myconnectstr1;
myconnectstr1 = "Database= pingtai;Data Source=localhost;User Id=root";
MySql.Data.MySqlClient.MySqlConnection conn1 = new MySqlConnection(myconnectstr1);
conn1.Open();
string str1;
string title = "标题!";
string content = "内容!";
str1 = "call save_card('"+title+"','"+content+"','nianjian-shandong-shandong-2006',3)";
cmd1 = new MySqlCommand(str1, conn1);
cmd1.ExecuteNonQuery();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货