here is the code
search.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="search.aspx.cs" Inherits="search" EnableEventValidation="false" %>
<!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>Grdview with Arraylist</title>
<style type="text/css">
.Gridview
{
font-family:Verdana;
font-size:10pt;
font-weight:normal;
color:black;
width:300px;
}
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvdata" runat="server" CssClass="Gridview"
AutoGenerateColumns="False" HeaderStyle-BackColor="#7779AF"
HeaderStyle-ForeColor="White">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID"/>
<asp:BoundField DataField ="Name" HeaderText="Name" />
</Columns>
<HeaderStyle BackColor="#7779AF" ForeColor="White"></HeaderStyle>
</asp:GridView>
<table class="style1">
<tr>
<td>
</td>
<td>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Search" />
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:ImageButton ID="btnExcel" runat="server" ImageUrl="~/2.jpg"
onclick="btnExcel_Click" /> </td>
</tr>
<tr>
<td>
</td>
<td>
<asp:GridView ID="gvdata0" runat="server" CssClass="Gridview" AutoGenerateColumns="False"
HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="White">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID"/>
<asp:BoundField DataField ="EmpName" HeaderText="EmpName" />
</Columns>
<HeaderStyle BackColor="#7779AF" ForeColor="White"></HeaderStyle>
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
here is the code file
search.aspx.cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;
using System.Drawing;
public partial class search : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}
protected void Button1_Click(object sender, EventArgs e)
{
BindGridviewData();
BindGridviewData1();
}
protected void BindGridviewData()
{
SqlConnection con = new SqlConnection(Connect.cnst);
con.Open();
SqlCommand cmd = new SqlCommand("select [ID],[Name] from exm where ID = '" + TextBox1.Text + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvdata.DataSource = ds;
gvdata.DataBind();
int columncount = gvdata.Rows[0].Cells.Count;
gvdata.Rows[0].Cells.Clear();
gvdata.Rows[0].Cells.Add(new TableCell());
gvdata.Rows[0].Cells[0].ColumnSpan = columncount;
gvdata.Rows[0].Cells[0].Text = "No Records Found";
}
else
{
gvdata.DataSource = ds;
gvdata.DataBind();
}
con.Close();
}
protected void BindGridviewData1()
{
SqlConnection con = new SqlConnection(Connect.cnst);
con.Open();
SqlCommand cmd = new SqlCommand("select [ID],[EmpName] from tblLogin where ID = '" + TextBox1.Text + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvdata0.DataSource = ds;
gvdata0.DataBind();
int columncount = gvdata.Rows[0].Cells.Count;
gvdata0.Rows[0].Cells.Clear();
gvdata0.Rows[0].Cells.Add(new TableCell());
gvdata0.Rows[0].Cells[0].ColumnSpan = columncount;
gvdata0.Rows[0].Cells[0].Text = "No Records Found";
}
else
{
gvdata0.DataSource = ds;
gvdata0.DataBind();
}
con.Close();
}
protected void btnExcel_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
Response.Charset = "";
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvdata.AllowPaging = false;
this.BindGridviewData();
this.BindGridviewData1();
gvdata.DataBind();
gvdata0.DataBind();
//Change the Header Row back to white color
gvdata.HeaderRow.Style.Add("background-color", "#FFFFFF");
gvdata0.HeaderRow.Style.Add("background-color", "#FFFFFF");
//Applying stlye to gridview header cells
for (int i = 0; i < gvdata.HeaderRow.Cells.Count; i++)
{
gvdata.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
}
for (int i = 0; i < gvdata0.HeaderRow.Cells.Count; i++)
{
gvdata0.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
}
int j = 1;
//This loop is used to apply stlye to cells based on particular row
foreach (GridViewRow gvrow in gvdata.Rows)
{
gvrow.BackColor = Color.White;
if (j <= gvdata.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
foreach (GridViewRow gvrow in gvdata0.Rows)
{
gvrow.BackColor = Color.White;
if (j <= gvdata0.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
gvdata.RenderControl(htw);
gvdata0.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
}
output
0 comments:
Post a Comment