This is a simple task for searching grid view
and views the details of in grid view data in popup window (new browser).
Search.aspx (.aspx)
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Search.aspx.cs" Inherits="Search" %>
<!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 runat="server">
<title>Untitled
Page</title>
<style type="text/css">
.form
{
background-color:
skyblue;
}
.div
{
right: 302px;
left: 300px;
height:
112px;
}
.div1
{
right: 302px;
left: 10px;
height:
112px;
}
</style>
</head>
<body class="form">
<form id="form1" runat="server">
<div class="div" style="position:
absolute; top:
42px;">
<table>
<tr>
<td align="center">
<b>Know
Your Application Status </b>
</td>
</tr>
<tr>
<td>
<asp:Panel ID="Panel1" runat="server">
<asp:RadioButtonList ID="RadioButtonList1" runat="server"
RepeatDirection="Horizontal" Width="372px">
<asp:ListItem Value="Id" Selected="True">Application
ID</asp:ListItem>
<asp:ListItem Value="Name">Applicant
Name</asp:ListItem>
<asp:ListItem Value="No">House
Number</asp:ListItem>
</asp:RadioButtonList>
</asp:Panel>
</td>
</tr>
<tr>
<td align="center">
<asp:TextBox ID="txtSearchContect" runat="server" Width="197px"></asp:TextBox>
</td>
</tr>
<tr>
<td align="center">
<asp:Button ID="btnsearch" runat="server" Text="Search" OnClick="btnsearch_Click" />
</td>
</tr>
</table>
</div>
<div class="div1" style="position:
absolute; top:
200px;">
<table>
<tr>
<td align="left">
<asp:GridView ID="gvappdetails" AutoGenerateColumns="False" runat="server" Style="margin-left:
0px"
Width="916px" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px"
CellPadding="4" GridLines="Horizontal">
<RowStyle BackColor="White" ForeColor="#333333" />
<Columns>
<asp:BoundField HeaderText="APP ID" DataField="APPID" />
<asp:BoundField HeaderText="NAME" DataField="NAME" />
<asp:BoundField HeaderText="RELATION
NAME" DataField="RELATIONNAME" />
<asp:BoundField HeaderText="AGE" DataField="AGE" />
<asp:BoundField HeaderText="HOUSE NO" DataField="HOUSENO" />
<%--<asp:BoundField
HeaderText="AC NUMBER" DataField="[ACNUMBER&NAME]" />--%>
<asp:BoundField HeaderText="PART NO" DataField="PARTNO" />
<asp:TemplateField HeaderText="View
Status?">
<ItemTemplate>
<a href="javascript:window.open('Searchdetails.aspx?AppId=<%#
Eval("APPID") %>','NewPage','width=400,height=500');">
View Status</a>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="White" ForeColor="#333333" />
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Code Behind File (.aspx.cs)
using
System.Data;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Xml.Linq;
using
System.Data.SqlClient;
public partial class Search : System.Web.UI.Page
{
SqlConnection con =
new SqlConnection("Data
Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and
Settings\\Administrator\\My
Documents\\Visual Studio 2008\\WebSites\\WebSite2\\App_Data\\Database.mdf;Integrated
Security=True;User Instance=True");
public void
fillgrid()
{
SqlCommand cmd =
new SqlCommand("select
APPID,NAME,RELATIONNAME,AGE,HOUSENO,PARTNO from APPLICANTDETAILS", con);
DataSet ds =
new DataSet();
con.Open();
SqlDataAdapter dap =
new SqlDataAdapter(cmd);
dap.Fill(ds, "APPLICANTDETAILS");
gvappdetails.DataSource = ds.Tables[0].DefaultView;
gvappdetails.DataBind();
}
protected void
Page_Load(object sender,
EventArgs e)
{
//fillgrid();
}
protected void
btnsearch_Click(object sender,
EventArgs e)
{
switch
(RadioButtonList1.SelectedItem.Value)
{
case
"Name":
SqlCommand cmd =
new SqlCommand("select
APPID,NAME,RELATIONNAME,AGE,HOUSENO,PARTNO from APPLICANTDETAILS where Name='"
+ txtSearchContect.Text + "'", con);
DataSet ds =
new DataSet();
con.Open();
SqlDataAdapter dap =
new SqlDataAdapter(cmd);
dap.Fill(ds, "APPLICANTDETAILS");
gvappdetails.DataSource = ds.Tables[0].DefaultView;
gvappdetails.DataBind();
break;
case
"No":
SqlCommand cmd1 =
new SqlCommand("select
APPID,NAME,RELATIONNAME,AGE,HOUSENO,PARTNO from APPLICANTDETAILS where
HOUSENO='" + txtSearchContect.Text + "'",
con);
DataSet ds1 =
new DataSet();
con.Open();
SqlDataAdapter dap1 =
new SqlDataAdapter(cmd1);
dap1.Fill(ds1, "APPLICANTDETAILS");
gvappdetails.DataSource = ds1.Tables[0].DefaultView;
gvappdetails.DataBind();
break;
default:
SqlCommand cmd2 =
new SqlCommand("select
APPID,NAME,RELATIONNAME,AGE,HOUSENO,PARTNO from APPLICANTDETAILS where
APPID='" + txtSearchContect.Text + "'",
con);
DataSet ds2 =
new DataSet();
con.Open();
SqlDataAdapter dap2 =
new SqlDataAdapter(cmd2);
dap2.Fill(ds2, "APPLICANTDETAILS");
gvappdetails.DataSource = ds2.Tables[0].DefaultView;
gvappdetails.DataBind();
break;
}
}
}
SearchDetails.aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Searchdetails.aspx.cs" Inherits="Searchdetails" %>
<!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 runat="server">
<title>Untitled
Page</title>
<style type="text/css">
.span
{
right: 302px;
left: 300px;
height:
112px;
}
.body
{
background-color:
skyblue;
}
.td{}
</style>
</head>
<body class="body">
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" ForeColor="Red" Text="E - REGISTRATION
USER STATUS"></asp:Label>
<br />
<table>
<tr>
<td>
APPLICATION ID
</td>
<td>
<asp:Label ID="lblappid" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
NAME
</td>
<td>
<asp:Label ID="lblname" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
RELATION NAME
</td>
<td>
<asp:Label ID="lblrelationname" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
AGE
</td>
<td>
<asp:Label ID="lblage" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
HOUSE NO
</td>
<td>
<asp:Label ID="lblhno" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
PART NUMBER
</td>
<td>
<asp:Label ID="lblpartno" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
Application Date
</td>
<td>
<asp:Label ID="lblapplicationdate" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
STATUS
</td>
<td>
<asp:Label ID="lblstatus" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td>
REMARKS
</td>
<td>
<asp:Label ID="lblremarks" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr>
<td align="right">
<asp:Button ID="btnprint" runat="server" Text="Print" />
</td>
<td>
<asp:Button ID="btnexit" runat="server" Text="Exit" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Code Behind file (SearchDetails.aspx.cs)
public partial class Searchdetails : System.Web.UI.Page
{
SqlConnection con =
new SqlConnection("Data
Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and
Settings\\Administrator\\My
Documents\\Visual Studio 2008\\WebSites\\WebSite2\\App_Data\\Database.mdf;Integrated
Security=True;User Instance=True");
protected void
Page_Load(object sender,
EventArgs e)
{
string sql =
"select * from APPLICANTDETAILS where APPID='" + Request.QueryString["AppId"]
+ "'";
SqlCommand cmd =
new SqlCommand(sql,
con);
con.Open();
SqlDataReader Dr = cmd.ExecuteReader();
if (Dr.Read() ==
true)
{
lblappid.Text = Dr[0].ToString();
lblname.Text = Dr[1].ToString();
lblrelationname.Text = Dr[2].ToString();
lblage.Text = Dr[3].ToString();
lblhno.Text = Dr[4].ToString();
lblpartno.Text = Dr[6].ToString();
lblapplicationdate.Text = Dr[7].ToString();
lblstatus.Text = Dr[8].ToString();
lblremarks.Text = Dr[9].ToString();
}
}
}