This area of the site is dedicated to code snippets for quick and easy reference
Recently had a need to be able to switch on/off proxy at will and got tired of going to Internet Explorer options to set/change it. Hopefully someone else will get benefit from this nice tool. Open Visual Studio File -> New Project -> Visual C# – Windows -> Windows Forms Application Add two textbox controls…
Use NuGet, search and install “Json.net” from Newtonsoft Visit json2csharp.com with the sample Json formatted text. json2csharp will create the public class for your json file/text Paste your Json text into the text box and click on the “Generate” button Copy the generated class into your code Create a dataGridView (Windows form) or GridView (Web…
Have two databases with the same table schema and need to keep both up to date? First, let us look at the differences between the two databases. The query below will show the differences between the development database table tbl_zip_code and the production database table tbl_zip_code. Ideally the differences should be minimal but the query…
Great for populating just about anything you can databind.
References: https://csvkit.readthedocs.org http://www.anthonydebarros.com/2011/09/11/csvkit-data-files/ https://jonlabelle.com/snippets/view/shell/csvkit-commands http://jeroenjanssens.com/2013/09/19/seven-command-line-tools-for-data-science.html http://csvkit.readthedocs.org/en/latest/tutorial/3_power_tools.html https://csvkit.readthedocs.org/en/0.9.1/scripts/csvclean.html
I personally use Ubuntu, if you don’t the commands may be slightly different. To install:
This is a project I’ve been meaning to rewrite, as I get it going I’ll add screen shots and examples but for now I’ll work on the shell scripts After installing base Ubuntu, set the root/sudo password so you can do installs cleaner. After the below you will asked for the password of the account…
Reference: http://stackoverflow.com/questions/8685034/error-importing-5-gig-file-into-table
If you work in medical databases you are likely familiar with the site CMS NPI Search I have had a few projects that need the ability to validate NPI numbers so based on data at CMS.gov I have worked out a solution to get the data into a database that I can manage. CSVKit is…