I would like to make a connection from Arduino Uno to Microsoft SQL Server for storing student attendance records into a table from my database.
So, what is the best way to do that? I need a suggestion or useful references and links.
I have written a web application on Visual Studio using C# language. What Arduino does is getting fingerprint through sensor, then I would like to store the attendance records of a student into database. So the attendance records can be retrieved from database to the web application and display to teachers.
This is just for project purpose only and the connectivity between Visual & SQL Server using these two lines below:
SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=DESKTOP-H7KQUT1;Initial Catalog=SAOS1;Integrated Security=True";