Data Binding ASP.Net

  1. Home
  2. ASP.Net
  3. Data Binding
  4. GridView with Template and backend code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="GridViewTemplates2" %>



    Untitled Page


    
    

                                   runat="server" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>"
                           ProviderName="System.Data.SqlClient" 
                           SelectCommand="SELECT ProductID, ProductName, UnitPrice, UnitsInStock FROM Products">
        
                              runat="server" 
                      AutoGenerateColumns="False" 
                      CellPadding="4"
                      DataKeyNames="ProductID" 
                      DataSourceID="sourceProducts" 
                      Font-Names="Verdana" 
                      Font-Size="Small" 
                      ForeColor="#333333" 
                      GridLines="None" 
                      AllowPaging="True" 
                      OnRowCommand="GridView1_RowCommand">
            
            
            
            
            
            
            
                
                
                                                         ImageUrl='<%# GetStatusPicture(Container.DataItem) %>'
                                     CommandName="StatusClick"
                                     CommandArgument='<%# Eval("ProductID") %>'
                      />
                
                                                HeaderText="ID" 
                                InsertVisible="False" 
                                ReadOnly="True"
                                SortExpression="ProductID" />
                                                HeaderText="Product" 
                                SortExpression="ProductName" />
                                                DataFormatString="{0:C}" 
                                HeaderText="Price"
                                SortExpression="UnitPrice" />
                                                HeaderText="UnitsInStock" 
                                SortExpression="Units In Stock" />
            
        
        
        
    
    

    


File: Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class GridViewTemplates2 : System.Web.UI.Page
{
  protected string GetStatusPicture(object dataItem)
  {
    int units = Int32.Parse(DataBinder.Eval(dataItem, "UnitsInStock").ToString());
    if (units == 0)
    {
      return "0.gif";
    }
    else if (units > 50)
    {
      return "50.gif";
    }
    else
    {
      return "blank.gif";
    }
  }
  protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
  {
    if (e.CommandName == "StatusClick")
      lblInfo.Text = "You clicked product #" + e.CommandArgument;
  }
}
File: Web.config