Else语句在foreach循环中不能正常工作?这是我的代码。如果我的代码出了什么问题,解释一下会更好。
protected void getdata_Click(object sender, EventArgs e)
{
using (var db2 = new cftzClassDataContext())
{
var username = (from p in db2.cftzAccounts
where p.username.Equals(getdata2.Text)
select p);
foreach (var p in username)
{
if (getdata2.Text == p.username)
{
displayMSG.Text = "Is this correct ";
displayData.Text = p.username;
displayQuestionMark.Text = "?";
}
else
{
displayMSG.Text = "No User Found.";
}
}
}
}发布于 2012-07-13 16:04:35
if语句是完全多余的,因为您已经过滤了列表,只包括用户名等于getData2.Text的帐户。因此,您的if测试将始终计算为true。
您可以将其重写为以下代码,效果相同
using (var db2 = new cftzClassDataContext())
{
var username = (from p in db2.cftzAccounts.Take(100)
where p.username.Equals(getdata2.Text)
select p);
foreach (var p in username)
{
displayMSG.Text = "Is this correct ";
displayData.Text = p.username;
displayQuestionMark.Text = "?";
}
}但是,正如Hans指出的那样,您的循环也是不必要的,因为所有用户名都是相同的。你的代码可以像下面这样简单:
using (var db2 = new cftzClassDataContext())
{
var user = db2.cftzAccounts.
FirstOrDefault(account => account.username.Equals(getdata2.Text));
if (user != null)
{
displayMSG.Text = "Is this correct ";
displayData.Text = user.username;
displayQuestionMark.Text = "?";
}
else
{
displayMSG.Text = "No User Found.";
}
}发布于 2012-07-13 16:13:22
我不确定您试图实现什么,但看起来您正在尝试查找用户是否在数据库中,如果在,则配置displayMSG对象。你不能像这样做点什么吗
var user=db2.Single(u=> u.username==getdata2.Text);如果没有找到用户,Singe会抛出异常。如果您不喜欢这样做,可以使用SingleOrDefault()方法
protected void getdata_Click(object sender, EventArgs e)
{
using (var db2 = new cftzClassDataContext())
{
try
{
var user=db2.Single(u=> u.username==getdata2.Text);
displayMSG.Text = "Is this correct ";
displayData.Text = user.username;
displayQuestionMark.Text = "?";
}
catch
{
displayMSG.Text = "No User Found.";
}
}
}https://stackoverflow.com/questions/11466447
复制相似问题