Sunday, June 1, 2014

Problem with the line

Many thanks. I have these codes


<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