Question

比较我不在这里工作。

我要问的是:

var result = from c in customers 
             where c.CustomerID.CompareTo(txtSerchId.Text) >= 0 
             select` c;

成为例外

//////////

System.ArgumentException was caught
Message=Value does not fall within the expected range.

我的法典就是这样。

var result = 
    from c in customers 
    where c.CustomerID.CompareTo(txtSerchId.Text) >= 0 
    select c;

if (result != null)
{
    IEnumerator<Customer> resultEnum = result.GetEnumerator();
    while (resultEnum.MoveNext())
    {
        Customer c = (Customer)resultEnum.Current;
        addToDataSet(Guid.NewGuid().ToString(), c);
    }
    ShowResult();
}
else
{
    MessageBox.Show("No Customer found within criteria");
}

不适用。

IEnumerator<Customer> resultEnum = result.GetEnumerator();

Answer 1

审判:

var query = from c in customers where c.CustomerID.Equals(txtSerchId.Text) select c;

Answer 2

根据你的评述,“一是比较用户的输入价值,以收集本身拥有的物品,搜索其身份少于或可说大于用户输入的客户”。

~~try this for "greater than":~~

int customerId = int.Parse(txtSerchId.Text);
if (customerId > 0)
{
   var result = from c in customers where c.CustomerID > customerId select c;
}

最新信息是,在评论中增加了更多不明确之处:

Try this:

customers.ToList().Where(c => c.CustomerID.CompareTo(txtSerchId.Text) >= 0);

通知说,由于它首先从数据库中提取了所有记录,而且根据你的细微比较,N过滤了这些记录,因此这种效率极低。但坦率地说,我不知道有更好的办法,这样可能值得尝试。

Answer 3

简单:

平等:

var result = from c in customers where c.CustomerID ==Convert.ToInt32(txtSerchId.Text) select c;
For Greater : where c.CustomerID >= Convert.ToInt32 (txtSerchId.Text)
缩略语: where c.CustomerID <= Convert.ToInt32(txtSerchId.Text)

Answer 4

 var List = (from t in ObjCon.TableName
                            where t.GameDate.Value.CompareTo(GameDate) >= 0
                            join t1 in ObjCon.Teams on t.Home equals t1.TeamId
                            where t1.SportId == 3

* 本年度的工作

友情链接