using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace liuyan
{
/// <summary>
/// zuce 的摘要说明。
/// </summary>
public class zuce : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.TextBox TextBox6;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList1;
protected System.Web.UI.WebControls.Label Label1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
string strConn="server=Localhost;uid=sa;pwd=sa;database=liuyan";
string strCmd="select count(*) from user where UserName like'"+TextBox1.Text+"'";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
SqlCommand myCommand=new SqlCommand(strCmd,myConnection);
myCommand.Connection.Open();
int flat=(int)myCommand.ExecuteScalar();
myCommand.Connection.Close();
if(flat==0)
{
string insCmd="insert user(UserName,Pwd,Gender,QQ,EMail,WebSite,Regtime)";
insCmd+="value('"+TextBox1.Text+"','"+TextBox2.Text+"','"+RadioButtonList1.SelectedItem.value+"','"+TextBox4.Text+"','"+TextBox5.Text+"','"+TextBox6.Text+"',getdate())";
SqlCommand myIns=new SqlCommand(insCmd,myConnection);
myIns.Connection.Open();
myIns.ExecuteNonQuery();
myIns.Connection.Close();
Session["username"]=TextBox1.Text;
Session["gender"]=RadioButtonList1.SelectedItem.value;
Response.Redirect("default.aspx"
;
}
else
{
Label1.Text="对不起！用户名已占用，请选择其它用户名！";
TextBox1.Text="";
TextBox2.Text="";
TextBox3.Text="";
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
Response.Redirect("zuce.aspx"
;
}
}
}
能帮我看看是什么问题吗？
错误信息：
异常详细信息: System.Data.SqlClient.SqlException: 在关键字 'user' 附近有语法错误。
源错误:
行 69： SqlCommand myCommand=new SqlCommand(strCmd,myConnection);
行 70： myCommand.Connection.Open();
行 71： int flat=(int)myCommand.ExecuteScalar();
行 72： myCommand.Connection.Close();
行 73： if(flat==0)
源文件: e:\asp.net练习\liuyan\zuce.aspx.cs 行: 71
