Ajax 实现DataGrid邦定
1. 在引用中添加引用Ajax.dll
2.在web.config中建立HttpHandler(这个当然是在system.web串里的)
<httpHandlers>
<add verb="POST,GET" path="ajax/*.ashx" type="Ajax.PageHandlerFactory, Ajax" />
</httpHandlers>
<add verb="POST,GET" path="ajax/*.ashx" type="Ajax.PageHandlerFactory, Ajax" />
</httpHandlers>
3.在Global的Application_Start里加上个设置
protected void Application_Start(Object sender, EventArgs e)
{
Ajax.Utility.HandlerPath = "ajax";
}
{
Ajax.Utility.HandlerPath = "ajax";
}
4.新建一个类DemoMethods,这个类里面提供了更新数据库和输出列表的方法。其实主要思想就是获得控件运行后生成的html,然后输出
[Ajax.AjaxMethod]
public int AddAjaxTable(string name)
{
//输入一个字符串,然后更新
SqlConnection conn = new SqlConnection( System.Configuration.ConfigurationSettings.AppSettings["connectionString"] );
SqlCommand cmd = new SqlCommand("insert into ajaxTable(name) values(’"+name+"’)", conn);
cmd.Connection.Open();
int result = cmd.ExecuteNonQuery();
conn.Dispose();
cmd.Dispose();
return result;
}
[Ajax.AjaxMethod]
public string GetAjaxTable()
{
//这个方法就是拿到datagrid生成出来的html
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand cmd = new SqlCommand("select * from ajaxTable order by id", conn);
SqlDataAdapter ap = new SqlDataAdapter( cmd );
DataSet ds = new DataSet();
ap.SelectCommand.Connection.Open();
ap.Fill( ds, "db" );
conn.Dispose();
cmd.Dispose();
//实例化一个datagird类并设置好数据源
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables["db"];1
public int AddAjaxTable(string name)
{
//输入一个字符串,然后更新
SqlConnection conn = new SqlConnection( System.Configuration.ConfigurationSettings.AppSettings["connectionString"] );
SqlCommand cmd = new SqlCommand("insert into ajaxTable(name) values(’"+name+"’)", conn);
cmd.Connection.Open();
int result = cmd.ExecuteNonQuery();
conn.Dispose();
cmd.Dispose();
return result;
}
[Ajax.AjaxMethod]
public string GetAjaxTable()
{
//这个方法就是拿到datagrid生成出来的html
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand cmd = new SqlCommand("select * from ajaxTable order by id", conn);
SqlDataAdapter ap = new SqlDataAdapter( cmd );
DataSet ds = new DataSet();
ap.SelectCommand.Connection.Open();
ap.Fill( ds, "db" );
conn.Dispose();
cmd.Dispose();
//实例化一个datagird类并设置好数据源
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables["db"];1
dg.DataBind();
//实例化一个HtmlTextWriter的类
System.Text.StringBuilder strb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter( strb );
System.Web.UI.HtmlTextWriter htw = new HtmlTextWriter( sw );
//执行控件的render并输出到HtmlTextWriter里
dg.RenderControl( htw );
string s = strb.ToString();
return s;//最后就是返回这个html啦
}
//实例化一个HtmlTextWriter的类
System.Text.StringBuilder strb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter( strb );
System.Web.UI.HtmlTextWriter htw = new HtmlTextWriter( sw );
//执行控件的render并输出到HtmlTextWriter里
dg.RenderControl( htw );
string s = strb.ToString();
return s;//最后就是返回这个html啦
}
5.然后再建一个default.js文件,用作存放 js方法
function AddAjax(name)
{
DemoMethods.AddAjaxTable(name);
LoadGrid();
}
{
DemoMethods.AddAjaxTable(name);
LoadGrid();
}
function LoadGrid()
{
var cc=document.getElementById("UCtd");
cc.innerHTML=DemoMethods.GetAjaxTable().value;
}
{
var cc=document.getElementById("UCtd");
cc.innerHTML=DemoMethods.GetAjaxTable().value;
}
6.建一个default.aspx,在pageload事件里面加个注册的东西
private void Page_Load(object sender, System.EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(AjaxTestPrjLib.DemoMethods));
}
{
Ajax.Utility.RegisterTypeForAjax(typeof(AjaxTestPrjLib.DemoMethods));
}
7.最后就是default.aspx的html和js了。
<%@ Page language="c#" Codebehind="default.aspx.cs" AutoEventWireup="false" Inherits="AjaxTextPrjWeb._default" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>default</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content=" http://schemas.microsoft.com/intellisense/ie5 ">
<script language="javascript" src="default.js"></script>
</HEAD>
<body οnlοad="LoadGrid()">
<form id="Form1" method="post" runat="server">
<INPUT type="text" id="AddTextBox" maxlength="10"><INPUT type="button" value="添加" οnclick="javascript:AddAjax(form.AddTextBox.value);">
<table>
<tr>
<td id="UCtd"></td>
</tr>
</table>
</form>
</body>
</HTML>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>default</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content=" http://schemas.microsoft.com/intellisense/ie5 ">
<script language="javascript" src="default.js"></script>
</HEAD>
<body οnlοad="LoadGrid()">
<form id="Form1" method="post" runat="server">
<INPUT type="text" id="AddTextBox" maxlength="10"><INPUT type="button" value="添加" οnclick="javascript:AddAjax(form.AddTextBox.value);">
<table>
<tr>
<td id="UCtd"></td>
</tr>
</table>
</form>
</body>
</HTML>