Many thanks. I have these codes
but I do get this error due to PageMethods. why?

<link rel="stylesheet" type="text/css" href="http://ift.tt/1c3Zbe3; />
<script src="http://ift.tt/1f0kuBr;
<script type="text/javascript" src="http://ift.tt/1dqbljI;
<script type="text/javascript">
$(function () {
$.ajaxSetup({ cache: false });
UpdateDatabase();
setInterval(UpdateDatabase, 60000);
});
function UpdateDatabase() {
PageMethods.UpdateDatabase($('#lb_var1').text())
}
...
[WebMethod]
public static void UpdateDatabase(string iteabbr)
{
using (var sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Mssqlconn2"].ConnectionString))
{
sqlConnection.Open();
var query = "UPDATE ite_master SET polling_time= @LastSeen WHERE ite_abbr = @iteabbr";
using (var sqlCommand = new SqlCommand(query, sqlConnection))
{
sqlCommand.Parameters.AddWithValue("@LastSeen", DateTime.Now);
sqlCommand.Parameters.AddWithValue("@iteabbr", iteabbr);
sqlCommand.ExecuteNonQuery();
}
}
}
but I do get this error due to PageMethods. why?
Many Thanks & Best Regards, Hua Min
No comments:
Post a Comment