Insert Data into Database using jQuery Ajax Method in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to insert data into database using jQuery ajax method in asp.net using c#, vb.net or jQuery insert data into database without postback in in asp.net using c#, vb.net.

Description:
  
In previous articles I explained read xml file and bind data to gridview in asp.net, Delete multiple rows in gridview using checkbox in asp.net, bind dropdownlist in asp.net gridview using dataset, cascading dropdownlist in gridview using asp.net, change gridview header dynamically in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to insert data into database using jQuery in asp.net using c#, vb.net.

Build (Create) a Popup Modal Window using jQuery Example

Introduction: 

Here I will explain how to create or build jQuery modal popup window with example. create modal popup window using jQuery  or jQuery modal popup window or dialog example to show alerts messages, notifications, errors and many more with beautiful css styles.

Description:
  
In previous posts I explained Show subscribe modal popup for website, Ajax confirmation box with modalpopup, Open/Close Ajax ModalPopUpExtender using JavaScript, Ajax modalpopup example to edit gridview rows and many articles relating to jQuery, Asp.net. Now I will explain how to build simple jQuery modal popup window with example.

Bind Data from Datatable to Dropdownlist in Asp.net using C#, VB.NET

Introduction:

Here I will explain how to bind data from datatable to dropdownlist in asp.net using c#.net, vb.net or populate / bind datatable from datatabase and bind that datatable to dropdownlist in asp.net using c#.net, vb.net. 

Description:

In previous posts I explained many articles relating dropdownlist, asp.net, jQuery, SQL Server, JavaScript. Now I will explain how to bind data from datatable to dropdownlist from database in asp.net using C#.net and VB.NET.

Populate (Fill) Dropdownlist from Database in Asp.Net using C#, VB.NET

Introduction:

Here I will explain how to populate or fill or load data in dropdownlist from database in asp.net using C#.net and VB.NET.

Description:

In previous posts I explained many articles relating asp.net, jQuery, SQL Server, JavaScript. Now I will explain how to fill or populate data in dropdownlist from database in asp.net using C#.net and VB.NET.

jQuery Check if Browser Supports History.Pushstate or Not in JavaScript

Introduction: 

Here I will explain how to check if browser supports history.pushState HTML5 history function or not in JavaScript and jQuery. Generally we will use pushState function in HTML5 to change browser url without refresh or reloading page in jQuery and JavaScript.

Description:
  
In previous articles I explained jQuery remove() and empty() function example, jQuery check whether div element is empty or not, disable mouse right click using jQuery and JavaScript, jQuery add multiple markers to google map from database, jQuery check file size before upload in asp.net and many articles relating to jQuery, JSON, JavaScript and asp.net. Now I will explain how to check if browser supports history.pushState function of HTML5 in JavaScript and jQuery.

jQuery Change Browser URL without Reloading (Refreshing) Page using HTML5 Pushstate Function

Introduction: 

Here I will explain how to change browser url without reloading or refreshing page using HTML5 history api in JavaScript and jQuery. By using pushState function in HTML5 history API we can change browser url without reload or refresh page in jQuery and JavaScript.

Description:
  
In previous articles I explained jQuery remove() and empty() function example, jQuery check whether div element is empty or not, disable mouse right click using jQuery and JavaScript, jQuery add multiple markers to google map from database, jQuery check file size before upload in asp.net and many articles relating to jQuery, JSON, JavaScript and asp.net. Now I will explain how to change browser url without reloading or refreshing page using HTML5 history api pushState function in JavaScript and jQuery.

Show(Display) DataTable in HTML Table in Asp.Net from Database using C#, VB.NET

Introduction: 

Here I will explain how to show or display data from datatable in html table in asp.net from database in c#, vb.net or display data from database in html table in asp.net using c#, vb.net with example or get data from datatable and show it in html table in asp.net using c#, vb.net.

Description:
  
In previous articles I explained scrollable table with fixed header using css, jQuery play youtube videos in asp.net, edit gridview row details with ajax modalpopupextender in asp.net, import data from excel to database in asp.net, read xml file and bind data to gridview in asp.net, insert selected gridview rows in database in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how insert display datatable data html table in asp.net from database in c#, vb.net.

Get Data from Gridview into Datatable in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to get data from gridview to datatable in asp.net using c#, vb.net or fetch or get gridview data and insert into datatable in asp.net or get gridview data into dataset using c#, vb.net with example.

Description:
  
In previous articles I explained insert selected gridview rows into database in asp.net, take database backup in sql server 2008, encrypt and decrypt passwords in sql server 2008, Google Map show info windows when click on marker 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 get data from  gridview to datatable in asp.net using c#, vb.net.

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.