Follow Some step for making that tast task.
Step 1-: Create Database and table.
Step 2-: Design part
Step 3-: Coding part.
Step 4-: Debug
Step 1-: Create Database and table.
Step 2-: Design part
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="How-to-show-data-in-grid-and-Bind-dropdownlist-in-aspdotnet.aspx.cs" Inherits="Demo_How_to_show_data_in_grid_and_Bind_dropdownlist_in_aspdotnet" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns = "False"
AllowPaging = "True" Font-Names = "Arial"
Font-Size = "11pt" AlternatingRowStyle-BackColor = "#C2D69B"
HeaderStyle-BackColor = "green" OnPageIndexChanging = "OnPaging" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" EnableModelValidation="True" GridLines="Vertical">
<AlternatingRowStyle BackColor="#DCDCDC"></AlternatingRowStyle>
<Columns>
<asp:BoundField DataField="Email" HeaderText="Email" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:TemplateField>
<HeaderTemplate>
UserName:
<asp:DropDownList ID="ddlUserName" runat="server"
OnSelectedIndexChanged = "UserNameChanged" AutoPostBack = "true"
AppendDataBoundItems = "true">
<asp:ListItem Text = "ALL" Value = "ALL"></asp:ListItem>
<asp:ListItem Text = "Top 10" Value = "10"></asp:ListItem>
</asp:DropDownList>
</HeaderTemplate>
<ItemTemplate>
<%# Eval("UserName") %>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="MobileNo" HeaderText="MobileNo" />
<asp:BoundField DataField="DateOfBirth" HeaderText="DateOfBirth" />
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White"></HeaderStyle>
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
</asp:GridView>
</div>
</form>
</body>
</html>
Step 3-: Coding part.
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Demo_How_to_show_data_in_grid_and_Bind_dropdownlist_in_aspdotnet : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["Filter"] = "ALL";
ShowInGrid();
}
}
private void ShowInGrid()
{
DataTable dt = new DataTable();
String strConnString = System.Configuration.ConfigurationManager
.ConnectionStrings["DatabaseDDNConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlDataAdapter sda = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("Demo_GetUserbyFilter");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Filter", ViewState["Filter"].ToString());
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
DropDownList ddlUserName =
(DropDownList)GridView1.HeaderRow.FindControl("ddlUserName");
this.ShowListbyUserName(ddlUserName);
}
private void ShowListbyUserName(DropDownList ddlUserName)
{
String strConnString = System.Configuration.ConfigurationManager
.ConnectionStrings["DatabaseDDNConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlDataAdapter sda = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("select distinct UserName" +
" from Demo_User");
cmd.Connection = con;
con.Open();
ddlUserName.DataSource = cmd.ExecuteReader();
ddlUserName.DataTextField = "UserName";
ddlUserName.DataValueField = "UserName";
ddlUserName.DataBind();
con.Close();
ddlUserName.Items.FindByValue(ViewState["Filter"].ToString())
.Selected = true;
}
protected void UserNameChanged(object sender, EventArgs e)
{
DropDownList ddlUserName = (DropDownList)sender;
ViewState["Filter"] = ddlUserName.SelectedValue;
this.ShowInGrid();
}
protected void OnPaging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
this.ShowInGrid();
}
}Step 4-: Debug
No comments:
Post a Comment