Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

SQL Server Indexes Tutorial | Different Types of Indexes in SQL Server | Difference between Clustered Indexes and Non-Clustered Indexes in SQL Server

Jul 30, 2011 15 comments
Introduction:

Here I will explain about SQL Indexes and different types of indexes and advantages of indexes in SQL Server.

Description:

An index can be created in a table to increase the performance of application and we can get the data more quickly and efficiently. Let’s see an example to illustrate this point suppose now we are reading book in that I need to check the information for dbmanagement to get this information I need to search each page of the book because I don’t know in which page that word information exists it’s time taken process. Instead of reading the each page of book to get that particular word information if I check the index of book (Glossary) it is much quicker for us to get the pages which contains the information with dbmanagement word. By using second method we can save lot of time and we can get information in efficient way.

what is stored procedure in Sql server | what are the advantages of using stored procedures in sql server

Jul 28, 2011 37 comments
Introduction:

Here I will explain about what is stored procedure is and advantages and disadvantages of stored procedures in sql server

Description:

A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure

SQL Union Operator | SQL Union ALL Operator | Difference between Union and Union ALL Operators in SQL |

Jul 27, 2011 0 comments
Introduction:

Here I will explain about SQL UNION and UNION ALL operators and differences between UNION and UNION ALL in SQL Server

Description

Union Operators are used to combine the result of two or more select queries into single result set.

Primary key constraint in sql server, foreign key constraint, unique key constraint, not null, check constraint in SQL Server

Jul 10, 2011 19 comments
Introduction:

Here I will explain primary key constraint in sql server, foreign key constraint in SQL sever, unique key constraint in sql server, not null constraint in sql server and check constraint in sql server.

Description:

A Constraint is a property that we can assign to column in table. By assigning constraint property on column we can prevent the users to enter inconsistent of data in columns. We can assign these Constraint properties during the time of creation of table (By Using CREATE TABLE statement) or during the time of changing the existing table structure (By Using ALTER TABLE statement).

how to bind generic list to gridview | Bind Database values to Generic list using asp.net | Binding custom generic class list to Gridview

Jul 8, 2011 13 comments
Introduction

Here I will explain how to bind generic list to gridview and how to bind database values to generic list using asp.net.

Description:

In previous article I explained clearly about what is WCF and how we can use WCF in our applications. Now I will explain how to use Lists in our application to bind data to gridview and I will explain how to bind database values to generic list using asp.net. 

Unable to start debugging on the web server. The web server is not configured correctly. See help for common configuration errors. Running the web page outside of the debugger may provide further information

Jul 5, 2011 6 comments
Introduction:

In this article I will explain how to solve unable to start debugging on the web server. The web server is not configured correctly problem in iis7.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. Now I will explain how to solve unable to start debugging on the web server. The web server is not configured correctly problem in asp.net. 

Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same.

3 comments
Introduction:

In this article I will explain how to solve Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same. Problem in asp.net.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. After completion of coding I tried to run my application on my local system during that time I got error like 

how to consume (or) use wcf service in web application | how to consume (or) use wcf service in asp.net | wcf tutorial with examples for beginners

58 comments
Introduction:

Here I will explain how to use or consume WCF (windows communication foundation) service in web application using asp.net.


Description:
In previous articles explained clearly what WCF (windows communication foundation) is and how to create and consume WCF service in c#(windows application) and I also explained clearly uses of WCF Service. Now in this article I will explain how to consume WCF service in web application.

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.