How to find second highest or maximum salary of Employee in Sql Server

Description:-

in this example we explain that how to find second highest salary of the employee in sql server table. This is the most important question that is asked by interviewer in any interview that is write query for find second second highest salary of employee in sql table or fetch record that have second highest salary.

We all listen that How to find second highest or second maximum salary of an Employee is one of the most frequently asked question in interview.

Restrict the size of File when Uploaded How to Restrict the size of File when uploaded by user

Dynamically Read/Write File in asp.Net How to Read Write File in Asp.Net using C#

How to bind data to RadioButtonList control in ASP.NET using C# and vb.net

Description:-

In this example we explain that how to bind RadiobuttonList in Asp.Net or bind data to RadioButtonList from database in asp.net.

radiobuttonlist control enable user to select an item from list of radiobutton. data bind to radibutton is programmatically from database. We can also populate it manually by input list item inside radiobuttonlist tag.

In this example we have list of movies are bind to RadiobuttonList and user can easily select it and the selected value of the radibuttonlist are shown in in messagebox that you have selected this movie.

RadiobuttonList is a group of radio button and are used when there is a multiple item that can be display to user in a list.

Restrict the size of File when Uploaded How to Restrict the size of File when uploaded by user

Dynamically Read/Write File in asp.Net How to Read Write File in Asp.Net using C#

Treeview with CheckBox in Asp.Net

Description:-

In this examplw we explain that how to create Dynamic Treeview with checkbox in asp.net or create  Dynamic treeview with checkbox in hierchy format in asp.net.or treeview check uncheck all checkboxes using javascript without postback in asp.net.

In this example we include checkbox in treeview to select particular tree node or all tree node by selection of checkbox. Here we used javascript to avoid the postback of the checkbox when checkbox is checked.

You can also fetch all child tree node value by just selecting parent treenode using checkbox selection. Or also you can fetch the selected checkbox tree node value for performing insert,update,delete operation.

Dynamically Bind Data in Ajax Accordion Panel Bind Data to Accordion from databse

Restrict the size of File when Uploaded How to Restrict the size of File when uploaded by user

dynamically change GridView cell color based on cell value in ASP.NET

Description:-

In this example we explain that how to change the color of the gridview cell based on some condition. Or dynamically change Gridview cell color based on cell value condition in asp.net.or how to dynamically change the Background color of ASP.Net GridView Row based on some conditions


Sometime we have requirement like display data in grid in different color so end user can easily understand. Suppose we have one table student with coloumn name age. If age<= 15 then we have to cell color="yellow". If age>=15 then we have to set gridview cell color ="Red".to achieve this type of functionality we have to use RowDataBound event of the Gridview.

So to change the gridview row background dynamically based on some condition you have to write the below code.

Restrict the size of File when Uploaded How to Restrict the size of File when uploaded by user

Dynamically Read/Write File in asp.Net How to Read Write File in Asp.Net using C#

Use File Upload Control in Gridview in asp.Net

Description:-

In this example we explain that how to use fileupload control inside Gridview for uploading images or file to server. Or how to use fileupload control in gridview to upload image or file to server in asp.net.

In previous example we already explain that how to bind Dropdownlist inside gridview.

Here in this example we have one table called employee and have two field like empname and employee photo. In gridview footer row we are add one textbox footer for employee name and one file upload for employee photo and when click on submit button this footer rows data like employye name and employee photo are bind to the gridview.

Here we define RowDatabound event of the gridview so one by one row of the gridview is binded with empname and it's selected country and user can also change the employees country in the dropdownlist.

Dynamically Bind Data in Ajax Accordion Panel Bind Data to Accordion from databse

Restrict the size of File when Uploaded How to Restrict the size of File when uploaded by user

Find Nth Highest Salary of Employee from sql server

Description:-

in this example we explain that how to find nth highest salary of the employee in sql server table. This is the most important question that is asked by interviewer in any interview that is write query for find second second highest salary of employee in sql table or find third highest salary of employee in sql server table.

We all listen that How to find third highest or second maximum salary of an Employee is one of the most frequently asked question in interview.

insert,update,delete in gridview without Postback CRUD operation without Postback in asp.net

Dynamically Bind data in Ajax Accordion Panel Ajax Accordion panel Example in asp.net

use Ajax CalenderExtender Control inside gridview in asp.net

Description:-

in this example we explain that how to use Ajax CalenderExtender control inside Gridview in Asp.Net. Or how to use Ajax CalenderExtender control in gridview to add birthrate of the employee in database .

In previous example we already explain that how to bind Dropdownlist inside gridview.

Here in this example we have one table called employee and have two field like empname and employee birthdate. In gridview footer row we are add one textbox footer for employee name and one Ajax CalenderExtender control  for employee birthdate and when click on submit button this footer rows data like employye name and employee birthdate are bind to the gridview.

Dynamically Bind data in Ajax Accordion Panel Ajax Accordion panel Example in asp.net


how to Restrict the size of file upload when upload by user restrict the size of file upload control in asp.net

Display Gridview Row as coloumn in Asp.Net Gridview

In this example we explain that how to convert gridview colouns to row or convert gridview columns to gridview row in asp.net.

Sometime in project there are many clients that required the gridview data should be displayed in reverse format means gridview columns display as gridview row and gridview rows should be displayed as gridview columns.

Insert,Update,Delete in ModalPopup CRUD operation in ModalPopup

Read and Write in Text File in asp.Net Read and Write File in Asp.Net

Encrypt and Decrypt XML File using C# in asp.Net

Description:-

In this example we explain that how to encrypt and Decrypt XML file in asp.net with C#.in previous we already explain that how to Encrypt and Decrypt Password when user is register to website then it's password are sstored in sqlserver database in Encrypt format and when user is login to website then it will fetch the Encrypt password from the database and Decrypt it and match with user enter password.so this is simple thing but now in this example we will explain how to Encrypt and Decrypt whole XML file in asp.net.

The main advantages to Encrypt and Decrypt XML file is that even user can not seen data in XML file because data are stored in Encrypt format so it can not be raed by any user. When any operation is performed in XML file then it will first Decrypt XML file and then perform operation. So this is the best facility for any application for better security.

Bind data in Accordion Control from database bind Dynamic data in Accordion Control

inner zoom effect of image bind into gridview from database Display Inner zoom Effect of the image in Gridview

How to show gridview with header when there is no row or data in gridview

Description:-

In this example we explain that how to display header when Gridview is empty or show gridview with header when there is no row or data in gridview or display empty gridview with Header and there is no row in gridview or datatable.

This is the real requirement that I have faced that our client's requirement is that display the gridview header coloumn even if the gridview does not  contain any row or data. So to overcome this problem we first use the EmptyDataText proerty of the gridview but that simply display the message "No records found" if gridview has no row or data and it will not display the header of the gridview.

To Show Example of How to Upload File in MVC Application then click here upload Image and bind to Gridview in MVC

How to upload File and Fetch file from SqlServer and bind to Gridview fetch file from Sqlserver and bind to Gridview

Sending an E-Mail With Attachment in MVC with asp.Net

  In the previous Example we already  Explain How to Send mail in Asp.Net .but in this Example we can explain how to send  mail with Atteched file or file Attechment facility in email in mvc4.  we ca also Atteched the word file,Excel file,image File or any other type of File with an Email in asp.net with mvc.

in which Example you can send Email with an attechment using SMTP server. the System.Web.Mail Namespace Provide classes MailMessage are used for sending Email and Mailattechment class are used for manage the Attechment of the File.

we provide same facility as provided by Gmail you can easily upload any type of one or more file with mail and send to the other user in by using it's email id.

sorting data in gridview with up and down arrow sorting data with up and down arrow in gridview

Ajax Autocomplete Textbox search example autocomplete textbox search in asp.net

How to use Multiple Models in Single View in MVC

Description:-

In this example we explain that how to define two Model in a single razor view or how to handle two model for single razor view in mvc.

We all know that as a developer sometime we have required two models in single view in many situations. Suppose in a razor view we have define register form with many field like first name, last name etc... and also define model to validate all field like first name. last name and when user fill data and click on submit button then this record will be bind to web grid below the same razor view so here we required two model one model for validation and second model for web grid binding,editing,deleting and define property related used in web grid.

Sorting Row data in gridview Gridview Sorting 

How to handle Concurrency in Linq to Sql Concurrency Example

Auto Complete TextBox in MVC with Asp.Net

Description:-

In this example we explain that how to create auto complete textbox in mvc4 using jquery or how to create auto complete textbox facility same like Ajax auto complete textbox in asp.net with mvc.

Here we provide facility same like as we normally used in asp.net with Ajax. This is simple requirement that we have required in every web application so here explain how to provide auto complete textbox facility to user in mvc application.

This functionality work same like as Ajax if user enter any character in mvc country textbox then it's related country list are render in below the textbox as a box list type same we have already seen in asp.net with Ajax.

To show Example How to insert,update,delete in DataList control clikck here  CRUD operation in DataList 

 How to Bind Excelsheet Data to Gridview CRUD operation in Excelsheet Database

How to Display Layer on one Another in CSS Overlapping Layer in CSS

how to Maintain State of the Checkboxes during paging in Gridview in Asp.Net

Description:-

In this example we explain that how to maintain the state of the checkbox while paging in gridview or when any control is postback.

The real problem is that I want to delete the checked or selected rows in gridview.if I was select first three rows of the gridview's first page and then navigate to second gridview page and select first two row and then click on delete button then all selected or checked rows are deleted but that not happen only second page's selected rows are deleted because first page checked row's state does not maintain gridview because of postback. So in this type of situation we have to define another code as below.

I have faced real problem that I have one gridview with checkbox and paging and every griview pages display Five rows per page. Suppose I have select or checked first three rows in first gridview page using checkbox and now I was transfer to second gridview page and checked last two rows using checkbox then again if I was transfer to first gridview page then first three rows of the gridview must be checked. But that situation not happens because gridview cannot maintain the state if control is postback so due to this reason I was found a solution are below.

How to Send Forgot Password to user Email Send Forgot Password to user email

Rotate the Ads witout Refreshing the webpage Rotate the Advertisement in Asp.Net

Export Gridview Data to PDF file Export Grid data to PDF File

export Datagridview data to pdf in windows form application using c#

Description:-

In this example we explain that  how to export DataGridView data to PDF file in Windows Forms (WinForms) Applications using iTextSharp PDF conversion library usiong  C#.

DataGridView cannot provide facility to export Griddata directally to pdf and so that we have to use one .dll file and give reference to your project and use the functionality export to pdf in table format by using the iTextSharp.dll Table for this solution.

to show Example of how to Redirect to another aspx page in javascript click here Redirect to another aspx page in javascript

to show example of how to create timer or display clock in javascript click here create timer or display clock in javascript

paging in datagridview in windows form application using c#

Description:

            In this example we explain that how to create Paging in Datagrid view in window application using C# with Insert,Update,Delete in Data Grid View in C# window application. We already explain many example like Paging in gridview  in web application. But in this example we explain that in how to Paging with First,Next,Previous,Last button to navigate the record in Datagridview in window application using C#.

Here we create a Custom Paging in Datagridview because DataGrid view does not provide paging facility like we have use in Gridview in Asp.Net. so to create custom paging in datagridview follow the below code.

to Show Example Of How to Create Paging or Custom Paging in Reapeter so plz click Here Paging or Custom Paging in Reapeter Control

to Show Example of How to Create Insert,Update,Delete in Gridview plz Click Here CRUD operation in GridView

How to get Date Part only from DateTime in Sql Server

Description:-

        In this example we explain that how to get only Date excluding time from DateTime in sqlserver. Or how to getting only the Date part of the DateTime stamp in sqlserver.

We all faced this problem because we are the developer and many times we pass across this scenario where we only need to get Date part only from the DateTime or TimeStamp in sqlserver.the one and only most example that we all have requirement in any application is that the B.O.D (Birth date of the user) in each and every application so that we have only display the birthdate of the employee not the time.

To Show Example of How to Upload File in MVC Application then click here upload Image and bind to Gridview in MVC


How to upload File and Fetch file from SqlServer and bind to Gridview fetch file from Sqlserver and bind to Gridview

So here is a multiple way to fetch or get only Date part of the DateTime in sqlserver are listed below

Render Partial View with webgrid in Modal Popup in MVC4

Description:-

In this example I explain that how to render a partial view with webgrid in modal popup or load partial view with webgrid in modal popup using jquery in Asp .Net MVC. You can use this partial view in many forms as you wish. First we understand the actual use of partial view

What is Partial View:

If you want to reuse a razor view in your web application or project, then you can prefer the partial view concept. Partial view is same like a regular view with a file extension .cshtml. We can use partial views in a situation where we need a header, footer reused for an MVC web application. We can say that it's like a user control concept in ASP.NET.

In this example we render the webgrid in modal popup when user click on showlist button. Here partial view contain the webgrid with Field itemname and prize that we have to display in grid format in modal popup.

to show example of WCF service for insert,update,delete CRUD operation using WCF service

check the Extention of file when upload upload only image or word file

here is below step to how to render partial view with webgrid in dynamic modal popup.