将Xamarin连接到服务器SignalR并获取数据SqlDependecy [英] Connect Xamarin to server SignalR and get data SqlDependecy

问题描述

各位大家好！我有SQLdependency并且我通过Javascript连接他客户端

Hello everybody ! I have SQLdependency and I connect him client by Javascript

		public static IEnumerable<Products> GetData()
		{

			using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString))
			{
				connection.Open();
				using (SqlCommand command = new SqlCommand(@"SELECT [Guests] FROM  [1]", connection))
				{
					// Make sure the command object does not already have
					// a notification object associated with it.
					command.Notification = null;
					SqlDependency.Start(ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString);
					SqlDependency dependency = new SqlDependency(command);
					dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);

					if (connection.State == ConnectionState.Closed)
						connection.Open();

					using (var reader = command.ExecuteReader())
						return reader.Cast<IDataRecord>()
							.Select(x => new Products()
							{
								Guests = x.GetString(0),
							}).ToList();


				}
			}
		}

		  function getData() {
			  var $tbl = $('#tbl');
			  $.ajax({
				  url: 'index.aspx/GetData',
				  contentType: "application/json; charset=utf-8",
				  dataType: "json",
				  type: "POST",
				  success: function (data) {
					  debugger;
					  if (data.d.length > 0) {
						  var newdata = data.d;
						  $tbl.empty();
						  $tbl.append(' <tr><th>ID</th><th>Name</th><th>Last Executed Date</th><th>Status</th></tr>');
						  var rows = [];
						  for (var i = 0; i < newdata.length; i++) {
							  rows.push(' <tr><td>' + newdata[i].Guests + '</td></tr>');
						  }
						  $tbl.append(rows.join(''));
					  }
				  }
			  });
		  }

$

如何连接 index.aspx / GetDat a  

推荐答案

[WebMethod]
[ScriptMethod(UseHttpGet = true)]

public static IEnumerable<Products> GetData()
{
}

这是一个GET而不是POST。

It's a GET not a POST.

ASP .NET问题，如SignalR和ASPX 可以在ASP.NET论坛上解决。

ASP.NET issues like SignalR and ASPX  can be addressed at the ASP.NET forums.

http://forums.asp.net/

http://forums.asp.net/

这篇关于将Xamarin连接到服务器SignalR并获取数据SqlDependecy的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！