How to Split Rows in a DataTable

You are given the assignment to create a CSV file report, and you say “No Problem, I just get the necessary data from SQL Server and create the CSV file”, however the columns have a max character length and Column13 has more characters than those allowed. How to handle this if you need to report all of the information in Column13?

The answer is to split that row into multiple rows. All columns will be duplicated (into the split rows) except for Column13 which will have the split information. Below I’ll show you how to accomplish this.

Continue reading →

Flatten PDF Form Fields with iTextSharp – Two Methods – ASP.NET

I will show two methods to flatten editable form fields in a PDF file. Method 1 is true form flattening and method 2 is just making the editable fields read only. Personally I was using method 1 for some time, however in some instances (more specifically when merging images into a PDF file and messing with the editable fields), this specific method would throw an error upon opening the PDF file in Adobe Reader stating that Acrobat may not display the page correctly, however I never noticed anything wrong with the PDF file, everything was being displayed correctly, but this “error” was kinda annoying, so I opted to change the code a bit to make all the fields Read Only instead of flattening the form.

Below is the code to perform both, flatten the form and make all the fields Read Only.

Continue reading →

Side by Side Comparison Between Logos Standard and Baptist Packages – Starter and Bronze

Recently I was looking into getting the Logos Bible Software so I made a side by side comparison between Starter and Bronze base packages, Baptist and Standard families. I’m sharing my findings and hopefully they will be beneficial and a deciding factor on which package to get as it was to me.

Continue reading →

ASP.NET Controls / AJAX Extensions Not Working in iOS 8 or Safari 8 – Telerik Controls

Some time back I noticed my ASP.NET Telerik controls were not working in iOS 8 nor Safari 8, so I did a little research and I discovered that I needed to add a new browser file to my application be cause of a major version-change to AppleWebKit/600. Below is solution I found in StackOverflow.

Continue reading →

Quick Guide to Git and GitHub – Command Line (CLI)

In this guide I will cover some basic commands to configure Git and upload your project to GitHub using command line. macOS should already come with Git pre-installed, but just in case, follow this link to install it, Installing Git on Mac. If you are on Windows, you can get Git for Windows, or enable Windows Subsystem for Linux (WSL).

Continue reading →

Cannot Install ‘pg’ gem in Mac OSX – Error installing pg: ERROR: Failed to build gem native extension — Ruby on Rails

If you are planning on using PostgreSQL with Ruby on Rails, you will need to install pg, which is the Ruby interface to the PostgreSQL RDBMS. The command to install it is as follows:

gem install pg
Continue reading →

How to Access ASP.NET Controls Inside An Outer And An Inner ASP Repeaters (Controls Inside Two ASP Repeaters)

Working with ASP.NET repeaters can be a little bit tricky if you do not fully understand them. In plain words, you have to find the outer repeater, then from here find the inner repeater, then from this inner repeater find the control(s). If I haven’t confused you enough, look at the examples, it will be clearer 🙂

Continue reading →