Using a Format File to Bulk Import Data in SQL Server

Posted on February 5, 2019 by Suresh Kamrushi in SQL Server

00 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

Posted on February 5, 2019 by Suresh Kamrushi in Javascript

+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

Posted on February 5, 2019 by Suresh Kamrushi 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

Posted on February 5, 2019 by Suresh Kamrushi in C#

+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

Posted on December 4, 2018 by Suresh Kamrushi in PHP

+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

Posted on November 20, 2018 by Suresh Kamrushi in Memories

+20 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

Posted on November 5, 2018 by Suresh Kamrushi in Mysql, PHP

+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

Posted on October 31, 2018 by Suresh Kamrushi in General

+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

Posted on October 11, 2018 by Suresh Kamrushi in Android

+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

Posted on September 28, 2018 by Suresh Kamrushi in Android

+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

Posted on September 28, 2018 by Suresh Kamrushi in C#, Windows

+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

Posted on September 26, 2018 by Suresh Kamrushi in C#, Windows

+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

Posted on September 17, 2018 by Suresh Kamrushi in C#

+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

Posted on September 4, 2018 by Suresh Kamrushi in C#

+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

Posted on September 4, 2018 by Suresh Kamrushi in Javascript

+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

Posted on August 22, 2018 by Suresh Kamrushi in C#

+30 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#

Posted on August 22, 2018 by Suresh Kamrushi 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

Posted on August 13, 2018 by Suresh Kamrushi in C#, SQL Server

+50 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

Posted on August 3, 2018 by Suresh Kamrushi in Javascript

+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

Posted on July 6, 2018 by Suresh Kamrushi in C#, Windows

+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

Posted on July 6, 2018 by Suresh Kamrushi in C#, Windows

+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

Posted on May 30, 2018 by Suresh Kamrushi in C#

+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

Posted on April 26, 2018 by Suresh Kamrushi in Android

+20 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

Posted on April 19, 2018 by Suresh Kamrushi in PHP

+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

Posted on April 19, 2018 by Suresh Kamrushi in C#

+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 …