ASP.NET insert into 语句的语法错误

public partial class 网站会员注册与登录_login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected OleDbConnection getConnection()
{
string connstring="Provider=Microsoft.Jet.Oledb.4.0;Data Source="+System.Web.HttpContext.Current.Server.MapPath("~/App_Data/lian1.mdb");
OleDbConnection con = new OleDbConnection(connstring);//实例化数据库连接类
return con;
}

protected void Button1_Click(object sender, EventArgs e)
{
if (isname() <= 0)
{
if (add())
{
OleDbConnection con = getConnection();
con.Open();
string s = "insert into [user_login]([name],[logindate]) values('" + TN.Text + "','" + DateTime.Now.ToString() + "')";
OleDbCommand com = new OleDbCommand(s,con);
com.ExecuteNonQuery();
Response.Write("<script>alert('注册成功！单击确定返回登陆页面');location='landing.aspx';</script>");
con.Close();
}
else
Response.Write("<script>alert('注册失败')</script>");
}
else
Response.Write("<script>alert('用户已经存在')</script>");

}
public int isname()
{
int i;
string nm = TN.Text.Trim();//tr空格im去掉前后
if (nm != "")
{
OleDbConnection con =getConnection();
con.Open();
OleDbCommand com = new OleDbCommand("select count(*) from user_table where name='" + nm + "'", con);
return i = Convert.ToInt32(com.ExecuteScalar());
con.Close();
}
else
{
return i = 0;
}

}
public bool add()
{
string Uname = TN.Text.Trim().ToString();
string Upass = FormsAuthentication.HashPasswordForStoringInConfigFile(TP.Text.Trim(), "MD5");//对密码进行MD5加密
string Usexy;
if( RW.Checked)
Usexy ="女";
else
Usexy = "男";
string Urealname = TRN.Text.Trim().ToString();
int Utel = Convert.ToInt32(TT.Text.Trim());
string Uemail = TE.Text.Trim().ToString();
string Uaddress = TA.Text.Trim().ToString();
string sql="insert into [user_table] ([name],[pass],[sex],[realname],[phone].[email],[address]) valuse ('" + Uname + "','" + Upass + "','" + Usexy + "','" + Urealname + "','" + Utel +" ','" + Uemail + "','" + Uaddress + "')";
OleDbConnection con = getConnection();
con.Open();
OleDbCommand com = new OleDbCommand(sql,con);
int orE =Convert.ToInt32(com.ExecuteNonQuery());//返回受影响的行数，也就是成功加入的个数，即收到加入的影响了
con.Close();
if(orE>0)
return true;
else
return false;
}

}
错在哪了呢，链接的是ACCESS数据库

举报该文章