Wednesday 26 September 2012

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.

Monday 24 September 2012

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.

Friday 21 September 2012

.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.

Sunday 16 September 2012

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.

Monday 10 September 2012

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).

Friday 7 September 2012

Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER

                                     Hi Friends, in this article I will explain about the Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER.For many interviews this question is frequently asked.
First of all we know those individually after that we will know differences.

Truncate:
TRUNCATE Command  removes all the data or all rows from a table.
·         We cannot use where clause with Truncate command.
·         The operation cannot be rolled back and no triggers will be fired because it does not log individual rows.
·          As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.
·         It frees the space containing the table.
·         Identity columns are re-seeded on this operation, if no seed was defined then the default value 1 is used.
·         This is a DDL command as its resets identity columns, deallocates data pages and empties them for use of other objects in the database.
© 2012-2018 Aspdotnet-Kishore.blogspot.com. All Rights Reserved.
The content is copyrighted to Kishore and may not be reproduced on other websites without permission from the owner.