Here I am designing asp.net page and define javascript for paging in a Gridview and joining query for multiple table in database and Export Record of Gridview record ....
Default.aspx
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Default.aspx.cs"
Inherits="_Default"
%>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
<style
type="text/css">
.style1
{
color:
#000000;
font-size:
large;
}
.style2
{
color:
#000000;
}
.style3
{
text-decoration:
underline;
}
.style4
{
color:
#000000;
font-family:
"Book Antiqua";
}
</style>
<script
language="javascript"
type="text/javascript">
function
pankaj() {
if
(document.getElementById("<%=TextBox1.ClientID %>").value
== ""){
alert("Please
Enter Employee Date");
document.getElementById("<%=TextBox1.ClientID
%>").focus();
return
false;
}
}
</script>
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<div class="style1">
<span class="style3">Employee Search
</span> </div>
<div align="center">
<span
class="style2">Enter
Employee Date </span>
<asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox>
<asp:Button ID="Button1"
runat="server"
onclick="Button1_Click"
Text="Search Date" BorderStyle="None" OnClientClick="return pankaj()" />
</div>
<br
/>
<asp:GridView ID="GridView1"
runat="server"
Width="912px"
ForeColor="Black" PageSize="2"
onpageindexchanging="GridView1_PageIndexChanging" AllowPaging="True">
<HeaderStyle BackColor="#0099FF" ForeColor="White" Wrap="False" />
<PagerStyle Wrap="False" />
</asp:GridView>
<div
align="right"><span class="style4">Export Record in Word</span><asp:ImageButton
ID="btnExcel" runat="server" ImageUrl="~/WordImage.jpg"
onclick="btnExcel_Click" /></div>
<div align="right"><span
class="style4">Export
Record in Word</span><asp:ImageButton
ID="ImageButton1" runat="server" ImageUrl="~/ExcelImage.jpg"
onclick="ImageButton1_Click" /></div>
</asp:Content>
Here coding page load and click event of .cs page ..
Here coding page load and click event of .cs page ..
Default.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Drawing;
using System.Web.Security;
using System.Text;
using System.Drawing;
using System.IO;
public partial
class _Default
: System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("Give Database string");
protected void
Page_Load(object sender, EventArgs e)
{
SqlConnection
conn = new SqlConnection("Give Database string");
conn.Open();
SqlDataAdapter
da = new SqlDataAdapter("select DR1.Date1,
DR1.Emp_ID, DR1.First_Name, DR1.Last_Name, DR2.Task_id,
DR2.Description,DR2.Status,DR2.Time_Hours,DR2.Time_Minutes,DR2.Total_Time,DR2.Time_Duration
from DR1 inner join DR2 ON
DR1.Date1=DR2.Date1", conn);
DataSet
ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void
GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
SqlDataAdapter adapter;
protected void
Button1_Click(object sender, EventArgs e)
{
conn = new
SqlConnection("Give
Database string");
conn.Open();
SqlDataAdapter
da = new SqlDataAdapter("select DR1.Date1,
DR1.Emp_ID, DR1.First_Name, DR1.Last_Name, DR2.Task_id,
DR2.Description,DR2.Status,DR2.Time_Hours,DR2.Time_Minutes,DR2.Total_Time,DR2.Time_Duration
from DR1 inner join DR2 ON
DR1.Date1=DR2.Date1 WHERE DR1.Date1 LIKE
'%" + TextBox1.Text + "%' OR
DR2.Date1 LIKE '%" + TextBox1.Text + "%'",
conn);
DataSet
ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
public override
void VerifyRenderingInServerForm(Control control)
{
}
protected void
btnExcel_Click(object sender, ImageClickEventArgs e)
{
GridView1.AllowPaging = false;
GridView1.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", string.Format("attachment;
filename={0}", "Customers.doc"));
Response.Charset = "";
Response.ContentType = "application/ms-word";
StringWriter
sw = new StringWriter();
HtmlTextWriter
htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
protected void
ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment;
filename={0}", "Customers.xls"));
Response.ContentType = "application/ms-excel";
StringWriter
sw = new StringWriter();
HtmlTextWriter
htw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
for (int i = 0; i < GridView1.HeaderRow.Cells.Count;
i++)
{
GridView1.HeaderRow.Cells[i].Style.Add("background-color",
"#507CD1");
}
int j
= 1;
foreach
(GridViewRow gvrow in
GridView1.Rows)
{
gvrow.BackColor = Color.White;
if (j
<= GridView1.Rows.Count)
{
if (j %
2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
}
