This area of the site is dedicated to code snippets for quick and easy reference
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.
Upper Case Lower Case
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…
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:
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:
Two options with this fix, official script from Ektron or to fix the individual tables that are currently having the issue. Individual Table(s) Official fix from Ektron, specific to 8.0.2
When working with Visual Studio and Oracle you will need to download Oracle’s Visual Studio Tools. Code Samples: http://www.oracle.com/technetwork/articles/dotnet/cook-dotnet-101788.html If I thought I could legally host the file I would. Official Page: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html If the link fails to work do a search on http://www.oracle.com/ for Visual Studio ODAC 11.2 Release 5 and Oracle Developer Tools…