如何创建与SQL Server数据库连接的动态Google地图 [英] How to create dynamic Google map connected with SQL server database

问题描述

我正在为代理商创建一个在线客户服务和支持系统，使用SQL Server 2016和ASP.NET，C＃



我必须创建一个地图显示客户与所提供机器有问题的地方出现红旗。

单击标记时，将显示更多信息。该信息应该从超过3个表的SQL数据库中提取。



此外，每当代理更新问题或添加新问题时，详细信息地图应该会自动更改。



你有什么建议吗？



我试过的：



我尝试在Customer表，Latitude和Longitude中添加新属性。但后来我陷入困境，在代理插入地址和邮政编码后，这些单元格将如何自动填充。

然后我刚创建了一个带有API密钥的谷歌地图，并且只使用了邮政编码。然后将客户详细信息导出到Excel文件。问题是我需要将SQL数据库与Excel电子表格连接起来，以便在更新数据库的同时更新Excel电子表格。



要提到的是，Excel电子表格应该从SQL数据库的4个表中收集详细信息。



我不是高级开发人员，但我很想学习。也许这个问题对你们大多数人来说都很轻松:)请光临我。

解决方案

当您的CS代理创建或更新地址时;利用AJAX并向Google GeoCoder API发出请求以获得纬度和频率。经度。

I am creating an online Customer Service and Support System, for Agents, using SQL Server 2016 and ASP.NET, C#

I have to create a map showing red flags on the locations where the customers have issues with the machines provided.
When clicking the flag, more information will appear. That information should be extracted from SQL database, from more than 3 tables.

Also, every time an agent is updating an issue or add a new one, the details on the map should change automatically.

What are your suggestions?

What I have tried:

I have tried adding new attributes into Customer table, Latitude and Longitude. But then I got stuck with how will those cells be filled in automatically after the agent insert the address and postcode.
Then I just created a google map with API key, and used just the Postcode. Then exported Customer details to Excel file. The problem is that I need to connect the SQL database with the Excel spreadsheet in such way that Excel spreadsheet would update at the same time database is updated.

To be mentioned, the Excel spreadsheet should gather details out of 4 tables from the SQL database.

I am not an advanced developer, but I am keen to learn. Maybe the question is "easy peasy" for most of you :) Please bare with me.

解决方案

When your CS Agent creates or updates an address; utilize AJAX and make a request to the Google GeoCoder API to get the latitude & longitude.

这篇关于如何创建与SQL Server数据库连接的动态Google地图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！