<body>
<form id="form1" runat="server">
<img id="loading" src="ajax-loader.gif" />
<div id="divguid" > </div>
<div id="lblDataUpdated">
</div>
<div id="lblMinute"> </div>
<script type="text/javascript">
$(document).ready(function() { $('#loading').hide(); $('#clickmeupdate').click(function() { MyUpdate(); }); });
function MyUpdate()
{
$('#loading').show();
var name=$('#tbName').val();
var password=$('#tbPassWord').val();
$.post("ajaxdata.ashx",{name:name,word:password}, function(result)
{
var oResultData = eval('(' + result + ')');
$('#divguid').html( oResultData.realname );
$('#lblDataUpdated').html( oResultData.sex);
$('#lblMinute').html(oResultData.email);
$('#loading').hide();
});
//setTimeout(MyUpdate,10 * 1000);
}
</script>
<br />
<table class="style1">
<tr>
<td>
用户名 </td>
<td>
<asp:TextBox ID="tbName" runat="server"> </asp:TextBox>
</td>
</tr>
<tr>
<td>
密码 </td>
<td>
<asp:TextBox ID="tbPassWord" runat="server"> </asp:TextBox>
</td>
</tr>
</table>
<input type="button" id="clickmeupdate" value="提交" />
</form>
</body>
服务器部分
public class ResultData
{
public string User_realname;
public string User_sex;
public string User_email;
public ResultData()
{
HttpContext context=HttpContext.Current;
string name=context.Request["name"];
string password=context.Request["word"];
string sql="select * from z_UserInfo where User_name=@name and User_psw=@password ";
//Minute = DateTime.Now.Minute;
//Guid = System.Guid.NewGuid().ToString();
//Updated = DateTime.Now;
string conn ="Data Source=.;Initial Catalog=shop;uid=sa;pwd=sa";
SqlConnection connection = new SqlConnection(conn);
SqlCommand com = new SqlCommand(sql, connection);
SqlParameter p1=new SqlParameter("@name",DbType.String);
p1.Value=name;
com.Parameters.Add(p1);
SqlParameter p2=new SqlParameter("@password",DbType.String);
p2.Value = password;
com.Parameters.Add(p2);
connection.Open();
SqlDataReader reader= com.ExecuteReader();
while (reader.Read())
{
User_realname = reader["User_realname"].ToString();
User_sex = reader["User_sex"].ToString();
User_email = reader["User_email"].ToString();
}
connection.Close();
}
public string GetResultDataJSON()
{
StringBuilder oBuilder = new StringBuilder();
oBuilder.Append("{");
oBuilder.AppendFormat("{0} : '{1}',", "realname", User_realname);
oBuilder.AppendFormat("{0} : '{1}',","sex", User_sex);
//Datetime special - javascript date is ms after 1 jan 1970
//TimeSpan oSpan = Updated - new DateTime(1970, 1, 1, 0, 0, 0);
oBuilder.AppendFormat("{0} : '{1}'","email", User_email);
oBuilder.Append("}");
return oBuilder.ToString();
}
}
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
context.Response.ContentType = "text/plain";
// if (context.Request["what"] != null && context.Request["what"] == "resuldata")
context.Response.Write(new ResultData().GetResultDataJSON());
<form id="form1" runat="server">
<img id="loading" src="ajax-loader.gif" />
<div id="divguid" > </div>
<div id="lblDataUpdated">
</div>
<div id="lblMinute"> </div>
<script type="text/javascript">
$(document).ready(function() { $('#loading').hide(); $('#clickmeupdate').click(function() { MyUpdate(); }); });
function MyUpdate()
{
$('#loading').show();
var name=$('#tbName').val();
var password=$('#tbPassWord').val();
$.post("ajaxdata.ashx",{name:name,word:password}, function(result)
{
var oResultData = eval('(' + result + ')');
$('#divguid').html( oResultData.realname );
$('#lblDataUpdated').html( oResultData.sex);
$('#lblMinute').html(oResultData.email);
$('#loading').hide();
});
//setTimeout(MyUpdate,10 * 1000);
}
</script>
<br />
<table class="style1">
<tr>
<td>
用户名 </td>
<td>
<asp:TextBox ID="tbName" runat="server"> </asp:TextBox>
</td>
</tr>
<tr>
<td>
密码 </td>
<td>
<asp:TextBox ID="tbPassWord" runat="server"> </asp:TextBox>
</td>
</tr>
</table>
<input type="button" id="clickmeupdate" value="提交" />
</form>
</body>
服务器部分
public class ResultData
{
public string User_realname;
public string User_sex;
public string User_email;
public ResultData()
{
HttpContext context=HttpContext.Current;
string name=context.Request["name"];
string password=context.Request["word"];
string sql="select * from z_UserInfo where User_name=@name and User_psw=@password ";
//Minute = DateTime.Now.Minute;
//Guid = System.Guid.NewGuid().ToString();
//Updated = DateTime.Now;
string conn ="Data Source=.;Initial Catalog=shop;uid=sa;pwd=sa";
SqlConnection connection = new SqlConnection(conn);
SqlCommand com = new SqlCommand(sql, connection);
SqlParameter p1=new SqlParameter("@name",DbType.String);
p1.Value=name;
com.Parameters.Add(p1);
SqlParameter p2=new SqlParameter("@password",DbType.String);
p2.Value = password;
com.Parameters.Add(p2);
connection.Open();
SqlDataReader reader= com.ExecuteReader();
while (reader.Read())
{
User_realname = reader["User_realname"].ToString();
User_sex = reader["User_sex"].ToString();
User_email = reader["User_email"].ToString();
}
connection.Close();
}
public string GetResultDataJSON()
{
StringBuilder oBuilder = new StringBuilder();
oBuilder.Append("{");
oBuilder.AppendFormat("{0} : '{1}',", "realname", User_realname);
oBuilder.AppendFormat("{0} : '{1}',","sex", User_sex);
//Datetime special - javascript date is ms after 1 jan 1970
//TimeSpan oSpan = Updated - new DateTime(1970, 1, 1, 0, 0, 0);
oBuilder.AppendFormat("{0} : '{1}'","email", User_email);
oBuilder.Append("}");
return oBuilder.ToString();
}
}
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
context.Response.ContentType = "text/plain";
// if (context.Request["what"] != null && context.Request["what"] == "resuldata")
context.Response.Write(new ResultData().GetResultDataJSON());