Filter Datagrid

Posted on By David Kittell

If you already have a data grid and want to search it you can create a textbox and do a textbox.textchanged control to run something like below:

YourGridViewBindingSource.Filter = String.Format("YourDBColumn Like ;'*" & FilterValue) & "*'"
Originally Posted on March 1, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code VB.NET

Related Posts

LDAP Dates Converted

Posted on

Dates that look like 127524839567199000 (pwdLastSet, accountExpires, lastLogonTimestamp, etc.) IF( B16>0 ,B16/864000000000 – 109205 ,"" ) Example: 130186556607343750 converts to 40921.80861 40921.80861 in Excel with cell formatting of Date/Time will show as January 13th, 2012 7:24 PM Dates that look like 20050210223453.0Z (whenChanged) DATEVALUE( CONCATENATE( (LEFT(TRIM(B9),4)) ,"-" ,(RIGHT(LEFT(TRIM(B9),6),2)) ,"-" ,RIGHT(LEFT(TRIM(B9),8),2)…

Read More

PHP – Directory File Size – Recursive

Posted on

<?php $path = ‘/var/www/html’; function filesize_recursive($path) { $ret = 0; try { if(!file_exists($path)) return 0; if(is_file($path)) return filesize($path); foreach(glob($path."/*") as $fn) $ret += filesize_recursive($fn); } catch(Exception $e) { echo ‘Message: ‘ .$e->getMessage(); } return $ret; } function display_size($size) { $sizes = array(‘B’, ‘kB’, ‘MB’, ‘GB’, ‘TB’, ‘PB’, ‘EB’, ‘ZB’, ‘YB’);…

Read More

PowerShell – Backup Windows Drivers

Posted on

$DriverBackupPath = "$($env:USERNAME)\Downloads\DriverBackup\$($(Get-WmiObject -Class:Win32_ComputerSystem).Manufacturer)\$($(Get-WmiObject -Class:Win32_ComputerSystem).Model)" mkdir -p $DriverBackupPath -Force Export-WindowsDriver -Verbose -Destination $DriverBackupPath -Online Originally Posted on March 18, 2020Last Updated on August 17, 2024 All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system…

Read More