how to find results by click on dropdownlist selected value into a grid view? ~ C# Jadu

Hi Friends...

Here I explain full procedure step by step

Step 1: create a connection string in web.config page

Step 2: create database

create a table UserDetail

set primary key column ID and auto increment by +1 using sql properties

Step 3: HTML Design code goes here

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="droplist.aspx.cs" Inherits="droplist" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div style="border: solid 2px #800000; width: 300px; height: auto; margin-left: 500px;

margin-top: 100px; padding: 25px;">

<div>

<b style="color: #800000">Select Data From DataList

<br />

</b>

<br />

<asp:DropDownList ID="ddlSelectData" runat="server" OnSelectedIndexChanged="ddlSelectData_SelectedIndexChanged"

BackColor="#993333" ForeColor="White" Height="29px" Width="101px">

</asp:DropDownList>

<asp:Label ID="lblFindResult" runat="server" Text="Label" Visible="false"></asp:Label>

<br />

<asp:Button ID="btnFindResult" runat="server" Text=" Find Result" OnClick="btnFindResult_Click"

Style="height: 26px" BackColor="#993333" ForeColor="White" />

<br />

<asp:GridView ID="gvResult" runat="server" BackColor="White" BorderColor="#CC9966"

BorderStyle="None" BorderWidth="1px" CellPadding="4" Height="16px" Width="278px">

<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />

<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />

<RowStyle BackColor="White" ForeColor="#330099" />

<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />

<SortedAscendingCellStyle BackColor="#FEFCEB" />

<SortedAscendingHeaderStyle BackColor="#AF0101" />

<SortedDescendingCellStyle BackColor="#F6F0C0" />

<SortedDescendingHeaderStyle BackColor="#7E0000" />

</asp:GridView>

</div>

</form>

</body>

</html>

Step 4: Add some header files

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

Step 5: c# page code goes here

public partial class droplist : System.Web.UI.Page
{

    string str = "Data Source=DcPc;uid=sa;pwd=12345;database=droplist";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection con = new SqlConnection(str);

            string com = "Select * from UserDetail";

            SqlDataAdapter adpt = new SqlDataAdapter(com, con);

            DataTable dt = new DataTable();

            adpt.Fill(dt);

            ddlSelectData.DataSource = dt;

            ddlSelectData.DataBind();

            ddlSelectData.DataTextField = "Name";

            ddlSelectData.DataValueField = "ID";

            ddlSelectData.DataBind();

        }
    }

    protected void btnFindResult_Click(object sender, EventArgs e)
    {

        SqlConnection con = new SqlConnection(str);

        SqlCommand cmd = new SqlCommand("select * from UserDetail where id = '" + ddlSelectData.SelectedValue + "'", con);

        SqlDataAdapter Adpt = new SqlDataAdapter(cmd);

        DataTable dt = new DataTable();

        Adpt.Fill(dt);

        gvResult.DataSource = dt;

        gvResult.DataBind();

        lblFindResult.Visible = true;

        lblFindResult.Text = "record found";

    }

    protected void ddlSelectData_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}

Demo :

Tuesday, 22 September 2015

Hi Friends...

Step 1: create a connection string in web.config page

Step 2: create database

create a table UserDetail

Step 3: HTML Design code goes here

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="droplist.aspx.cs" Inherits="droplist" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div style="border: solid 2px #800000; width: 300px; height: auto; margin-left: 500px;

margin-top: 100px; padding: 25px;">

<div>

<b style="color: #800000">Select Data From DataList

<br />

</b>

<br />

<asp:DropDownList ID="ddlSelectData" runat="server" OnSelectedIndexChanged="ddlSelectData_SelectedIndexChanged"

BackColor="#993333" ForeColor="White" Height="29px" Width="101px">

</asp:DropDownList>

<asp:Label ID="lblFindResult" runat="server" Text="Label" Visible="false"></asp:Label>

<br />

<br />

<asp:Button ID="btnFindResult" runat="server" Text=" Find Result" OnClick="btnFindResult_Click"

Style="height: 26px" BackColor="#993333" ForeColor="White" />

<br />

<br />

<asp:GridView ID="gvResult" runat="server" BackColor="White" BorderColor="#CC9966"

BorderStyle="None" BorderWidth="1px" CellPadding="4" Height="16px" Width="278px">

<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />

<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />

<RowStyle BackColor="White" ForeColor="#330099" />

<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />

<SortedAscendingCellStyle BackColor="#FEFCEB" />

<SortedAscendingHeaderStyle BackColor="#AF0101" />

<SortedDescendingCellStyle BackColor="#F6F0C0" />

<SortedDescendingHeaderStyle BackColor="#7E0000" />

</asp:GridView>

</div>

</div>

</form>

</body>

</html>

Step 4: Add some header files

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data;

Step 5: c# page code goes here

Demo :

2 comments:

Most Popular posts

About Me

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;