ajax和asp.net如何结合呀? 已经有前台.html 后台如何传参数给它?
wolfs 2007-08-13 05:11:16 前台ajax.html:
<script language="JavaScript">
function GetResult()
{
var oBao = new ActiveXObject("Microsoft.XMLHTTP");
oBao.open("POST","admin.aspx.cs",false);
oBao.send();
var strResult = unescape(oBao.responseText);
//将字符串分开.
var arrResult = strResult.split("###");
RemoveRow(); //删除以前的数据.
//将取得的字符串分开,并写入表格中.
for(var i=0;i<arrResult.length;i++)
{
arrTmp = arrResult[i].split("@@@");
num1 = arrTmp[0]; //字段num1的值
//num2 = arrTmp[1]; //字段num2的值
row1 = tb.insertRow();
cell1 = row1.insertCell();
cell1.innerText = num1;
//cell2 = row1.insertCell();
//cell2.innerText = num2;
}
}
function RemoveRow()
{
//保留第一行表头,其余数据均删除.
var iRows = tb.rows.length;
for(var i=0;i<iRows-1;i++)
{
tb.deleteRow(1);
}
}
function MyShow()
{
//1秒自动刷新一次,1秒取得一次数据.
timer = window.setInterval("GetResult()",1000);
}
</script>
<body onload="MyShow()">
<p>
</p>
<marquee truespeed behavior="scroll" HSPACE="0" VSPACE="0" scrollamount= '6' scrolldelay= '85' direction='up'>
<table width="47%" height="23" border="0" cellpadding="1" cellspacing="0" id="tb">
<tr>
</tr>
</table>
</marquee>
后台:admin.aspx.cs
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;//
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;//StringBuilder 类命名空间
using System.IO;//读取写入命名空间
//访问数据库,并返回数据
private void main()
{
string dbPath=System.Configuration.ConfigurationSettings.AppSettings["dbpath"];
OleDbConnection oleConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath(dbPath));
//string Sql = "SELECT * FROM book";
OleDbCommand cmd=new OleDbCommand("SELECT * FROM nums ORDER BY id DESC",oleConnection);
cmd.CommandType = CommandType.Text;
try
{
cmd.Connection.Open();
OleDbDataReader dr= cmd.ExecuteReader();
if(dr.Read())
{
String[] sResult=new String[1000];
do
{
sResult[1000] = dr["num1"] + "@@@" + dr["num2"];
}while(dr.Read());
}
dr.Close();
}
catch
{
Response.Write("请检查数据库连接");
Response.End();
}
finally
{
cmd.Connection.Close();
}
}
}