转自他人,地址已忘
控件:
<input id="Chk_Con" checked="checked" οnclick="GetData(this)" type="checkbox" />
<div id="divTitle" style="overflow: hidden; width: 93.7%; border: 0px solid red;">
</div>
<div id="d">
<asp:GridView ID="GridView1" Width="100%" CssClass="GridViewStyle" AutoGenerateColumns="False"runat="server" ShowHeaderWhenEmpty="True">
<FooterStyle CssClass="GridViewFooterStyle" />
<RowStyle CssClass="GridViewRowStyle" />
<SelectedRowStyle CssClass="GridViewSelectedRowStyle" />
<PagerStyle CssClass="GridViewPagerStyle" />
<AlternatingRowStyle CssClass="GridViewAlternatingRowStyle" />
<HeaderStyle CssClass="GridViewHeaderStyle" />
<Columns>
<asp:BoundField HeaderText="Sorting" DataField="Sorting" SortExpression="Sorting" />
</Columns>
</asp:GridView>
<asp:Panel ID="Header" runat="server">
</asp:Panel>
</div>
前台代码:
function GetData(p) {
var ch = document.getElementById("Chk_Con").checked;
if (ch == false) {
ch = "1";
var tbl = document.getElementById("divTitle");
tbl.style.display = "none";
}
else {
ch = 2;
var tbl = document.getElementById("divTitle");
tbl.style.display = "none";
}
document.getElementById("d").innerHTML = "正在读取数据……";
h = window.XMLHttpRequest ? new window.XMLHttpRequest() : new ActiveXObject("MSXML2.XMLHTTP");
h.open("GET", '<%=Request.FilePath %>?id=' + ch, true);
h.onreadystatechange = function () {
if (h.readyState == 4) {
if (h.status >= 200 && h.status < 300) {
document.getElementById("d").innerHTML = h.responseText;
}
else {
document.getElementById("d").innerHTML = "<h2>数据操作错误:</h2>" + h.responseText;
}
}
}
h.send(null);
}
后台代码:
System.Data.DataView GENbind()
{
System.Data.DataTable dt = new System.Data.DataTable();
string str = "select * from **************";
DataSet ds = sqlconn.dsFill("***", str);
dt = ds.Tables[0];
System.Data.DataView dv = new System.Data.DataView(dt);
return dv;
}
System.Data.DataView Gbind()
{
System.Data.DataTable dt = new System.Data.DataTable();
string str = "select * from *********************";
DataSet ds = sqlconn.dsFill("***", str);
dt = ds.Tables[0];
System.Data.DataView dv = new System.Data.DataView(dt);
return dv;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
if (Request.QueryString["id"] == "1")
{
Response.ClearContent();
GridView1.DataSource = GENbind();
GridView1.DataBind();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Literal header = new Literal();
header.Text = "";
Header.Controls.Add(header);
Header.RenderControl(htw);
GridView1.RenderControl(htw);
Response.Write(sb.ToString());
Response.End();
}
else
{
GridView1.DataSource = "";
GridView1.DataBind();
Response.ClearContent();
GridView1.DataSource = Gbind();
GridView1.DataBind();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Literal header = new Literal();
header.Text = "";
Header.Controls.Add(header);
Header.RenderControl(htw);
GridView1.RenderControl(htw);
Response.Write(sb.ToString());
Response.End();
}
}
if (!IsPostBack)
{
}
}
public override void VerifyRenderingInServerForm(Control control)
{ }