Using a Format File to Bulk Import Data in SQL Server
+10 SQL Server OPENROWSET (starting with 2008) supports bulk operations through a built-in BULK provider that enables data from a file to be read and …
Javascript check if object is empty
+10 This is very frequently facing issue, checking a javascript object is empty or not. You can do that using plain Javascript or jQuery. Here …
Generating Excel file in PHP
+10 Here i am sharing how one can generate Excel file using php library “PhpSpreadsheet“. To use library you need to install using composer. Open …
C# Generating txt file with delimiters
+10 Here sharing code how you can generate/download text file using C#. Below method take following parameters as: DataTable DT : Is the actual data …
How to remove Laravel cache
+10 Clearing Laravel application cache using artisan commands is very easy to do. Sometimes it is very difficult to see changes on web pages due …
Karthika Vanabhojanam with Hyderabad Family 2018
After a long gap, we had a good gettogether (Vanabhojanam) for this year at Indira Park lower tank bund in Hyderabad. Sharing few moments:
Deploying Codeigniter project from local to live server
+10 Here I am sharing how you can deploy your Codeigniter project to production server using cPanel. For making it live you need to purchase …
Transfer domain to Godaddy using EPP
+20 Transferring domain to Godaddy using EPP is very handy and anyone can do that without any technical knowledge. Before you follow the below steps …
Cordova : CLI usefull command
+10 Here is the list of Cordova useful commands: 1) Creating project $ cordova create abcApp com.SM.abcApp abcApp 2) Use to update the platform projects …
Reading barcode or QRcode using cordova or Phonegap
+30 Sharing code how you can easily install and configure “phonegap-plugin-barcodescanner” plugin for reading barcode and QRcode in hybrid mobile app. I am using cordova …
Windows service on local computer started and then stopped
+30 I am getting below error while running windows service: The “my service name” service on Local Computer started and then stopped. Some services stop …
Installing Windows Services using command prompt
+20 In this post, I am sharing how you can install or uninstall windows services in your local windows system [Windows 10]. Assuming you already …
Could not load file or assembly System.Web.Http.WebHost
+20 After deploying to IIS server from Visual Studio getting below error, Could not load file or assembly ‘System.Web.Http.WebHost, Version=4.0.0.0, Culture=neutral,PublicKeyToken=31bf3856ad364e35’ or one of its …
How to format cell using EPPlus package in C# MVC
+10 EPPlus is a great package used in C# to export and import excel files. Here I am sharing how we can format data while …
Customize excel file before exporting using jQuery DataTables
+20 I need to format excel data before it gets exported to excel. Not much help from official documentation. So I thought of sharing few …
Reading excel file using EPPlus package
+40 Here I am sharing how you can read excel file using EPPlus package. Many solution given on internet but nothing work for me, so …
How to read data from excel sheet and insert into database table in C#
+30 Reading excel file using EPPlus package and inserting into table is very easy in C# MVC framework. Here I have created a simple method …
Generating and Formatting excelsheet in c# using EPPlus
+60 Getting data from database in DataTable format and then generating Excel sheet and formatting it using EPPlus is very easy in C# MVC. Here …
DataTables header and body not aligned
+20 When scrolling is enabled in DataTables using scrollX or scrollY parameters, it will split the entire table into two or three individual HTML table …
Starting windows services from C# MVC 4
+20 Sometime you need to start/stop windows services from your C# MVC application. Here i am sharing how you can do that: 1) To access …
The type or namespace name ‘ServiceController’ could not be found
+20 May times you need to add namespaces to your application, here I sharing how you can add “System.ServiceProcess” required to incorporate windows services to …
Visual Studio not loading few files and folder in Solution Explorer
+10 I am building a project in C# MVC4 using Microsoft Visual Studio 2012 and getting this issue. Whenever i add or delete any project …
You have not accepted the license agreements of the following SDK components
+30 While building Android application you may get error for not accepting license agreement like below: You have not accepted the license agreements of the …
WordPress: Top interview questions and answers
+20 What is the use of function.php in WordPress Every theme folder contains one and only one function.php. The purpose of this file is to …
How to read an Excel file using C# MVC 4
+2-1 Reading Excel file using C# MVC 4 is very easy. Here I am sharing the code how you can read cell by cell in …