Import/Upload Excel Data to Asp.net Gridview in C#, VB.NET

Introduction:

Here I will explain how to import data from excel to gridview in asp.net using OLEDB in C#, VB.NET.

Description:
  
In previous article I explained How to Export gridview data to excel/word document, Import Excel data to sql database and some other articles relating to export gridview data. Now I will explain how to import data from excel to gridview in asp.net.

Find Null/Empty Values in Asp.net Datatable and Replace with Other Values

Introduction:

Here I will explain how to find null or empty values in datatable and replace with other values in asp.net using C#, VB.NET.

Description:

In previous posts I explained Dynamically create datatable in asp.net, jQuery display average rating with decimal values, jQuery generate thumbnails from you tube videos, jQuery redirect to another page after some time delay, send forgot password as email in asp.net and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to find null values in datatable and replace with other values in asp.net using C#, VB.NET.

c#- How to Convert Dataset to XML String in Asp.net, VB.NET

Introduction:

Here I will explain how to convert dataset to xml string in asp.net using C#, VB.NET.

Description:

In previous posts I explained Convert datatable to xml in asp.net, asp.net, C#, SQL Server Interview Questions, jQuery validate file extension in file upload control, send forgot password as email in asp.net and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to convert dataset to xml string in asp.net using C#, VB.NET.

C#.Net- How to Convert DataTable to XML String in Asp.net, VB.NET

Introduction:

Here I will explain how to convert datatable to xml string in asp.net using C#, VB.NET.

Description:

In previous posts I explained asp.net, C#, SQL Server Interview Questions, send gridview as email body, upload and download files from gridview and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to convert datatable to xml string in asp.net using C#, VB.NET.

Pass XML as Parameter from C# to SQL Stored Procedure in VB.NET

Introduction:

Here I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

Description:

In previous articles I explained read xml node values and bind data to gridview, how to insert and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

Delete a File from Asp.net Uploaded Folder using C#, VB.NET

Introduction: 

Here I will explain how to delete a file from a folder in asp.net using c# and vb.net.

Description:
  
In previous articles I explained Difference between sessionstate and viewstate, Highlight gridview rows on mouseover in jQuery, and many articles relating to asp.net, c#,vb.net and JQuery. Now I will explain how to delete a file from a folder in asp.net using c# and vb.net.

Asp.net Session State Example in C#, VB.NET

Introduction:

Here I will explain SessionState in asp.net with example using c# and vb.net.

Description:

In previous posts I explained ViewState Example in asp.net, Create ContactUs Form, Detect Browser type in jQuery, Scroll to particular link when click on link, send mail with images using gmail in asp.net and many relating articles in asp.net, jQuery. Now I will explain SessionState example in asp.net using c# and vb.net

Asp.net Open PDF File in Web Browser using C#, VB.NET

Introduction

Here I will explain how to open pdf file in web browser in asp.net using C# and VB.NET.

Description

In previous articles I explained Export Gridview data to PDF, Send values from one page to another page using QueryString, Joins in SQL Server, Highlight Gridview records based on search and many articles relating to Gridview, SQL ,jQuery,asp.net, C#,VB.NET. Now I will explain how to open pdf file in web browser in asp.net using C# and VB.NET.

Asp.net ViewState Example in C#, VB.NET

Introduction:

Here I will explain what is viewstate and uses of viewstate with example in asp.net using c# and vb.net.

Description:

In previous posts I explained Create ContactUs Form, Detect Browser type in jQuery, Scroll to particular link when click on link, send mail with images using gmail in asp.net and many relating articles in asp.net, jQuery. Now I will explain what is viewstate and uses of viewstate with example in asp.net using c# and vb.net.

Code for Forgot Password in Asp.net using C#, VB.NET with Email

Introduction:

In this article I will explain how to write code to recover forgot password in asp.net using c# and vb.net.

Description:

In previous posts I explained Create ContactUs Page in asp.net, send mail using gmail account in asp.net, send mail with images using gmail in asp.net, send html page as mail body in asp.net and many articles on send mail in asp.net. Now I will explain how to write code to recover forgot password in asp.net using c# and vb.net.

How to Create Asp.net Contact Us Page Form in C#, VB.NET

Introduction:

In this article I will explain how to create contact us form or page in asp.net using c# and vb.net.

Description:

In previous posts I explained send mail using asp.net, send mail using gmail account in asp.net, send mail with images using gmail in asp.net, send html page as mail body in asp.net and many articles on send mail in asp.net. Now I will explain how to create Contact Us form in asp.net using c# and vb.net.

Asp.net Difference between DataReader and DataSet and DataAdapter in C#, VB.NET

Introduction:

In this article I will explain difference between datareader, dataset and dataadapter in asp.net.

Description:

In previous posts I explained Interview Questions in asp.net,C#,SQL, difference between Executereader, ExecuteNonQuery and ExecuteScalar, difference between Len and DataLength functions, difference between int,tinyint and bigint and differences between char, varchar and nvarchar in SQL Server. Now I will explain difference between datareader, dataset and dataadapter in asp.net

Dynamically Add Meta tags to Aspx Page in Asp.net using C#, VB.NET

Introduction:

In this article I will explain how to add Meta tags dynamically to aspx page in asp.net.

Description:

In Previous posts I explained Differences between appsettings and connection strings, jQuery get hidden field values from asp.net gridview and many articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain how to add Meta tags dynamically to aspx pages in asp.net.

Show tooltip in Asp.net Dropdownlist items Mouseover Event in C#, VB.NET

Introduction: 

Here I will explain how to show tooltip in dropdownlist items on mouseover event in asp.net using C# and VB.NET.

Description:
  
In previous posts I explained Bind data to Dropdownlist from database, Bind Images to dropdownlist, Cascading dropdownlist example and many articles relating to dropdownlist, JQuery, asp.net etc. Now I will explain how to show tooltip in dropdownlist items on mouseover event in asp.net.

Show Bind Data to Asp.net Dropdownlist from Database in C#, VB.NET

Introduction:

Here I will explain how to bind or show 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 bind or show data in dropdownlist from database in asp.net using C#.net and VB.NET.

Bind Asp.net Gridview with DataReader in C#,VB.NET

Introduction:

 

In this article I will explain how to bind gridview with datareader in asp.net using C#.net and VB.NET. 

Description:

In previous post I explained Convert DataReader to DataTable, Send Gridview as Email body, Check/uncheck checkboxes in gridview using jQuery and many articles relating to asp.net, jQuery, SQL etc. Now I will explain how to bind gridview with datareader in asp.net using C#.net and VB.NET. 

Asp.net- Convert DataReader to DataTable in C#,VB.NET

Introduction:

 

In this article I will explain how to convert datareader to datatable in asp.net using C#.net and VB.NET. 

Description:

In previous post I explained ExecuteReader, ExecuteScalar, ExecuteNonQuery and differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net. Now I will explain how to convert datareader to datatable in asp.net using C#.net, VB.NET. 

DataReader

DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader for that check this post ExecuteReader Example in asp.net.

Asp.net- Pass a Table Valued Parameter to Stored Procedure in C# VB.NET Example

Introduction:

In this article I will explain how to pass a table valued parameter to stored procedure in asp.net using C#, VB.NET.

Description:

In previous post I explained Pass table as parameter to stored procedure in SQL Server. Now I will explain how to pass a table valued parameter to stored procedure in asp.net using C#, VB.NET.

ExecuteReader ExecuteNonQuery ExecuteScalar Examples in Asp.NET when to use what to use in C#.NET,VB.NET

Introduction:

In this article I will explain executereader executenonquery executescalar examples when to use what in asp.net using C#.net and VB.NET.

Description:

If you want to know which command object needs to be used in different situations for that you need to check this article

Differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net

If you want to know about each sqlcommand object check below articles

ExecuteReader Example in Asp.Net using C#,VB.NET

Introduction:

 

In this article I will explain ExecuteReader example in asp.net using C#.net and VB.NET. 

Description:

In previous post I explained ExecuteScalar Example, ExecuteNonQuery Example and differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net. Now I will explain ExecuteReader concept with one example in asp.net using C#.net, VB.NET. 

ExecuteReader

Execute Reader will be used to return the set of rows, on execution of SQL Query or Stored procedure using command object. This one is forward only retrieval of records and it is used to read the table values from first to last.