vb.net - DataGridView cell search using a LINQ query -

-

i'm still relatively new linq, , have done more stumbling around anything, have liked have seen far. in mind, have vb.net search routine, part of provided, below, checks text cells in datagridview given string (inclusive), using basic set of nested loops perform search:

' search first occurrence of given string each row datagridviewrow in dgvmembers.rows     ' skip new row     if row.isnewrow exit      ' loop through cells in current row     each cell datagridviewcell in row.cells         ' skip non-text cells         if cell.gettype isnot gettype(datagridviewtextboxcell) continue          ' search our matching text         if cell.value.tostring.toupper.contains(searchtext)             ' select cell if have match             dgvmembers.currentcell = cell             writemessage("string '{0}' found.", searchtext)             exit sub         end if     next next  ' if point, didn't find writemessage("string '{0}' not found.", searchtext)

pretty straightforward. now, question is: there way replicate behavior using linq? query select (or return) first datagridviewcell text contains search string. i've done tinkering sub-queries , like, i'm still having trouble wrapping brain around concepts (too many years of writing t-sql, guess).

obviously nested loop works fine, more of curiosity, really. in advance!

i able use code success:

dim qry = therow datagridviewrow in dgvmembers.rows, _                thecell datagridviewcell in therow.cells _           thecell.value.tostring.toupper = searchtext _           select thecell   dim matchcell datagridviewcell = qry.first  dgvmembers.currentcell = matchcell

... etc...


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more