- 0
Easiest way to get a website to pull data in from an MS SQL Express database?
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Popular Now
-
38
By Usama Jawad96
Started
-
-
Posts
-
By leonsk29 · Posted
You don't even know me and you're already swearing that you have been a Linux user for "longer than me" 😅. And how would you know that, by the way? And yes, I can speak my mind and say whatever the hell I want, even being a Linux user. Linux is great and all, but it isn't for everybody yet, especially if you're into MMO gaming and/or use specific professional software. And no, not everything works perfectly out of the box on Linux, some stuff doesn't work at all, and for the majority of users out there, that's a no-go. And don't you dare say that they don't want to learn, because that's true, they don't want to, because they are normal users, not tech enthusiasts. Open your eyes, 99.99% of people out there simply don't care about any of this. -
By MacDaddyAz · Posted
But you don't know that. But I reported you to Neowin for encouraging illegal activation of Windows 10 LTSC by promoting grey market keys. Have a good weekend!! -
By leonsk29 · Posted
Because the point of people doing all of this is to avoid Windows 11, genius. Many people don't want to upgrade and want to stay on 10 for the longest possible, because they don't like 11 for their particular reasons. That's what this whole debate is all about. -
By MacDaddyAz · Posted
Gatekeepers? I’m a lifelong Linux user, longer than you! In fact I still use Windows 11, MacOS and Opensuse tumbleweed along with AnduinOS. You’re gatekeeping Windows over Linux!!! There is plenty of Linux distros for beginners!!! You’re no Linux user if you promote against it!!! -
By Usama Jawad96 · Posted
Windows 10 is the reason why we are so conscious about privacy now by Usama Jawad About a year ago, Microsoft debuted Recall in Windows 11, a feature that would record and remember everything that you do on your PC, allowing you to ask more contextual questions about your various activities and workflows from a dedicated assistant. Although the Redmond firm offered various privacy controls for Recall and even made it opt-in rather than mandatory, the launch was a disaster and the company had to recall Recall. All of this happened because people were not happy that Microsoft would record everything that they do on their PC and then share that information with an AI model, despite the company's assurances that all of this would happen locally and no data would be sent to Redmond's servers. Couple that with some lackluster security features and it was just a disaster waiting to happen. Although things have improved quite a bit since then, thanks to extensive testing in Insider Channels, some third-parties are still giving users controls that will allow them to block Recall for the vendor's software. I personally believe that this is a good thing, and we definitely should have more scrutiny around software that captures our activities (even with our consent). But as we approach Windows 10's 10th birthday and eventual end of support date, I can't help but realize that the main reason behind Windows customers being very privacy conscious nowadays is the beloved Windows 10 operating system itself. Windows 10 and the telemetry fiasco To truly understand what I mean, we have to go back a decade, to the launch of Windows 10 in 2015. Although the operating system has an ardent fanbase now, things weren't always this way. In fact, Windows 10 had a fairly rocky launch, and one of the reasons behind this was dreaded word telemetry. Anyone who has spent some time in the field of software development and productionizing solutions knows that telemetry typically the anonymized collection of data from various signals to monitor the health of software and diagnose a problem in case of any issues. Telemetry is very useful, for example, in cases where your Microsoft Word application may unexpectedly crash. Microsoft would monitor the telemetry logs from this crash, diagnose the problem, and ideally deliver a fix so that it doesn't happen on your or anyone else's device again. Now, telemetry collection is a regular process, all major software vendors have it at some level. However, when Microsoft decided to mention it in their privacy statement for Windows 10's Technical Preview (this is what Windows Insider Previews were called at that time) in 2014, there was massive uproar. Things spiraled to the point that people began to allege that Microsoft is spying on literally everything that you do through Windows 10. The backlash was so significant that by April 2015, a few months prior to the launch of Windows 10, Microsoft was scrambling to add new privacy controls in the operating system in response and the ability to delete content that Cortana (R.I.P) remembered about you. Heck, we even had software pirates and torrent-sharing groups banning Windows 10 over privacy concerns. Even Russian law firms began applying pressure on Moscow to investigate Microsoft over Windows 10's alleged spying. By 2017, Microsoft was under scrutiny from Switzerland, France, and other European authorities because of these claims. During this tumultuous period, the Redmond tech firm was constantly putting out statements to convince people that Windows 10 does not spy on you, all while building a dedicated privacy dashboard for the operating system and fixing actual Windows 10 privacy bugs. It was clear that Windows 10's launch hadn't been as smooth as the company probably would have wanted. Turning the privacy corner Things finally started to go in Microsoft's favor in April 2017, roughly two whole years after the launch of Windows 10. This was primarily because of the firm's increased transparency regarding data collection, enhanced privacy controls, and useful privacy reminders when installing new versions of Windows 10. By August 2017, Microsoft put out a statement saying that it is seeing "positive reception" from customers regarding privacy, indicating that it had finally turned a corner on the specific topic. This did not mean that Microsoft had been completely absolved by the public and regulators. It was still the target of regular regulator scrutiny, despite releasing new privacy controls frequently and constantly assuring customers that their data is not being sent to Microsoft without their consent. But it was clear that the worst was now behind. Where we stand now I would argue that the entire privacy and telemetry fiasco surrounding Windows 10 was blown out of proportion. I will emphasize again: telemetry collection is a regular process in software development and productionization, and it's something that every big firm does. However, a target was put on Microsoft's back just because it was a hot topic to spread fear, uncertainty, and doubt (FUD). As a Windows 10 veteran who has been around since the earliest days of the operating system's Technical Previews, I'm glad that we still managed to extract something positive out of this experience. Microsoft became very conscious about privacy (until Windows 11 Recall, that is), while we as customers began to understand that our data matters to us. Just because Windows 10 was not spying on us didn't mean that no one else is either. Media outlets like Neowin also became conscious of the topic, which is the main reason why we were able to avoid the disastrous initial launch of Windows 11 Recall. Despite how all of this started, all the FUD, I'm at least glad about where we ended. Although Windows 10 is adored by Microsoft customers even now, things weren't always like this. And as we celebrate the 10th birthday of the OS and its imminent device, it's important to be mindful of the fact that this is the operating system that made us so conscious about software privacy, and that's a good thing. This story is a part of our "10 Years of Windows 10" collection, in celebration of the operating system's tenth anniversary, falling on July 29, 2025. Over the next few days and weeks, you'll be able to find more content on this topic in our dedicated section available here.
-
-
Recent Achievements
-
CarlosABC earned a badge
Dedicated
-
solidox earned a badge
One Month Later
-
Stephen Leibowitz earned a badge
Week One Done
-
Homayoun Hotak earned a badge
Week One Done
-
Profit earned a badge
Dedicated
-
-
Popular Contributors
-
Tell a friend
Question
+Cryton Subscriber²
Hi all,
I am playing around with some stuff I haven't done before, just for "fun".
I have made a simple Microsoft SQL Express database that contains data about football games. I can query the database using Table-valued Functions I have written for things like GetResultsFromWeek(WeekNum INT), or GetLeagueTableAfterWeek(WeekNum INT), and SQL generates the data I want. These queries work fine from SQL Server Management Studio.
I want to be able to have a website talk to the SQL instance, pull in the data I want, and display it in a table. (And later make graphs, but that's way down the road).
So on the website I could have a WeekNum dropdown, and I could select Week 3, and the website would show the results for the games played during week 3, and then also the overall league table after 3 week worth of games.
The website does not need to update the SQL database, it will only be reading from it. I am most comfortable with MS technologies (so no linux stuff or SQLite or anything).
What is the best way to achieve this? I have tried using ASP.NET and ASP.NET Core but from the examples I have read this all requires programming knowledge of classes and uses crazy terminology that I really don't understand. I'm not even sure is ASP is the way to go for this small project.
Does anyone have a suggestion of the easiest way I can do what I need to? This website is very unlikely to go live to the public, I just want to try and learn some new stuff whilst stuck at home.
Thanks for reading, and please feel free to talk to me like a small child if you think it will help me understand
Link to comment
https://www.neowin.net/forum/topic/1402909-easiest-way-to-get-a-website-to-pull-data-in-from-an-ms-sql-express-database/Share on other sites
0 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now