我对c#不熟悉,刚才写了下面的代码发现数据添加不了(前提:数据库是连的上的),大家帮我看看出了什么问题
<%@ Page Language="C#" ResponseEncoding="gb2312"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
//string str = Request.QueryString["member"];
string member;
string password;
string question;
string answer;
string E_mail;
string QQ;
string sex;
string allstrSQL;
protected void Page_load(Object Src, EventArgs E)
{
member = Request["member"];
password = Request["password"];
question = Request["question"];
answer = Request["answer"];
E_mail = Request["E_mail"];
QQ = Request["QQ"];
sex = Request["sex"];
string strConnection = System.Configuration.ConfigurationSettings.AppSettings["connectionString"];
SqlConnection objConnection=new SqlConnection(strConnection);
objConnection.Open();
allstrSQL = "insert into member (member,password,question,answer,E_mail,QQ,sex) values ("+member+","+password+","+question+","+answer+","+E_mail+","+QQ+","+sex+")";
SqlCommand Com = new SqlCommand(allstrSQL, objConnection);
}
</script>
<%Response.Write(allstrSQL);%>
<%@ Page Language="C#" ResponseEncoding="gb2312"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
//string str = Request.QueryString["member"];
string member;
string password;
string question;
string answer;
string E_mail;
string QQ;
string sex;
string allstrSQL;
protected void Page_load(Object Src, EventArgs E)
{
member = Request["member"];
password = Request["password"];
question = Request["question"];
answer = Request["answer"];
E_mail = Request["E_mail"];
QQ = Request["QQ"];
sex = Request["sex"];
string strConnection = System.Configuration.ConfigurationSettings.AppSettings["connectionString"];
SqlConnection objConnection=new SqlConnection(strConnection);
objConnection.Open();
allstrSQL = "insert into member (member,password,question,answer,E_mail,QQ,sex) values ("+member+","+password+","+question+","+answer+","+E_mail+","+QQ+","+sex+")";
SqlCommand Com = new SqlCommand(allstrSQL, objConnection);
}
</script>
<%Response.Write(allstrSQL);%>
try {
conn.Open();
SqlCommand cmd=new SqlCommand ("insert into member (member,password,question,answer,E_mail,QQ,sex) values ('"+member+"','"+password+"','"+question+"',N'"+answer+"','"+E_mail+"','"+QQ+"','"+sex+"')",conn);
// SqlCommand cmd=new SqlCommand ("insert into member (member,password,question,answer,E_mail,QQ,sex) values ("+member+","+password+","+question+","+answer+","+E_mail+","+QQ+","+sex+")",conn);
cmd.ExecuteNonQuery();
}
catch (SqlException ex) {
//处理异常
}
finally {
conn.Close();但中文录入后出现乱码
具体代码如下:
<%@ Page Language="C#" ResponseEncoding="gb2312"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
string member;
string password;
string question;
string answer;
string E_mail;
string QQ;
string sex;
string allstrSQL;
protected void Page_load(Object Src, EventArgs E)
{
member = Request["member"];
password = Request["password"];
question = Request["question"];
answer = Request["answer"];
E_mail = Request["E_mail"];
QQ = Request["QQ"];
sex = Request["sex"];
string strConnection = System.Configuration.ConfigurationSettings.AppSettings["connectionString"];
SqlConnection conn=new SqlConnection(strConnection);
try {
conn.Open();
SqlCommand cmd=new SqlCommand ("insert into member (member,password,question,answer,E_mail,QQ,sex) values ('"+member+"','"+password+"','"+question+"',N'"+answer+"','"+E_mail+"','"+QQ+"','"+sex+"')",conn);
cmd.ExecuteNonQuery();
}
catch (SqlException ex) {
//处理异常
}
finally {
conn.Close();
}
}
</script>