sir from my code i got all of my datas from my xml database ..but i need to display oly the data with match of my date
for example if i i give date as 7/25/2013 the data within the date oly want to display in grid view my c# code is
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.IO;
public partial class grid1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindGrid();
}
}
protected void Download(object sender, EventArgs e)
{
string filePath = (sender as LinkButton).Text;
if (File.Exists(filePath))
{
string fileName = Path.GetFileName(filePath);
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
Response.Charset = "";
Response.ContentType = "application/vnd.ms-word ";
Response.WriteFile(filePath);
Response.Flush();
Response.End();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script type='text/javascript'>alert('file is not present');</script>");
}
}
protected void OnPageIndexChanging(object sender, GridViewPageEventArgs e)
{
this.gvCustomers.PageIndex = e.NewPageIndex;
this.BindGrid();
}
private void BindGrid()
{
using (DataSet ds = new DataSet())
{
ds.ReadXml(Server.MapPath("formxml.xml"));
this.gvCustomers.DataSource = ds;
this.gvCustomers.DataBind();
}
}
protected void gvCustomers_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
}
protected void gvCustomers_SelectedIndexChanged1(object sender, EventArgs e)
{
}
}
My xml data base is
<?xml version="1.0" encoding="utf-8"?>
<registeration>
<Date>
</Date>
<Name>
</Name>
<Qualification>
</Qualification>
<areaofinterest>
</areaofinterest>
<yearofexperience>
</yearofexperience>
<Mobile>
</Mobile>
<EmailID>
</EmailID>
<Address>
</Address>
<Country>
</Country>
<City>
</City>
<state>
</state>
<Resume>
</Resume>
<registeration>
<Date>7/25/2013</Date>
<Name>Rajesh</Name>
<Qualification>B.E(Electronics and Communication)</Qualification>
<areaofinterest>dotnet</areaofinterest>
<yearofexperience>1</yearofexperience>
<Mobile>9790408079</Mobile>
<EmailID>rkumar9090@hotmail.com</EmailID>
<Address>chennai
</Address>
<Country>india</Country>
<City>chennai</City>
<state>tn</state>
<Resume>C:\Documents and Settings\Sweet Pc\Desktop\WebSite12\uploadresume\Rajesh Resume (2).doc</Resume>
</registeration>
<registeration>
<Date>7/26/2013</Date>
<Name>Rajesh</Name>
<Qualification>B.E(Computer Science Engineering)</Qualification>
<areaofinterest>dfh</areaofinterest>
<yearofexperience>5</yearofexperience>
<Mobile>5467</Mobile>
<EmailID>dfh@g.c</EmailID>
<Address>drfg</Address>
<Country>reh</Country>
<City>erh</City>
<state>eh</state>
<Resume>C:\Documents and Settings\Sweet Pc\Desktop\WebSite12\uploadresume\cab31.cab</Resume>
</registeration>
<registeration>
<Date>7/26/2013</Date>
<Name>Rajesh</Name>
<Qualification>B.E(Computer Science Engineering)</Qualification>
<areaofinterest>dfh</areaofinterest>
<yearofexperience>5</yearofexperience>
<Mobile>5467</Mobile>
<EmailID>dfh@g.c</EmailID>
<Address>drfg</Address>
<Country>reh</Country>
<City>erh</City>
<state>eh</state>
<Resume>C:\Documents and Settings\Sweet Pc\Desktop\WebSite12\uploadresume\cab31.cab</Resume>
</registeration>
</registeration>
My design view code is
<%@ Page Language="C#" MasterPageFile="~/phoenix.master" AutoEventWireup="true" CodeFile="grid1.aspx.cs" Inherits="grid1" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" runat="server"
contentplaceholderid="ContentPlaceHolder4">
<div id="body">
<asp:TextBox ID="TextBox1" runat="server"
></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Search" />
<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false" OnPageIndexChanging="OnPageIndexChanging"
AllowPaging="true" PageSize="10" onselectedindexchanged="gvCustomers_SelectedIndexChanged1"
>
<Columns>
<asp:BoundField DataField="Date" HeaderText="Date" />
<asp:BoundField DataField="Name" HeaderText="Name" />
<asp:BoundField DataField="Qualification" HeaderText="Qualification" />
<asp:BoundField DataField="Areaofinterest" HeaderText="Areaofinterest" />
<asp:BoundField DataField="yearofexperience" HeaderText="yearofexperience" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" />
<asp:BoundField DataField="EmailID" HeaderText="EmailID" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="Country" HeaderText="Country" />
<asp:BoundField DataField="City" HeaderText="City" />
<asp:BoundField DataField="state" HeaderText="state" />
<asp:TemplateField HeaderText="Resume">
<ItemTemplate>
<asp:LinkButton ID="lnkResume" runat="server" Text='<%#Eval("Resume") %>' OnClick="Download"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</asp:Content>