＋设为首页 ＋添加到收藏夹
做了一个密码效验的控件，看是否有重名的，可做好以后老出错，大家帮我看看。好像是转换不对。
代码如下：
private void Button3_Click(object sender, System.EventArgs e)
{
string myconn1="Provider=Microsoft.Jet.OleDb.4.0;";
myconn1+="Data Source=c:\\inetpub\\wwwroot\\cong\\net.mdb";
OleDbConnection objconn1 = new OleDbConnection(myconn1);
objconn1.Open();
string mmid=mid.Text;
string mysql1="select count(*) from pemployee_name where employee_name"+ mmid +"";
OleDbCommand mycomm1=new OleDbCommand(mysql1,objconn1);
int mycount=Convert.ToInt32(mycomm1.ExecuteScalar());
if (mycount > 0)
{
Response.Write("<Script Language=JavaScript>alert(您所用的用户ID已有人使用，请重新输入！)</Script>");
}
else
{
Response.Write("<Script Language=JavaScript>alert(恭喜您，您可以使用该ID！)</Script>");
}
objconn1.Close();
}
string mysql1="select count(*) from pemployee_name where employee_name "+ mmid +"";
少了一個 = employee_name = "+ mmid +"
string user_name=Request.Form["username_tbx"].ToString();
string select_id="select * from net_user";
OleDbCommand id_com=new OleDbCommand(select_id,myconn);
OleDbDataReader id_reader=id_com.ExecuteReader();
while(id_reader.Read())
{
if(user_name==id_reader["user_name"].ToString())
{
tag_label.Text="您输入的id已经存在，请继续选择";
return;
}
用上面的判断是否已经存在用户了！
