[Ajax.AjaxMethod()]

public DataSet GetDataSet()

{

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:工作项目分析 estdb.mdb;Persist Security Info=True;");

DataSet ds = new DataSet();

try

{

OleDbCommand cmd = conn.CreateCommand();

cmd.CommandText = "select * from t_name";

cmd.CommandType = CommandType.Text;

OleDbDataAdapter da = new OleDbDataAdapter(cmd);

da.Fill(ds);

return ds;

}

catch

{

conn.Close();

throw;

}

}

[/code]

复制代码 代码如下:

<script language="JavaScript">

// var ds =test.GetDataTable().value; //table数据源

//alert(ds.Rows[i].level2;

function getDataSet()

{

var ds =test.GetDataSet().value;

if(ds != null && typeof(ds) == "object" && ds.Tables != null)

{

var s = new Array();

s[s.length] = "<tableMicrosoft Sans Serif'; background-color: #ffff99;'>";

for(var i=0; i<ds.Tables[0].Rows.length; i++)

{

s[s.length] = "<tr>";

s[s.length] = "<td>" + ds.Tables[0].Rows[i].id + "</td>";

s[s.length] = "<td>" + ds.Tables[0].Rows[i].f_date + "</td>";

s[s.length] = "<td>" + ds.Tables[0].Rows[i].f_name + "</td>";

s[s.length] = "</tr>";

}

s[s.length] = "</table>";

document.getElementById("div1").innerHTML = s.join("");

}

else

{

alert("调用Ajax接口函数错误！");

}

}

</script>