查询记录前后+ 6行
本文关键字:6行 记录 查询 | 更新日期: 2023-09-27 18:02:17
我希望能够查询一个子集,其中包括正确的记录,然后6之前和之后共13行,并在DGV中显示它们。提取正确行的查询如下:
private void textBox6_Leave(object sender, EventArgs e)
{
DataClasses3DataContext db = new DataClasses3DataContext();
var matchedAdd = (from c in db.GetTable<prop>()
where c.HOUSE_NO.Contains(textBox1.Text) && c.Direction.Contains(textBox2.Text) && c.street.Contains(textBox3.Text) && c.SUFF.Contains(textBox4.Text)
select c).SingleOrDefault();
}
如果包裹编号在增加,则使用您的查询来检索包裹编号。
:
var before = (from c in db.GetTable<prop>()
where c.PARCEL < retrievedParcelNumber orderby c.PARCEL descending
select c).Take(6);
var after = (from c in db.GetTable<prop>()
where c.PARCEL > retrievedParcelNumber orderby c.PARCEL
select c).Take(6);