Skip to main content

SelectMethod in ASP.NET 4.5 Model binding

New version of ASP.NET provides lots of way of binding data to the data controls like Grid View, Repeater etc. You can now bind this controls with strong type. I have earlier written a blog post about How we can use Model binding with ASP.NET 4.5 and Visual Studio 2012.

SelectMethod in ASP.NET 4.5:


In asp.net 4.5, It is also possible to bind controls with SelectMethod attribute. This method specify the data that you want to bind with data controls like grid view and repeater controls.

So what we are waiting for?? Let’s take an simple example. I have create a basic model class “Employee” like below.
public class Employee
{
    public int EmployeeId { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
}
This class contains three properties EmployeeId,FirstName and LastName. Now I have created one method to get a generic list of employee model like following.

public List<Employee> GetEmployees()
{
    List<Employee> employeeList = new List<Employee>();
    for (int i = 1; i <= 5; i++)
    {
        employeeList.Add(new Employee { 
            EmployeeId=i,
            FirstName=string.Format("First{0}",i),
            LastName=string.Format("Last{0}",i)
        });
    }
    return employeeList;
}
Here you can see it will list of five employee. For this example I have created the employee list but you can replace with your database model.

Now it’s time to use “SelectMethod” attribute like following.
<asp:GridView ID="grdEmployee" runat="server" SelectMethod="GetEmployees"
     ItemType="WebApplication2.Employee">
</asp:GridView>

Here, you can see that I putted GetEmployee method as SelectMethod attribute and ItemType  attribute is my model Employee. Let’s run that example. Below is the out put as expected.

SelectMethod

SelectMethod filtering:


You can also do the filtering with the Select Method very easily. Here to demonstrate the filtering let’s take a dropdown list  control like following and based on the dropdown list control selected item we will filter our grid view with select method. Following is a HTML code for this.

<form id="form1" runat="server">
<div>
    <asp:DropDownList ID="ddlEmployee" AutoPostBack="true" runat="server">
            <asp:ListItem Text="1"></asp:ListItem>
            <asp:ListItem Text="2"></asp:ListItem>
    </asp:DropDownList>
</div>
<div>
    <asp:GridView ID="grdEmployee" runat="server" SelectMethod="GetEmployees" ItemType="WebApplication2.Employee">
    </asp:GridView>
</div>
</form>

Now let’s modify our GetEmployees method like following to filter based on dropdownlist control.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.ModelBinding;

namespace WebApplication2
{
    public partial class WebForm1 : System.Web.UI.Page
    {

        public List<Employee> GetEmployees([Control]int? ddlEmployee)
        {
            List<Employee> employeeList = new List<Employee>();
            for (int i = 1; i <= 5; i++)
            {
                employeeList.Add(new Employee { 
                    EmployeeId=i,
                    FirstName=string.Format("First{0}",i),
                    LastName=string.Format("Last{0}",i)
                });
            }
            return employeeList.Where(e=>e.EmployeeId==ddlEmployee).ToList();
        }
    }
}

Here you can see that I have added parameter with ddlEmployee with INT Type.  And also if you see I have used  System.Web.ModelBinding namespace to use that parameter as control attribute. This does all the trick and it will filter based on the dropdownlist selection.

Now let’s run the example again.

Select method filtering in asp.net 4.5 Model binding

Same way if you select “2” it will have output as following.

Select method filtering in asp.net 4.5 Model binding

So, Here you can see we can easily create a filtering with ‘Select Method’ also. it’s very easy to use. Hope you like it. Stay tuned for more..

Comments

Post a Comment

Your feedback is very important to me. Please provide your feedback via putting comments.

Popular posts from this blog

How to create Rest API(Web API) with ASP.NET Core 1.0

Recently Microsoft has released ASP.NET Core 1.0 RC2, I am getting lots of request from readers that about creating Web API. So I thought it will be a good idea to write a blog post about how to create Rest API(Web API) with ASP.NET Core 1.0.

So let’s get started via creating an ASP.NET Core 1.0 Web Application like following.



Once you click on ASP.NET Web Application, It will ask whether you need to create Web Application or Web API application. We are going to Web API so I am going to select Web API Application like following. Please note that in ASP.NET Core 1.0 there is no separate libraries or DLLs required for creating web APIs. This is just a project template.



Now once you click on OK It will create a Web API application with default values controller and program.cs.  As you know Program.cs is now starting point for the ASP.NET Core 1.0 application so It contains all the required configuration and startup items. Following is a code for that.
using System.IO; using Microsoft.Asp…

How to use migration with Entity Framework Core

Entity framework core is  the lightweight, extensible and cross-platform version of Entity Framework. Before some time, Microsoft has Released a new version of Entity Framework RC2. I have written a couple of blog post about Entity framework code first migration earlier for Entity framework 6.0. So there was a couple of request coming for writing a blog post about Entity Framework Core RC2 migration. So I thought it will be a good idea to give an overview how database migration works in Entity Framework Core RC2. This post will cover a basic scenario where we are going to create the database with existing ASP.NET Identity migration and then we are going to create a new model and have that migration applied in the database.

How to use Entity Framework Migrations: Let’s get started, To demonstrate entity framework core migrations, I am going to create a sample asp.net core web application like following.



Once we select asp.net core application it will appear the following dialog.



Now w…

Solution: gulp is not recognized as internal or external command- Visual Studio

Recently, After Upgrading to the newer version of Gulp, I was getting this error.  After doing lots of  finding online and in my system I was able to figure out that Modules like Gulp does not installed to the path. So when you try to run it from the command line it was showing below error.
gulp is not recognized as internal or external command How to solve : gulp is not recognized as internal or external command To solve this error we just need to create a new environment variable and set the NPM modules path there.

To create an environment variable,  Right click My Computer/ This Pc and click on properties.  It will open following windows.



Go to Advance System Settings and it will open system properties windows like below.



Click on Environment Variables it will open an environment and system variables windows like below.



Click on new System variable and put NODE_PATH in system variable name and %AppData%\npm\node_modules into the variable value like below.



Click on Ok. That’s it. N…