how to change CSS dynamically from code behind in asp.net using C#

Description:-

In this example we explain that how to change CSS dynamically from code behind in asp.net using C#. or how to change CSS file programmatically in C# code(back end  code) in asp.net.

Some time we have requirement like if user click on or check Lightweight button then Lightweight CSS is apply to the application for these user only same like if user checked or click on Professional button then Professional look is applied to the application for these user only these totally is dynamic and depend on user requirement.

So how to change or switch CSS file dynamically from code behind in asp.net using C#.

how to get values from Query String using JQuery

Description:

In this example we explain that how to get values from Query String using JQuery in asp.net. Or how to read Query String in JQuery in asp.net.

Generally we often use query string to pass data from one web page to another web page. But generally we fetch or read data from query string using C# code means using back end code. But in this example we explain that how to get or read query string in front end side using jQuery.

Create and Drop SQL Server Table pro-grammatically using ADO.Net, C#

Description:-

In this example we explain that how to create and drop table of SQL Server programmatically using ADO .Net. Or how to create runtime SQL Server table dynamically from the asp.net using C#.

Sometime we have requirement like when new user is register in our site then we create table with its name in SQL Server for the upcoming process using asp.net in C#.

So create and drop table from SQL Server through asp.net script (code) is described below

Return all records when Parameter is Blank (Empty) or Null in SQL Server Query or Stored Procedure

Description:-

In this example we explain that how to return all records (Rows) when parameter is blank (Empty) or null in SQL Query or SQL Stored Procedure.

Or how to retrieve all record from the SQL Query when passed parameter is null, empty or blank.or returns all record when parameter is passed to filter the data in SQL Server.

Sometime we have requirement like returns only those record where customer equal this customer but if the passed parameter customer is null then SQL Query will returns all the rows from the table.\

These scenario generally we used in when we required filtering rows based on different condition.so below is the SQL Query that will returns all the records when the parameter is null or empty.

how to pass Table name as Parameter to Stord Procedure in SqlServer

Description:-

In this example we explain that how to pass Table name as Parameter to Stord Procedure in SqlServer.or how to pass Table name as a parameter or variable to sp_executesql command in SQLServer.

Sometime we have requirement like to pass only Table name to stored procedure as a parameter and returns the record from it depend on pass the Table argument.

Suppose if you pass the Employee as the Table name parameter then procedure will returns the Employees record same like for other table that you want to pass to stored procedure as a parameter.

So how to pass Table as a parameter to the stored procedure in SQLServer.

Display multiple data Fields (Columns) in GridView BoundField in ASP.Net using C#

Description:-

In this example we explain that how to display multiple column in GridView Bounfield in asp.net.or how to display multiple data fields in Gridview in asp.net.

As we all know that by default the BoundField column of gridview does not allow to bind multiple coloum.so to overcome from this we must have to use RowDataBound event of the Gridview and in which we can displayed multiple column (Data Field) in BoundField of Gridview.

how to detect if JavaScript is disabled in browser.

Description:-

In this example we explain that how to detect if JavaScript is disabled. Or how to check JavaScript is enabled or disabled in your browser using JavaScript.

We all know in every application JavaScript greatly enhance the experience for the user whether it is validate from data or modal popup or anything. Sometime what happen when some users don’t have JavaScript enabled in their browser so your JavaScript functionality is not worked properly for those user so point is that you need to be able to detect this and display proper message like JavaScript is not enabled in your browser please enabled it to perform this action.

Below is the code for if JavaScript is disabled in your browser you can easily display warning message to the user by adding “noscript” tab.

System.Globalization to bind all countries to Dropdownlist in asp.net.

Description:-

In this example we explain that how to bind all countries to Dropdownlist in asp.net using System.Globalization. Or how to populate dropdown list with all country in asp.net.

Before use System.Globalization what is this?

System.Globalization is a namespace in .Net Framework and its contains various classes like country/region, calendars etc... So you can directly access it by using the system. Globalization namespace in your application.

Automatically redirect User to Login page after Session Timeout in ASP.Net

Description:-

In this example we explain that how to redirect to login page when user session expires in asp.net.

Or how to automatically redirect user after session timeout in asp.net. Here we set session timeout 1 minute in web.config. In every web application we need to maintain the session expiration time for the security reason.

Here in this example user is automatically redirect to the login page when session time is expired like 1 minute for this example.

how to show “More” and “Less” link using jQuery in asp.net.

Description:-

In this example we explain that how to show “More” and “Less” link using jQuery in asp.net. or show “More” and “Less” link to display the content using jQuery.

Here in this example when you run the form then it will display some part of the content and show “More” link below. When you click this link then it will display full content of the form.

For example suppose you have 100 products and you want to display all in one page so use this show “More” and “Less” link functionality because you cannot display full content of the one products to a page because content is very long.

Another example is that if the comment text is very long then extra words are hide and show using show “More” and “Less” link is presented to user.

SQL SERVER – Query to Find Column From All Tables of Database

Description:-

In this example we explain that how to find all tables containing column with specified name in SQL Server. Or Query to find column from all tables of database.

 How many tables in your database have column name like ‘LeadId’?

This was an interesting question if someone ask you or if you have requirement like above question then what to do?

Once way is to you manually check the table one by one and check that this column is exists in table or not but if there are 1000 tables in your database then it was very time consuming. So best way is to write the following query and get your result in just one second.