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.

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

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.

Lock User After 3 Attempts in Asp.net using C#, VB.NET with Example

Introduction: 

Here I will explain how to lock or unlock user after 3 attempts in asp.net using c#, vb.net with example or lock user after 3 failed login attempts in asp.net using c#, vb.net with example.

Description:
  
In previous articles I explained gridview examples 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 how to lock or unlock user after 3 attempts in asp.net using c#, vb.net with example.

Paging in Asp.net Gridview using Pageindexchanging Event with Example using C#, VB.NET

Introduction: 

Here I will explain how to implement paging in gridview in asp.net using pageindexchanging event with example using c#, vb.net or use pageindexchanging event to implement paging in asp.net gridview in c#, vb.net with example.

Description:
  
In previous articles I explained gridview examples 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 implement paging in gridview in asp.net using pageindexchanging event with example using c#, vb.net.

Bind Data in Gridview in Asp.net using Dataset (DataTable) in C#, VB.NET

Introduction: 

Here I will explain how to bind gridview in asp.net using dataset in c#, vb.net with example or bind asp.net gridview using dataset from database in c#, vb.net with example.

Description:
  
In previous articles I explained gridview examples 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 bind gridview in asp.net using dataset in c#, vb.net with example.

Change Gridview Row Color Based on Data in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to change gridview row color based on data in asp.net using c#, vb.net with example or dynamically change asp.net gridview row color based on data in c#, vb.net with example.

Description:
  
In previous articles I explained edit gridview row details with ajax modalpopup, show sum of columns total in gridview footer, filter asp.net gridview based on dropdown selection, Repeater Control Example in asp.net, sorting columns in repeater control in asp.net, Display time like facebook/twitter like 1 minute ago, hour ago and many articles relating to gridview in asp.net, css, c#, vb.net and jQuery. Now I will explain how to change gridview row color based on data in  asp.net using css in c#, vb.net with example.

Dynamically Change Asp.Net GridView Row Background Color Based on Condition in C# and VB.Net

Introduction: 

Here I will explain how dynamically change gridview row background color based on condition in asp.net using css classes in c#, vb.net with example or dynamically change asp.net gridview row background color based on condition in c#, vb.net with example.

Description:
  
In previous articles I explained edit gridview row details with ajax modalpopup, show sum of columns total in gridview footer, filter asp.net gridview based on dropdown selection, Repeater Control Example in asp.net, sorting columns in repeater control in asp.net, Display time like facebook/twitter like 1 minute ago, hour ago and many articles relating to gridview in asp.net, css, c#, vb.net and jQuery. Now I will explain how to change gridview row background color dynamically on condition in asp.net using css in c#, vb.net with example.

What is SQL Injection and How do you Prevent it in Asp.net using C#, VB.NET

Introduction:

Here I will explain what is sql injection attacks and how to prevent it in asp.net website with example and how to prevent SQL injection attacks in asp.net using c#, vb.net with example. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous post I explained jQuery scroll to particular position of div when click on link, SQL Server remove duplicate records from table, SQL Server insert multiple rows with single insert statement, how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain what is sql injection attack in asp.net website with example.

C# Interview Questions and Answers for Experienced & Freshers with Examples

Here I will explain c#.net interview questions and answers for freshers and experienced people or interview questions and answers in c#.net for 2+ or 3+ years of experienced people or freshers with examples. 

Please check below questions for c#.net interview questions and answers

OOPS (Object Oriented Programming) Concepts in C#.NET with Examples

Here I will explain oops concepts in c# with examples or object oriented programming concepts in c#.net with real time examples or oops or object oriented programming in asp.net with example.

Now let’s start learning about OOPS concepts in c#.net with real time examples

OOPS Concepts

Class:

 It is a collection of objects.

Object:

It is a real time entity.

An object can be considered a "thing" that can perform a set of related activities. The set of activities that the object performs defines the object's behavior. For example, the hand can grip something or a Student (object) can give the name or address. In pure OOP terms an object is an instance of a class