我MYSQL服务器配置改的是"GB2312",我用ASP.NET(C#)无法向MySQL里插入汉字,从MYSQL里提出来的汉字也不能正常显示..
请大虾帮帮我..
请大虾帮帮我..
解决方案 »
- 采用Jquery里的ajax来调用webService里的方法,在IIS里执行无效!
- 一个asp.net页面跳转的菜鸟问题~~~~~
- isapi_rewrite的使用问题.httpd.ini文件的配置
- 字符串控制问题
- 为什么自定义控件没能接受参数
- 想写一个页面传参的万能方法
- 在VISTA系统下安装什么版本的VS2005和SQL2005?
- 大家帮我!
- 低级的问题!—— 一旦解决,马上结贴! 在线等!
- 高分求VB.net对Datagrid 的自定义分页的分页控件的程序
- vs.2003 WebForm 在给Repeater 控件绑定DataTable时候,
- IE WEB CONTROL里的TREEVIEW控件问题!!!
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.Odbc;
using System.Data.SqlClient;
using CoreLab.MySql;public partial class _Default : System.Web.UI.Page
{ protected void Page_Load(object sender, EventArgs e)
{
string connstr = "Data Source=192.168.123.100;Password=wtuitxia;User ID=haijiang;database=qianfukeji";
string sqlstr="select * from userinfo";
// OdbcConnection odbcconn = new OdbcConnection(connstr);
// odbcconn.Open();
MySqlConnection mysqlconn = new MySqlConnection(connstr);
MySqlDataAdapter mysqlda = new MySqlDataAdapter(sqlstr, connstr);
DataSet ds = new DataSet();
mysqlda.Fill(ds, "userinfo");
Response.Write(ds.Tables["userinfo"].Rows[0]["name"].ToString());
//sqlstr = "insert into userinfo values ('fdfsd','f','地方');";
//MySqlCommand mysqlcmd = new MySqlCommand(sqlstr, mysqlconn);
//mysqlconn.Open();
//mysqlcmd.ExecuteNonQuery();
}
}我用的局域网中的另一台机子为服务器
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.Odbc;
using System.Data.SqlClient;
using CoreLab.MySql;public partial class _Default : System.Web.UI.Page
{ protected void Page_Load(object sender, EventArgs e)
{
// string connstr = "Data Source=192.168.123.100;Password=wtuitxia;User ID=haijiang;database=qianfukeji";
string connstr = "Driver={MySQL ODBC 3.51 Driver};server=192.168.123.100;database=qianfukeji;user=haijiang;password=wtuitxia;option=3;STMT=set CHARACTER SET gbk";
string sqlstr="select * from userinfo";
OdbcConnection odbcconn = new OdbcConnection(connstr);
// odbcconn.Open(); //MySqlConnection mysqlconn = new MySqlConnection(connstr);
//MySqlDataAdapter mysqlda = new MySqlDataAdapter(sqlstr, connstr); OdbcDataAdapter odbcda = new OdbcDataAdapter(sqlstr, connstr);
DataSet ds = new DataSet();
odbcda.Fill(ds, "userinfo");
//Response.Write(ds.Tables["userinfo"].Rows[0]["name"].ToString()); this.GridView1.DataSource = ds.Tables["userinfo"];
this.GridView1.DataBind();
//sqlstr = "insert into userinfo values ('fdfsd','f','地方');";
//MySqlCommand mysqlcmd = new MySqlCommand(sqlstr, mysqlconn);
//mysqlconn.Open();
//mysqlcmd.ExecuteNonQuery(); //OdbcCommand odbccmd = new OdbcCommand(sqlstr, odbcconn);
//odbcconn.Open();
//odbccmd.ExecuteNonQuery();
}
}谢谢各位了,我终于找到答案了,问题全解决..
加编码试试
我在网上找到了一个ODBC连接字符串,能解决,显示正常,也能插入字符串..
Conn.execute(sqlStr)