how to pass parameters to crystal reports / .rdlc reports using asp.net | Passing Parameters from ASP.NET Application to Crystal Report using asp.net

Introduction:

In this article I will explain how to pass parameters to crystal reports using asp.net.

Description:

In Previous post I explained clearly about how to create crystal report using asp.net. Now I will explain how to load crystal reports based on parameters using asp.net. This post is continuation of previous post Create crystal report using asp.net. if you didn’t read previous post crystal reports please check that one then come to this one because I am continuing from previous post in that I explained clearly to create the database tables and bind the reports and display it on page. 

How to create Crystal Reports in asp.net | Crystal Reports Sample Using asp.net

Introduction:

In this article I will explain how to create crystalreports in asp.net.

Description:

In Previous posts I explained lot of articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain about crystal reports it is standard reporting tool for visual studio by using these we can display reports regarding employee details and display charts etc and crystal reports need minimal coding to display result. 

Asp.net filter gridview records with dropdownlist selection | Gridview Filter Expression with dropdownlist using asp.net | Beautiful style for Gridview using css

Introduction:

In this article I will explain how to change the appearance of gridview and how to filter gridview records with dropdownlist selection using asp.net.

Description:

In Previous posts I explained lot of articles regarding Gridview. Now I will explain how to implement beautiful looking gridview and filter gridview records with dropdownlist selection using asp.net. To implement this first design the table in database and give name UserInfomation

how to implement cascading dropdownlist in gridview using asp.net

Introduction:

In this article I will explain how to implement cascading dropdownlist in gridview using asp.net. 

Description:

In Previous posts I explained clearly how to implement ajax cascading dropdownlist using asp.net  and lot of articles regarding Gridview. Now I will explain how to implement cascading dropdown list in gridview using asp.net. Here I am using previous implemented article ajax cascading dropdownlist in asp.net to bind data to dropdownlists. 

JQuery scrollable gridview with fixed header in asp.net

Introduction:

In this article I will explain how to implement scrollable gridview with fixed header in asp.net using JQuery. 

Description:

In Previous posts I explained lot of articles regarding Gridview. Now I will explain how to implement scrollable gridview with fixed header in asp.net. I have one gridview that contains lot of records and I used paging for gridview but the requirement is to display all the records without paging. I removed paging at that time gridview occupied lot of space because it contains more records to solve this problem we implemented scrollbar.  After scrollbar implementation if we scroll the gridview we are unable to see Gridview header. 

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Introduction:

Here I will explain how to solve the problem “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)” during the time of connect to database.

what are the sealed classes in c# | uses of sealed keyword in c# |Sealed classes example in c# | Object-Oriented Programming: Sealed Classes

Introduction

Here I will explain what are the sealed classes in c# and uses of sealed classes in c#.

Description:

In previous article I explained clearly about OOPS concepts now I will explain what is the use of sealed classes in c#. Generally if we create classes we can inherit the properties of that created class in any class without having any restrictions. In some situation we will get requirement like we don’t want to give permission for the users to derive the classes from it or don’t allow users to inherit the properties from particular class in that situations what we can do? 

where is asp.net 3.5 in IIS | how to publish/setup asp.net 3.0 and 3.5 applications on IIS.

Introduction:

In this article I will explain where is asp.net 3.5 in IIS and how to setup asp.net 3.0 and 3.5 applications on IIS and how to publish asp.net 3.5 applications on IIS.

Description:

I am writing this post because in one of the interview interviewer has asked one interesting question that is now you’re using .NET 3.5 if I want to deploy .NET 3.5 version web application which type asp.net version I need to select in IIS or same question another way if I setup .NET 3.5 framework version on my machine whether I will get 3.5 version in IIS ASP.NET version dropdown or I will get only 2.0.50727, 1.1.4322 versions.

Disable Copy Paste cut options in textbox using javascript in asp.net

Introduction

Here I will explain how to disable copy, cut and paste functionality (Ctrl + c/Ctrl + v/ Ctrl+ x) in asp.net textbox using JavaScript.

Description

In previous post I explained clearly how to disable right click on asp.net web page. Now I will explain how to disable copy, cut, paste or Ctrl+c, Ctrl+v, Ctrl+x options in textbox on aspx page in asp.net. To achieve this we have two methods first method is directly set copy, cut and paste options return false in textbox to disable and second one we can use JavaScript functionality to disable copy, cut and paste options to implement this one first create new website and design your Default.aspx page like this 

How to disable right click on asp.net web page using JavaScript | Disable mouse right click on webpage

Introduction

Here I will explain how to disable right click on website using JavaScript.

Description

One day I got requirement like do not allow users to right click on website to see source code of page for that I written JavaScript functionality to disable right click on website to achieve this create new website and design your Default.aspx page like this 

How to change Page theme dynamically in asp.net | How to change website theme dynamically at runtime using asp.net

Introduction:

In this article I will explain how to change themes dynamically using asp.net.

Description:

In many sites if you observe we found options like changing the color of websites based on selection of color after seen those type of theme change options I decided to write the post to change the themes dynamically by using asp.net.

What is an application object and where we use application object in asp.net | application object sample using asp.net

Introduction:

In this article I will explain what application object is and I will explain how we will use application objects in asp.net.

Description:

Today I am writing this post to explain about application object in asp.net. In one of the interview I got question like what application object is and where we will use application object in asp.net.

The specified display mode is currently disabled on this page. Make sure personalization is enabled for the current user

Introduction:

Here I will explain how to solve the problem The specified display mode is currently disabled on this page. Make sure personalization is enabled for the current user during personalization of webpart in application.

Description:

During the time of webpart personalization of application I got error like

Failed to update database because the database is read-only | Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only in iis

Introduction:

Here I will explain how to solve the problem Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only during the time of publish application using asp.net.

Description:

I deployed one of my website in IIS and trying to test the application during that time I got error like this

What are the Differences between ASP.NET 3.5 and ASP.NET 4.0 | What are new features in Asp.net 4.0

Introduction

Here I will explain about differences between Asp.net 3.5 and Asp.net 4.0. 

Description

In previous post I explained differences between asp.net 1.0 and asp.net 2.0 and in another post I explained differences between asp.net 2.0 and asp.net 3.5 . Now I will explain about differences between asp.net 3.5 and asp.net 4.0.

What are the Differences between asp.net 1.0, asp.net 1.1 and asp.net 2.0

Here I will explain about differences between asp.net 1.0, 1.1 and 2.0 versions. 

Asp.net 1.0 & 1.1 version

In these Asp.net versions IIS should be installed by user.  

Asp.net 2.0 version

In this version IIS comes along with dotnet installation no need to install separately and in Asp.net 2.0 many new features has came into picture like partial classes, master pages, skins and themes, roles and membership profiles, Generics and many new controls etc. I will explain each feature clearly. Main purpose of Asp.net 2.0 is used to increase productivity, use same controls for all types of devices, faster and better web application.

what are the Difference between ASP.NET 2.0 and ASP.NET 3.5 | Multi Targeting in asp.net | what are the Asp.net 3.5 features

Here I will explain about differences between asp.net 2.0/3.0/3.5. Generally we will see the questions like difference between Asp.net 2.0, 3.0 and 3.5 but there is no Asp.net 3.0 version. We have a version of 3.0 .NET Framework.

Asp.net create watermark text for textbox in javascript

Introduction

In this article I will explain how to create or set watermark text for textbox using JavaScript.

Description:

One day I got requirement like showing watermark text in textbox to achieve this requirement I used JavaScript functionality for that first Design your aspx page like this 

Interview Questions Part-7 | What is a deadlock in SQL Server | What are “GRANT” and “REVOKE’ statements in SQL | How do you find the Second highest Salary in SQL Server

What is a deadlock in SQL Server?

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.

Interview Questions Part-6 | What is @@ROWCOUNT in SQL | What is Difference between Commit and Rollback in SQL | What is Candidate key, alternate key and composite key in SQL | What are Isolation Levels in SQL | What is Lock Escalation in SQL Server

What is the Use of @@ROWCOUNT?

Returns the number of rows affected by the Query.

Ex:

UPDATE authors SET au_lname = 'Jones'

WHERE au_id = '999-888-7777'

IF @@ROWCOUNT = 0

print 'Warning: No rows were updated'

Interview Questions Part-5 | What is PRIMARY KEY Constraint in SQL Server | What is UNIQUE KEY Constraint | What is FOREIGN KEY Constraint | What is CHECK Constraint | What is NOT NULL Constraint in SQL Server ?

What is PRIMARY KEY Constraint in SQL Server?

Primary key constraint is used to uniquely identify each record in database table. It won’t allow repetition or duplication of data. Each table is having only one primary key constraint and it contains only unique values. Primary key constraint doesn’t accept null values (Read more Here)

Interview Questions Part-4 | What is the Difference between a HAVING clause and a WHERE clause in SQL Server | What is Connection Pooling and why it is used | What are the Authentication Modes in SQL Server | What is the difference between UNION and UNION ALL | What is Identity in SQL Server

What is the Difference between a HAVING clause and a WHERE clause in SQL Server? 

They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query, whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query

Interview Questions Part-3 | What is an Index in SQL Server | What is the Difference between Clustered and a Non-clustered Index in SQL Server | What is Collation | What are Primary Keys and Foreign Keys in SQL Server | What’s the Difference between a Primary Key and a Unique Key in SQL Server

What is an Index in SQL Server?

An index is a physical structure containing pointers to the data. Indexes are created in an existing table to locate the data more efficiently and quickly (Read more Here)

Interview Questions Part-2 | What are the Different Types of Triggers | What is a View | What is the Difference between a Function and a Stored Procedure | What are the Advantages of Using Stored Procedures in SQL Server

What are the Different Types of Triggers?

After triggers and Instead of triggers 

After triggers are the triggers which are raised before the transaction committed or postback.

Instead of triggers are used to update the database tables which are associated with view instead of updating the view directly.

Interview Questions Part-1 | What is Normalization | What is De Normalization | What is a Stored Procedure | What is a Trigger in SQL Server

What is Normalization? 

In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.There are three main normal forms, each with increasing levels of normalization:

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

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

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 |

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

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

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

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.

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

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.

There is no compatible TransportManager found for URI. This may because that you have used an absolute address which points outside of the virtual application

Introduction:

In this article I will explain how to solve The page you are requesting cannot be served because of the extension configuration 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. After completion creation of WCF service I tried to host my application on my local system during that time I got error like 

The page you are requesting cannot be served because of the extension configuration problem in IIS7

Introduction:

In this article I will explain how to solve The page you are requesting cannot be served because of the extension configuration 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. After completion creation of WCF service I tried to host my application on my local system during that time I got error like 

Introduction to WCF - WCF tutorial | WCF Tutorial - Windows Communication Foundation | WCF Example | WCF Sample code in asp.net 3.5 | Basic WCF Tutorial for Beginners

Introduction:

Here I will explain what WCF (windows communication foundation) is, uses of windows communication foundation and how to create and use windows communication foundation in c#.

Description:

In previous articles explained clearly what webservice is and how to create and consume webservice using asp.net . In another post I explained clearly what windows service is and how to create windows service and sample of windows service using c#. Now in this article I will explain about windows communication foundation. First we will see what a WCF (window communication foundation) is and uses of WCF (windows communication foundation) after that we will see how to create and use WCF in c#.net.

The Service on local computer started and then stopped ,Some services stop automatically if there are not in use by other services or programs

Introduction:

Here I will explain how to solve the Service on local computer started and then stopped, some services stop automatically if there are not in use by other services or programs

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals and how to install windows service in system. In my system I tried to install windows service completion writing the code but at that time I was unable to install windows service I got error like this

how to delete windows service from system

Introduction:

Here I will explain how to delete windows service in our system.

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals and how to install windows service in system. Now I will explain how to delete windows service in our system.

how to install windows service using command prompt or install/uninstall .NET windows service

Introduction:

Here I will explain how to install windows service and how to start the windows service in our local machine.

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals. Now I will explain how to install windows service in our system.

To install windows service in your follow these steps

how to create Windows Service in c# or windows service sample in c#

Introduction:

Here I will explain what windows service is, uses of windows service and how to create windows service in c#.

Description:

Today I am writing article to explain about windows services. First we will see what a window service is and uses of windows service and then we will see how to create windows service.

how to show the tooltip for gridview header columns using asp.net

Introduction:

Here I will explain how to show the tooltip for gridview header columns using asp.net.

Description:

In previous article I explained clearly how to show tooltip for gridview rows and columns and in another post I explained clearly show up and down arrows for gridview sorting . Now I will explain how to show tooltip for gridview headers using asp.net with slight code modification using above posts. To display tooltip for gridview header first design your aspx code like this

Invalid length for a base-64 char array error during decryption of password using asp.net

Introduction:

Here I will explain how to solve the problem invalid length for a base-64 char array during decrypt of encrypted password using asp.net.

Description:

In previous post I explained clearly how to encrypt and decrypt password using asp.net . After completion code for encrypt and decrypt password if I run the program I get problem like

The requested page cannot be accessed because the related configuration data for the page is invalid problem in IIS

Introduction:

In this article I will explain how to solve the requested page cannot be accessed because the related configuration data for the page is invalid problem in IIS7.

 

Description:

Previously I explained how to solve Login failed for user in IIS. Recently I started working with IIS7 at that time I face some of strange problems to rectify those errors I did some modifications in IIS. After seen those errors I decided to write this post to help people who are need with this error.  I did one sample application and deploy application in IIS. I started running my deployed application at that time I get error like this 

System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool' in IIS7

Introduction:

In this article I will explain how to solve System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool' problem in IIS7. 

Description:

Recently I started working with IIS7 at that time I face some of strange problems to rectify those errors I did some modifications in IIS. After seen those errors I decided to write this post to help people who are need with this error.  I did one sample application and deploy application in IIS. I started running my deployed application at that time I get error like this 

System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool'

how to add Global.asax.cs file in asp.net or how to add Code behind file for Global.asax in asp.net

Introduction

Here I will explain how to add code behind file for Global.asax in asp.net.

Description:

In previous post I explained clearly about Global.asax file uses and events in asp.net. Here I will explain how to add code behind file to Golbal.asax in asp.net. In one of my project I started writing code in Global.asax file but we decided to write code in Global.asax.cs file code I tried to search for that one but that is not available in our application at that I learn one thing that is we need to add Global.asax and Global.asax.cs these files to our application. For that one first right click on solution explorer and select Add New item

What is the use of Global.asax file events in asp.net

Introduction

Here I will explain what is the purpose of Global.asax file and how we can use Global.asax file in asp.net and I will explain application level events in global.asax file.

Description:

The Global.asax file, also known as the ASP.NET application file, is an optional file that contains code for responding to application-level events raised by ASP.NET or by HttpModules.

The Global.asax file resides in the root directory of an ASP.NET-based application. The Global.asax file is parsed and dynamically compiled by ASP.NET.

Asp.net WebService or Creating and Consuming WebService in asp.net or Create and call webservice in asp.net or how to create webservice and how to use webservice in asp.net

Introduction:

Here I will explain what webservice is, uses of webservice and how to create webservice and how to consume webservice in asp.net.

Description:

Today I am writing article to explain about webservices. First we will see what is webservice is and uses of webservice and then we will see how to use webservice in our applications.

How To Set a Date Format In GridView Using ASP.NET or How to format datetime in gridview boundfield and template columns

Introduction:

Here I will explain how to set date format in gridview using asp.net

Description:

In previous post I explained how to convert datetime to date in sql server . Now I will explain how to format date in gridview. In many situations we will bind date and currency values to gridivew at that time our gridview is something like this

Ajax AutoCompleteExtender example or sample without using webservice (or) Asp.Net AJAX AutoComplete Extender From Database without using webservice

Introduction:

Here I will explain how to use Ajax AutoCompleteExtender without using webservice to display the words begin with prefix typed into the textbox using asp.net

Description:

In previous article I explained clearly how to implement AjaxAutoCompleteExtender with webservice. We can attach Ajax autocomplete exteneder to any textbox to implement this and after assign autocomplete extender to textbox and type more content than the specified minimum word length, a popup will show words or phrases starting with that value.  So the user can choose exact word from the popup panel. Here we are implementing autoCompleteextender to fetch data from the database without using Webservice.

Ajax rating control example with database or how to display value from database in rating control or display average rating for article using asp.net

Introduction:

Here I will explain how to use Ajax rating control with database to display average rating for particular article using asp.net

Description:

Previously I explained how to use Ajax Collapsible panel . Now I will explain how to use Ajax rating control with Database in asp.net. In many sites we will see rating options for books, articles and movies etc by giving rating option to user we have chance to know about particular thing how much users are feeling comfort with particular thing. In Ajax we have a rating control by using that we can display the rating option easily. Here I am storing each user rating details into database and displaying the average rating based on number of users rating. To achieve this first design one table in your database and give name like RatingDetails if you want to give another name you can but you need to change table name in code also.