Tuesday, May 30, 2017

Sql server: Insert multiple tables data into another table

In this article I am going to explain how to insert multiple tables data into one table in sql server.


Implementations:
I have created 2 tables Country and state, insert some dummy records into it. I want to insert country and state name into another table (countrystate).

Sunday, May 28, 2017

Add Facebook like, share and comment in asp.net website

In this article I am going to explain how to add Facebook like, share and comment box in asp.net website.


Implementation:
I want to add Facebook like, share and comment box to asp.net website. First of all open Facebook developer’s link https://developers.facebook.com/. You will see docs options in top menu, click on it. Documentation option page will be open and you can lot of options there. Look for social plugins under product docs.

Friday, May 26, 2017

Upload and read text file in asp.net

In this article I am going to explain how to upload and read text file in asp.net.


Description:
I want to upload and read the text file. Text file will be save to folder and content of text file will be displayed in textbox.

Monday, May 22, 2017

Upload and read word document in asp.net

In this article I am going to explain how to upload and read word document in asp.net.


Description:
I want to upload and read the word document. Word document will be save to folder and content on doc will be displayed in textbox.

Sunday, May 21, 2017

Asp.net : Get MAC address of system

In this article I am going to explain how to get MAC address of system using asp.net.


Implementation:
MAC (Media access control) address is the unique identifier of each device. To know MAC address go to command prompt and type ipconfig/all, hit the enter button.

Asp.net : Get MAC address of system

Sunday, May 14, 2017

Sql Server: Get records from/after specific record/id

In this article I am going to explain how to select records after a specific record/Id in sql server.


Description:
I want to get records from a specific record or id. I have created a table Tb_Country and insert some dummy records.

Generate limited random number and add hyphen (-) after each 4th character in asp.net

In this article I am going to explain how to generate limited random number and add hyphen after each 4th character in asp.net.


Description:
I want to generate 16 unique number and after each 4th number insert hyphen (-).

Saturday, May 13, 2017

Sql Server : Check string is Palindrome or not

In this article I am going to explain how to check string is Palindrome or not using Reverse function or without reverse function in sql server.


Description:
I want to check given text/string is Palindrome or not. Simplest way to check is using reverse function.
* Palindrome means word that reads same forward as backward.