-
-
Import Excel Spreadsheet into DataGrid
Originally found at http://blueraiden.exofire.net/blog/import-excel-spreadsheet-data-to-datagridview-using-vb-net For the code to work you need to first add a DataGridView and a Button in design view and have a valid file path for the Excel file.
-
-
-
Update Record Upper / Lower Case
Upper Case Lower Case
-
-
Code | CSharp | JavaScript | PHP | PowerShell | VB | VB.NET
New Line
Often we forget what code we need to use to create a new line (line break), hopefully this will help. n = CR (Carriage Return) Used as a new line character in Unix r = LF (Line Feed) Used as a new line character in Mac OS nr = CR + LF Used as a…
-
Filter Datagrid
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:
-
Check For Valid Date
Recently I had to validate dates in a form specifically the date of visit and date of birth This function will now check both for future date and do more checks for the date of visit, debug/helper information left in to better understand the function. Function Code: Function Use:
-