Insert Multiple Selected Rows (Records) from Gridview to Database in Asp.net using Sqlbulkcopy in C#, VB.net

Introduction: 

Here I will explain how to insert multiple selected rows or records data from gridview into database in asp.net using sqlbulkcopy in c#, vb.net or insert selected gridview rows or records bulkily in database in asp.net using sqlbulkcop in c#, vb.net with example.

Description:
  
In previous articles I explained insert gridview data into database in asp.net, take database backup in sql server using query or management studio, import data from excel to database in asp.net, read xml file and bind data to gridview in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how insert selected gridview rows data into database in asp.net using sqlbulkcopy in c#, vb.net.

Use SqlBulkCopy to Insert Gridview Data into Database in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to use sqlbulkcopy to insert gridview data into database in asp.net in c#, vb.net or insert gridview data in datatable and insert in database in asp.net using c#, vb.net with example or insert bulk data from gridview to database in asp.net using sqlbulkcopy in c#, vb.net .

Description:
  
In previous articles I explained import data from excel to database in asp.net, read xml file and bind data to gridview in asp.net, create datatable dynamically and bind to gridview in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how insert gridview data into database in asp.net using sqlbulkcopy in c#, vb.net.

Angularjs Get Current Date or Time or DateTime with Example

Introduction: 

Here I will explain how to get current datetime in AngularJS or get only current date or time from AngularJS. By using “new Date()” function we can get current date or time or datetime in AngularJS.

Description:
  
In previous articles I explained Angularjs convert number to currency format, Angularjs get dropdownlist selected value, Angularjs convert text to uppercase while typing, Angularjs refresh div for every 1 second using interval mode, 5 + Angularjs Gridview and table plugin examples with demos and many articles relating to AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to get current datetime or date or time using AngularJS.

Read XML File & Bind Data to Gridview in Asp.net using C#, VB.NET

Introduction:

Here I will explain how to read xml file and bind xml data to gridview in asp.net using c#, vb.net or read and bind data to gridview from xml file in asp.net using c#, vb.net.

Description:

In previous articles I explained read xml node values and bind data to gridview, change gridview row background color conditionally in asp.net, Show sum of gridview column values in footer in asp.net and many articles relating gridview and xml in asp.net using c#, vb.net. Now i will explain how how to read xml file and bind xml data to gridview in asp.net using c#, vb.net.

In one situation I got requirement like read data from xml file and display it on webpage. My XML File Name as “Sample.xml” and that would contains data like this

SQL Server Remove (Delete) Duplicate Records from Table using Query

Introduction:

Here will explain how to remove duplicate records or rows from a table in SQL Server or delete duplicate records from table in SQL Server.

Description:

In previous articles I explained take database backup in sql server, covert rows to columns in sql server without using pivot table, substring function in SQL server, Replace function in SQL Server, how to delete duplicate records from datatable in asp.net. Now I will explain how to delete duplicate records from a datatable in SQL server. 

During work with one application I got requirement like get the unique records from datatable in sql server. Actually our datatable does not contain any primary key column because of that it contains duplicate records that would be like this

Take Database Backup in SQL Server 2008 using Query or Management Studio

Introduction:

Here I will explain how to write query to take database backup in sql server or take backup of database using sql server management studio. To take database backup in sql server we need to write query like “BACKUP DATABASE DatabaseName to Disk…etc” or directly from management studio we can take backup  in sql server.

Description:                           

In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to write query to take database backup or take database backup from sql server management studio 2008.

SQL Server Encryptbypassphrase and Decryptbypassphrase Functions with Example

Introduction:

Here I will explain what is encryptbypassphrase and decryptbypassphrase functions in sql server. By using these functions we can encrypt or decrypt string or text or password column in sql server. EncryptByPassPhrase function in sql server will encrypt the data and store it in varbinary format and DecryptByPassphrase function will decrypt varbinary encrypted string and show the result in decrypted format.

Description:                           

In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain use of encryptbypassphrase and decryptbypassphrase functions with example in sql server.

Encrypt and Decrypt String (Password) in SQL Server 2008

Introduction:

Here I will explain how to do encryption and decryption of string or text or password in sql server using encryptbypassphrase and decryptbypassphrase functions in sql server. EncryptByPassPhrase function in sql server will encrypt the data and store it in varbinary format and DecryptByPassphrase function will decrypt varbinary encrypted string and show the result in decrypted format.

Description:                           

In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to encrypt and decrypt the string or text in sql server.

Calculate Sum of DataTable Columns in Asp.Net using C#, VB.NET

Introduction: 

Here I will explain how to calculate sum of datatable column in asp.net using c#, vb.net or calculate sum of columns in datatable in asp.net using c#, vb.net with example. By using datatable compute property we can calculate sum of columns without having any loops in asp.net using c#, vb.net.  

Description:
  
In previous articles I explained lock user after 3 attempts in asp.net, bind dropdownlist in asp.net gridview using dataset, validate textbox controls inside gridview in asp.net, cascading dropdownlist in gridview using asp.net, change gridview header dynamically in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to calculate sum of columns in datatable using asp.net in c#, vb.net.

Google Maps API V3 - Show (Open) Infowindow when Click on Markers in Google Maps

Introduction:

Here I will explain how to show or open infowindow when click on markers in Google maps using Google maps API V3 with example in asp.net website or use Google maps API V3 to open or show infowindow when click on markers in Google maps using jQuery JSON in asp.net website.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to show or open infowindow when click on markers in Google maps using  Google maps api v3 in asp.net website using jQuery JSON  data.

Google Maps API V3 - Open or Show Only One Infowindow at a Time in Google Maps

Introduction:

Here I will explain how to open or show or keep only one infowindow at a time in Google maps using Google maps API V3 with example in asp.net website or use Google maps API V3 to open or show or keep only one infowindow at a time and close other infowindow in Google maps using jQuery JSON in asp.net website.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to add click event listener to marker in Google maps using  Google maps api v3 in asp.net website using jQuery JSON  data.

Google Maps API V3 - Add Click Event Listener to Marker in Google Maps Example

Introduction:

Here I will explain how to add click event listener to marker in Google maps using Google maps API V3 with example in asp.net website or use Google maps API V3 to add client event listener to marker in Google maps using jQuery JSON in asp.net website.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to add click event listener to marker in Google maps using  Google maps api v3 in asp.net website using jQuery JSON data in website.

Asp.Net Populate Google Maps V3 from Database with Multiple Markers

Introduction:

Here I will explain how to populate or show or add multiple markers to Google maps V3 from database in asp.net website using JavaScript or JavaScript populate or Show Google maps with multiple markers from database in asp.net.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, JavaScript Add multiple markers to google map, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to populate Google maps from database with multiple markers in asp.net website.