{"id":161,"date":"2010-05-12T19:12:03","date_gmt":"2010-05-12T18:12:03","guid":{"rendered":"http:\/\/blog.rabihtawil.com\/?p=161"},"modified":"2010-05-12T19:12:03","modified_gmt":"2010-05-12T18:12:03","slug":"searching-through-all-columns-in-datagridview","status":"publish","type":"post","link":"http:\/\/www.raytawil.com\/?p=161","title":{"rendered":"Searching through all columns in datagridview"},"content":{"rendered":"<p>Assuming you are searching for the name John, the following procedure will search all existing columns regardless<\/p>\n<div id=\"wpshdo_1\" class=\"wp-synhighlighter-outer\"><div id=\"wpshdt_1\" class=\"wp-synhighlighter-expanded\"><table border=\"0\" width=\"100%\"><tr><td align=\"left\" width=\"80%\"><a name=\"#codesyntax_1\"><\/a><a id=\"wpshat_1\" class=\"wp-synhighlighter-title\" href=\"#codesyntax_1\"  onClick=\"javascript:wpsh_toggleBlock(1)\" title=\"Click to show\/hide code block\">Source code<\/a><\/td><td align=\"right\"><a href=\"#codesyntax_1\" onClick=\"javascript:wpsh_code(1)\" title=\"Show code only\"><img border=\"0\" style=\"border: 0 none\" src=\"http:\/\/www.raytawil.com\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/code.png\" \/><\/a>&nbsp;<a href=\"#codesyntax_1\" onClick=\"javascript:wpsh_print(1)\" title=\"Print code\"><img border=\"0\" style=\"border: 0 none\" src=\"http:\/\/www.raytawil.com\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/printer.png\" \/><\/a>&nbsp;<a href=\"http:\/\/www.raytawil.com\/wp-content\/plugins\/wp-synhighlight\/About.html\" target=\"_blank\" title=\"Show plugin information\"><img border=\"0\" style=\"border: 0 none\" src=\"http:\/\/www.raytawil.com\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/info.gif\" \/><\/a>&nbsp;<\/td><\/tr><\/table><\/div><div id=\"wpshdi_1\" class=\"wp-synhighlighter-inner\" style=\"display: block;\"><pre class=\"vbnet\" style=\"font-family:monospace;\"><span class=\"kw6\">Dim<\/span> x <span class=\"kw2\">As<\/span> <span class=\"kw4\">Integer<\/span> <span class=\"sy0\">=<\/span> 0\n <span class=\"kw6\">While<\/span> x &lt; DataGridView1.<span class=\"me1\">Rows<\/span>.<span class=\"me1\">Count<\/span>\n <span class=\"kw6\">Dim<\/span> y <span class=\"kw2\">As<\/span> <span class=\"kw4\">Integer<\/span> <span class=\"sy0\">=<\/span> 0\n <span class=\"kw6\">While<\/span> y &lt; DataGridView1.<span class=\"me1\">Rows<\/span><span class=\"br0\">&#40;<\/span>x<span class=\"br0\">&#41;<\/span>.<span class=\"me1\">Cells<\/span>.<span class=\"me1\">Count<\/span>\n <span class=\"kw6\">Dim<\/span> c <span class=\"kw2\">As<\/span> DataGridViewCell <span class=\"sy0\">=<\/span> DataGridView1.<span class=\"me1\">Rows<\/span><span class=\"br0\">&#40;<\/span>x<span class=\"br0\">&#41;<\/span>.<span class=\"me1\">Cells<\/span><span class=\"br0\">&#40;<\/span>y<span class=\"br0\">&#41;<\/span>\n <span class=\"kw6\">If<\/span> <span class=\"kw5\">Not<\/span> c.<span class=\"me1\">Value<\/span> <span class=\"kw2\">Is<\/span> DBNull.<span class=\"me1\">Value<\/span> Or <span class=\"kw2\">Nothing<\/span> <span class=\"kw2\">Then<\/span>\n <span class=\"kw6\">If<\/span> <span class=\"kw7\">CType<\/span><span class=\"br0\">&#40;<\/span>c.<span class=\"me1\">Value<\/span>, <span class=\"kw2\">String<\/span><span class=\"br0\">&#41;<\/span> <span class=\"sy0\">=<\/span> <span class=\"st0\">&quot;John&quot;<\/span> <span class=\"kw2\">Then<\/span>\n MessageBox.<span class=\"me1\">Show<\/span><span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;Found!&quot;<\/span><span class=\"br0\">&#41;<\/span>\n <span class=\"kw6\">End<\/span> <span class=\"kw6\">If<\/span>\n <span class=\"kw6\">End<\/span> <span class=\"kw6\">If<\/span>\n System.<span class=\"me1\">Math<\/span>.<span class=\"me1\">Min<\/span><span class=\"br0\">&#40;<\/span>System.<span class=\"me1\">Threading<\/span>.<span class=\"me1\">Interlocked<\/span>.<span class=\"me1\">Increment<\/span><span class=\"br0\">&#40;<\/span>y<span class=\"br0\">&#41;<\/span>, y <span class=\"sy0\">-<\/span> 1<span class=\"br0\">&#41;<\/span>\n <span class=\"kw6\">End<\/span> <span class=\"kw6\">While<\/span>\n System.<span class=\"me1\">Math<\/span>.<span class=\"me1\">Min<\/span><span class=\"br0\">&#40;<\/span>System.<span class=\"me1\">Threading<\/span>.<span class=\"me1\">Interlocked<\/span>.<span class=\"me1\">Increment<\/span><span class=\"br0\">&#40;<\/span>x<span class=\"br0\">&#41;<\/span>, x <span class=\"sy0\">-<\/span> 1<span class=\"br0\">&#41;<\/span>\n <span class=\"kw6\">End<\/span> <span class=\"kw6\">While<\/span>\n MessageBox.<span class=\"me1\">Show<\/span><span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;Search complete!&quot;<\/span><span class=\"br0\">&#41;<\/span>\n <span class=\"kw6\">End<\/span> <span class=\"kw6\">Sub<\/span><\/pre><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Assuming you are searching for the name John, the following procedure will search all existing columns regardless<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[110],"tags":[33,34,37,78,87,131],"_links":{"self":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/161"}],"collection":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=161"}],"version-history":[{"count":0,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/161\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=161"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}