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>
![gridview.gif]()
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>
![gridview1.gif]()
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();
}
}
}