- [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;
- }
- }
- <script language="JavaScript">
-
-
function
getDataSet()
{
var
ds =test.GetDataSet().value;
if
(ds !=
null
&&
typeof
(ds) ==
"object"
&& ds.Tables !=
null
)
{
var
s =
new
Array();
s[s.length] =
"<table style='border: #000000 1px solid; color: #993333; font-family: 'Microsoft 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>