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

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.

How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime

                       Hi Friends, in this article I will explain about How to add dynamic controls in VB.NET or C# windows forms or  How to add textbox at runtime or How to dynamically add control with loop at Run time.

                       Suppose if we want to add textboxes in the loop then we use this process. Suppose if we to display some number of textboxes then we can’t take the textboxes before run the code. For that time we can display textboxes at runtime. Not only textboxes we can any controls like labels, buttons, checkboxes etc.

Shortcut Keys for Visual Studio || Visual Studio ShortCut KEYS

                            Hi friends, in this article I will give some important shortcuts to Visual Studio.      
In previous articles i explained about how to readthe data from excel in VB.NET or C# windows Forms.,the TreeView Control,SiteMapDataSource Control in ASP.NET ,how to send email using Gmail in VB.NET or C#.                    

                            I think it will useful to all .NET Developers and learners. Because Shortcut keys decreases the time when we writing the code. I searched in so many sites and get some Shortcut keys and place them in below tables. I think it may useful to you. Happy reading my blog and Thanks for reading my Blog.  If you want to give any advices then give advice as comment in the comment box.

Read data from Excel in VB.NET or C# windows forms | Export data from Excel to Text file

                                    Hi friends, in this article I will explain about how to read the data from excel in VB.NET or C# windows Forms.

                                   I searched so many sites and finally get the solution of how to read the data from excel in VB.NET or C# windows Forms.You can know the How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime in the next article How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime

For this first we have to add the reference Microsoft.Office.Interop.Excel.

Menu—project—Add reference—COM—Microsoft Excel 12.0 Object Library

Next come to code and imports or using Microsoft.Office.Interop.Excel

ASP.NET Validation Controls with example | Range validator in ASP.NET and how to use the range validator in ASP.NET

                                Hi Friends , in this article I will explain about the Range validator and how to use the range validator in ASP.NET

                       I already explained in the previous article ASP.NET Validation Controls with example | How to use Validation Controls in ASP.NET | RequiredFieldValidation Control in ASP.NET,ASP.NET Validation Controls with example | How to use ControlValidator in ASP.NET | ControlValidator Control in ASP.NET

ASP.NET Validation Controls with example | How to use ControlValidator in ASP.NET | ControlValidator Control in ASP.NET

                                   Hi Friends, in this article i will explain about the CompareValidator in the ASP.NET. CompareValidator is used to compare the value of one input control with value of another input control or a fixed value.

                                   I already explained in the previous article ASP.NET Validation Controls with example | How to use Validation Controls in ASP.NET | RequiredFieldValidation Control in ASP.NET

ASP.NET Validation Controls with example | How to use Validation Controls in ASP.NET | RequiredFieldValidation Control in ASP.NET

                                     Hi Friends, in this article I will explain about the validation controls in ASP.NET and how to use the validation controls in ASP.NET.

                                     Validation server controls are used to validate user-input. Validation controls are used to validate the input data, because if we didn't put the validation to user input then it will display the error to the user.
In previous articles i explained some interview Questions on ASP.NET,VB.NET and SQL Server.

WCF Instance Management | Wcf Tutorial | Three ways to do WCF instance management (Per call, Per session and Single)

Hi Friends, in this article I will explain about the Instance Management in WCF.

In previous article i already explained about What is webservice? What is WCF? Difference between webservice and WCF.,Fundamentals of WCF | WCF Fundamentals | WCF Tutorial for Beginners | End Point in WCF,Binding and behaviour in WCF | Fundamental of WCF,What are Contracts in WCF | Service Contract | Data Contract | Message Contract | Fault Contract in WCF 

ASP.NET 2.0 Page Event Life Cycle

                             Hi Friends, in this article i will explain about ASP.NET 2.0 Page Life Cycle.

Main Events :

1. OnPreInit

2. OnInit

3. OnInitComplete

4. LoadViewState

5. OnPreLoad

Interview Questions and Answers on SQL SERVER Part II

                             Hi friends,in this article i will explain some interview questions on sql server,in previous article i already explained Interview Questions and Answers on SQL SERVER Part I,ASP.NET Interview Questions Part II | .NET interview Questions fot 1-2 years Experience

and  Interview Questions on .NET

ASP.NET Interview Questions Part II | .NET interview Questions fot 1-2 years Experience

                     Hi Friends, in this article I will explain about the some interview questions on ASP.NET.I already explained Interview Questions on SQL SERVER Part I | Interview Questions and Answers on SQL SERVER Part I ,Interview Questions in VB.NET, .NET Framework.,Interview Questions and ASP.NET interview Questions .

Windows Authentication to Access SQL Server Through a ASP.NET Web Application || Configuring SQL Server || Configuring IIS: || Configuring the ASP.NET Web Application || Creating Connection Strings

We need to configure the following four different areas to access Windows integrated security:

1.     SQL Server

2.     IIS Web Server

3.     ASP.Net web application

4.     ConnectionString

Interview Questions in VB.NET, .NET Framework. | Interview Questions Part II

                      Hi friends, in this article I am posting some interview Questions VB.NET and .NET Framework. In previous articles i explained interview questions in ASP.NET,VB.NET,Sql Server in Interview Questions.Check it once if you need.

1.What is VB.NET?

 Visual Basic .NET (VB.NET), is an object-oriented computer programming language .

VB.Net is windows based programming language. It supports OOP concepts such as

abstraction, inheritance, polymorphism and aggregation.
_________________________________________________________________

What is JQUERY | JQuery Tutorial | JQuery syntaxes

                                    Hi Friends, in this I will explain about the JQuery.I search in so many sites for the JQuery syntax and write the all the syntax  in the one program for the testing. I think it may useful to you.

JQuery:

jQuery is a JavaScript Library.

ASP.NET interview Questions Part-I | .NET interview Questions for 1-2 years Experience

                   Hi friends, in this article I am posting some interview Questions VB.NET and .NET Framework and i explained the interview questions in the previous articles Interview Questions on ASP.NET,VB.NET and SQL Server and ASP.NET Page Life Cycle Events || What is the sequence in which ASP.NET events are processed? Interview Questions on ASP.NET  All the Best Friend.

1.What is VB.NET?

 Visual Basic .NET (VB.NET), is an object-oriented computer programming language .

VB.Net is windows based programming language. It supports OOP concepts such as

abstraction, inheritance, polymorphism and aggregation.