Ajax+xml+数据岛 2

无需手动将数据字段绑定到表,实现和DataGrid一样效果的table,爽呆了!!!!!!!!!!

<%@ Page language="c#" Codebehind="ajaxDataGrid.aspx.cs" AutoEventWireup="false" Inherits="WebApplication1.ajaxDataGrid" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>ajaxDataGrid</title>

body { font-size: 12px; margin: 0px; color: #000000; line-height: normal; background-color: #ffffff; }

td { font-size: 12px; }

.dg_item { background: #ffffff; border-collapse: separate; }

.tdbg-dark { background:#316AC5; border: 1px solid #000066; }

.tdbg { background: #ffffff; border-bottom: #000000 1px solid; border-collapse: separate; color:black }

</style>

//初始化表格

function Init()

{

　 //alert('1');

　 divDataGrid1.innerHTML=ajaxDataGrid.GetTableOuterHTML().value;

　 getdata();

}

//得到数据

function getdata()

{

var ss=ajaxDataGrid.GetDataXML().value;

var aa='<xml id="xmlData">'+ss+'</xml>'; //xml的ID是表格的数据源

//alert(aa);

divDataGrid.innerHTML=aa;

}

function InTo()

{

window.open("test.aspx");

}

//选择所有

function SelectAll (chkVal, idVal)

{

var frm = document.forms[0];

for (i=0; i<frm.length; i++)

{

if (idVal.indexOf ('chkAll') != -1)

{

if(chkVal == true)

{

frm.elements[i].checked = true;

}

else

{

frm.elements[i].checked = false;

}

else if (idVal.indexOf ('mychk') != -1)

{

if(frm.elements[i].checked == false)

{

frm.elements[1].checked = false;

}

//删除数据

function del()

{

var tmp=document.getElementsByName("mychk");

alert('1');

var strId = new String();

var n = 0;

for(var i=0; i<tmp.length; i++)

{

if(tmp[i].checked)

{

strId += tmp[i].parentElement.parentElement.childNodes(1).innerText + ",";

n++;

}

alert('2');

var s=ajaxDataGrid.DelData(strId).value;

alert('3');

if(s!="0")

{

alert("删除成功");

getdata(); //重新绑定数据

}

else

{

alert("删除失败");

}

//编辑数据

function editItem(strtd)

{

alert(strtd.childNodes(2).innerText);

//将第一列的值传到另一页面

window.open("test.aspx?ID="+strtd.childNodes(2).innerText)

}

</script>

</HEAD>

<TABLE id="Table1" style="Z-INDEX: 105; LEFT: 88px; POSITION: absolute; TOP: 24px" cellSpacing="1"

cellPadding="1" width="80%" border="1">

<TR>

<TD>

</TR>

<TR>

</TD>

</TR>

</TABLE>

</form>

</body>

</HTML>

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.OracleClient;

using System.Text;

using System.IO;

using System.Data.SqlClient;

namespace WebApplication1

{

/// <summary>

/// ajaxDataGrid 的摘要说明。

/// </summary>

public class ajaxDataGrid : System.Web.UI.Page

{

static string strTableName="";

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

Ajax.Utility.RegisterTypeForAjax(typeof(ajaxDataGrid));

Session["strTableName"]=Request.QueryString["TableName"].ToString();

strTableName=Session["strTableName"].ToString();

}

Web 窗体设计器生成的代码

//得到表TableName的所得数据，以XML字符串返回

[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]

public string GetTableOuterHTML()

{

// string strcon="data source=sundun3;uid=lsa_ga;pwd=sundun";

// OracleConnection conn=new OracleConnection(strcon);

string strcon="server=(local);database=lsa_anqiu;uid=sa;pwd=sundun";

SqlConnection conn=new SqlConnection(strcon);

string strSelect=string.Format("select * from {0}",Session["strTableName"].ToString());

// OracleDataAdapter da=new OracleDataAdapter(strSelect,conn);

SqlDataAdapter da=new SqlDataAdapter(strSelect,conn);

DataSet ds=new DataSet();

da.Fill(ds);

　 return GetTableOuterHTML(ds.Tables[0].DefaultView);

}

//由一个数据视图得到该表的表头及所有数据，以XML格式的表字符串返回

private string GetTableOuterHTML(DataView dv)

{

StringBuilder ret = new StringBuilder();

ret.Append("<table id='DataGrid1' dataSrc='#xmlData' cellspacing=1 cellpadding=4 border=1 dataPageSize=10 width=90%><THEAD>" );

ret.Append("<tr>");

ret.Append("<td width='5'> <input type='checkbox' id='chkAll' onclick='SelectAll(this.checked, this.id)'></td> ");

//标题

foreach(System.Data.DataColumn dc in dv.Table.Columns )

{

if(dc.Ordinal==1) //该列隐藏

//ret.Append("<td style=\"DISPLAY: none\">"+dc.ColumnName+"</td>"); //注意，这里要是定义了某一列隐藏，在表格里也要相应的隐藏

ret.Append("<td >"+dc.ColumnName+"</td>");

else

ret.Append("<td>"+dc.ColumnName+"</td>");

}

ret.Append("</THEAD></tr>");

//这时是视图中筛选后的数据

ret.Append(GetRowOuterHTML(dv));

ret.Append("</table>");

return ret.ToString ();

}

//将字段绑定到表格里

private string GetRowOuterHTML(DataView dv)

{

StringBuilder sbtable=new StringBuilder();

sbtable.Append("<tr onmouseover=\"this.className='tdbg-dark';\" onmouseout=\"this.className='tdbg';\" ondblclick=\"editItem(this)\">");

sbtable.Append("<td width='5'> <input type='checkbox' id='mychk'></td> ");

foreach(System.Data.DataColumn dc in dv.Table.Columns)

{

if(dc.Ordinal==1) //将第二列设为超连接,CHECKBOX不算

{

sbtable.Append("<td ><span dataFld="+dc.ColumnName+" title='查看详细信息' class=\"AnJianID\" OnClick='InTo()' class=\"dg_item\"");

}

else

{

sbtable.Append("<td ><span dataFld="+dc.ColumnName+" class=\"dg_item\"");

}

//sbtable.Append(tem);

sbtable.Append("></span></td>");

}

sbtable.Append("</tr>");

return sbtable.ToString();

}

[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]

public string GetDataXML()

{

// string strcon="data source=sundun3;uid=lsa_ga;pwd=sundun";

// OracleConnection conn=new OracleConnection(strcon);

string strcon="server=(local);database=lsa_anqiu;uid=sa;pwd=sundun";

SqlConnection conn=new SqlConnection(strcon);

// string strSelect=string.Format("select * from {0} where rownum<20 ",Session["strTableName"].ToString());

string strSelect=string.Format("select top 20 * from {0} ",Session["strTableName"].ToString());

// OracleDataAdapter da=new OracleDataAdapter(strSelect,conn);

SqlDataAdapter da=new SqlDataAdapter(strSelect,conn);

DataSet ds=new DataSet();

da.Fill(ds);

string text = "";

using(MemoryStream ms = new MemoryStream())

{

　 ds.WriteXml(ms);

　 ms.Position = 0;

　 StreamReader sr = new StreamReader(ms);

　 text = sr.ReadToEnd();

}

return text;

}

/// <summary>

/// 删除数据

/// </summary>

/// <returns></returns>

[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] //可以使用session

public string DelData(string str)

{

int i=0;

string strcon="data source=sundun3;uid=lsa_ga;pwd=sundun";

OracleConnection conn=new OracleConnection(strcon);

conn.Open();

OracleCommand com;

string strA=str.TrimEnd(','); //去掉末尾的,号

ArrayList ar=arrSplit(strA);

if(ar.Count>0)

{

for(int m=0;m<ar.Count;m++)

{

string strDelete=string.Format("delete {0} where iidd ='{1}'",Session["strTableName"].ToString(),ar[m].ToString());

com=new OracleCommand(strDelete,conn);

i=com.ExecuteNonQuery();

}

return i.ToString();

}

//将字符串分割成数组

public static ArrayList arrSplit(string strSplit)

{

ArrayList arrList = new ArrayList();

int i = 0;

int j = 0;

int l = strSplit.Length;

int lenStr = 1;

int k = strSplit.LastIndexOf(',');

if(strSplit.IndexOf(',') ==0)

{

arrList.Add("");

}

if(k == -1)

{

arrList.Add(strSplit);

}

else

{

while(j < k && i < l + lenStr)

{

j = strSplit.IndexOf(',',i);

arrList.Add(strSplit.Substring(i,j-i));

i = j + lenStr;

}

arrList.Add(strSplit.Substring(k + lenStr));

}

return arrList;

}

posted on 2006-11-16 18:17 huazi4995 阅读(256) 评论(0) 收藏举报