AJAXPRO和ACCESS交互问题..急
我用SQLSERVER能正常运行,我改成ACCESS后就一直返回NULL,很郁闷,
代码如下:
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(admin_M_AddBigClass));
if (!mycookie.IsOnline())
{
Response.Redirect("../login.aspx?url=" + System.Web.HttpUtility.UrlEncode(HttpContext.Current.Request.Url.ToString()));这里用conn.state.tostring()做过测试,已连上数据库
}
}
[AjaxPro.AjaxMethod]
public string returnBig(string s1,string s2)
{
OleDbConnection conn = Db.Db.createConnection();
conn.Open();
这里就没反应
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into Hover_BigClassNews(BCNews_Name,BCNews_BigID) values('" + s1.Trim() + "','" + s2.Trim() + "')";
cmd.ExecuteNonQuery();
conn.Dispose();
conn.Close();
return s1 = "true";
}
前台代码如下:
function IsNum(num)
{
var reNum=/^\d*$/;
return(reNum.test(num));
}
function jss()
{
var s1=document.getElementById("Text1").value;
var s2=document.getElementById("Text2").value;
if(document.getElementById("Text1").value==""||document.getElementById("Text2").value=="")
{
alert("大类名或顺序不能为空!");
document.getElementById("Text1").focus();
return false;
}else if(!IsNum(document.getElementById("Text2").value))
{
alert("顺序中请输入数字!");
document.getElementById("Text2").focus();
return false;
}
else
{
var ar=admin_M_AddBigClass.returnBig(s1,s2);
alert(ar.value);
if(ar.value=="true")
{
alert("提交成功!");
return window.location.href="ClassManage.aspx";
}
else
{
alert(ar);
alert("no!");
}
}
}急啊,,>.NET2.0的.AJAXPRO+ACCESS????????????????????