下面的程序是添加注册信息,插入到数据库中的数据出现乱码,
请各位帮改一下,数据类型是nvarchar型的,我在web.config文件中将编码改成utf-8也不起作用,数据库是sql server 2000中文版
------------------------------------------------------
<%@ page Language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<html>
<body>
<%
string realname=Request.Form["realname"];//在.net中我认为这一行要作一下编码处理吧,
String certificate=Request.Form["certificate"];
String username=Request.Form["username"];
String password=Request.Form["username"];
string sex=Request.Form["sex"];
string age=Request.Form["age"];
string xueli=Request.Form["xueli"];
string zhichen=Request.Form["zhichen"];
string position=Request.Form["position"];
string district=Request.Form["district"];
string danwei=Request.Form["danwei"];
string phone=Request.Form["phone"];
string email=Request.Form["email"];
SqlConnection mySqlConnection =new SqlConnection(
"server=localhost;database=SmartExam;uid=sa;pwd=gzedu");
mySqlConnection.Open();
string reg_user = "insert into User_Account(Real_Name,Account,Password,User_Sex,Age,Xueli,Zhichen,Zhiwu,Address,Company,Telephone,Email) values('"+realname+"','"+username+"','888888','"+sex+"','"+age+"','"+xueli+"','"+zhichen+"','"+position+"','"+district+"','"+danwei+"','"+phone+"','"+email+"')";
SqlCommand MyComm = new SqlCommand(reg_user,mySqlConnection);
MyComm.ExecuteNonQuery();
%>
</body>
</html>
请各位帮改一下,数据类型是nvarchar型的,我在web.config文件中将编码改成utf-8也不起作用,数据库是sql server 2000中文版
------------------------------------------------------
<%@ page Language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<html>
<body>
<%
string realname=Request.Form["realname"];//在.net中我认为这一行要作一下编码处理吧,
String certificate=Request.Form["certificate"];
String username=Request.Form["username"];
String password=Request.Form["username"];
string sex=Request.Form["sex"];
string age=Request.Form["age"];
string xueli=Request.Form["xueli"];
string zhichen=Request.Form["zhichen"];
string position=Request.Form["position"];
string district=Request.Form["district"];
string danwei=Request.Form["danwei"];
string phone=Request.Form["phone"];
string email=Request.Form["email"];
SqlConnection mySqlConnection =new SqlConnection(
"server=localhost;database=SmartExam;uid=sa;pwd=gzedu");
mySqlConnection.Open();
string reg_user = "insert into User_Account(Real_Name,Account,Password,User_Sex,Age,Xueli,Zhichen,Zhiwu,Address,Company,Telephone,Email) values('"+realname+"','"+username+"','888888','"+sex+"','"+age+"','"+xueli+"','"+zhichen+"','"+position+"','"+district+"','"+danwei+"','"+phone+"','"+email+"')";
SqlCommand MyComm = new SqlCommand(reg_user,mySqlConnection);
MyComm.ExecuteNonQuery();
%>
</body>
</html>
...
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
...
</head>
其中charset可以定义具体编码