Data Access namespaces in .NET? | What are data access namespaces in .NET?

                                 Hi Friends, in this article I will explain about what are the data access namespaces in .NET?

                                 I already explained in the previous article what is ADO.NET? and What are the two fundamental objects in ADO.NET?,.NET Framework Data Providers | What are .NET Framework Data Providers see once if you need.

                                 The core ADO.Net classes exist in the System.Data namespace in the .Net Framework class library.

How to export gridview data to CSV file or Export Gridview data to CSV file using C# or VB.NET | Export Dataset/Datatable to Excel or CSV?

                                Hi Friends, in this article I will explain about How to export GridView data to CSV file or Export Gridview data to CSV file using C# or VB.NET | Export Dataset/Datatable to Excel or CSV?

                               In this article I will explain about how to take the data from database and Display in GridView and save as Excel file.

I will explain using the below example.

                               Take GridView and button and set the GridView id as StudentGridView and button as Button1.

.NET Framework Data Providers | What are .NET Framework Data Providers

                    Hi Friends, in this article I will explain about .NET Framework Data Providers ?

In previous article I already explained about What is ADO.NET? and What are the two fundamental objects in ADO.NET?  see once if you need.

.NET Framework Data Providers:

• Data Provider is nothing but a set of libraries that is used to communicate with data source.
• The libraries specifically written for .NET applications to connect and work with data sources are known as .NET Framework Data Provider.

What is ADO.NET? and What are the two fundamental objects in ADO.NET?

                                Hi Friends, in this article I will explain about what is ADO.NET? And what are the two fundamental objects in ADO.NET?

What is ADO.NET?

•  The full form of ADO is ActiveX Data Object.
• ADO.NET is very important feature of the .NET Framework.

Differences between Stored Procedures and Functions | Stored Procedures vs Functions (Difference between SP & UDF)

                                Hi Friends, in this article I will explain about what is the differences between stored procedures and functions in SQL Server. In many interviews this question is compulsory.

                             I already explained in the previous article Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER.

Difference between stored procedures and functions:

• Stored Procedure can return zero or n values whereas function can return 1 value.Function must return a value which is mandatory but in stored procedure it is optional. Procedure can   return multiple values (max 1024).