高手们麻烦给我看一下下面的代码,我急啊!!!!谢谢了.这个一个网站的注册页面.关键代码;
yjred 2003-08-30 09:38:42 //下面为连接的代码
string conStr = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source=" + Server.MapPath(".\\dongWang.mdb");
string insertStr = "INSERT INTO userttt(uName, Sex, Photo, Email,HomePage,Passtt)VALUES('"
+userName.Text + " ','"
+ sexSelect.SelectedItem.Text + " ','"
+ photo.ImageUrl + " ','"
+ mail.Text+" ','"
+ homePage.Text +" ','"
+ pass.Text
+" ')";
string selectStr = "SELECT uid FROM userttt WHERE uName = '" + userName.Text + " '";
try
{
OleDbConnection myConn = new OleDbConnection(conStr);
myConn.Open();
//查看是否有重复的用户名..
//问题主要出在这两个注释之间,无论如何,它都不会执行后面的代码
OleDbCommand mySelCom = new OleDbCommand( selectStr,myConn);
OleDbDataReader redr = mySelCom.ExecuteReader();
if(redr.Read())
{
}
else
{
yfError.Text = "此用户名已被抢注";
yfError.Visible = true;
myConn.Close();
return;
}
//问题主要出在这两个注释之间,无论如何,它都不会执行后面的代码
//如无重复,则添加新记录
OleDbCommand myComm = new OleDbCommand(insertStr,myConn);
myComm.ExecuteNonQuery();
myConn.Close();
Response.Redirect("..//default.aspx");
}
catch
{
//Response.Redirect("dataError.aspx");
}
}