MySql server data retrieval on 2D UWP UI

chiddaan

So, for a simple example,

Let's say there's an employee table and and a simple XAML UI that displays employee data using textblocks.

I have connected to the MySql server in VS 2015 and also I am able to query data in the query window.

The question, is how do I connect the data from the query to the UI?
I can't use the sqlcommand and use a reader ( the usual approach) as "using System.Data.SqlClient;" is not available.

Thank you

Jimbohalo10

Hi @chiddaan
You will need to add the NuGet package using "Manage NuGet Packages" on your VS Solution before you can connect to the database on any Visual Studio project and add the following dependencies in the project.json in your VS Solution

{
"dependencies": {
"Microsoft.NETCore.UniversalWindowsPlatform": "5.3.1",
"System.Data.SqlClient": "4.3.0"
},
"frameworks": {
"uap10.0": {}
},
"runtimes": {
"win10-x86": {},
"win10-x86-aot": {}
}
}
Save and Restore NuGet Packages

Now you can add
#using System.Data.SqlClient;
without error

MattFedoCSG

What engine are you using? .NET only, Unity?

chiddaan

for this, just the .Net. It's UWP app.

No Unity in this one.

Jimbohalo10

Hi @chiddaan
You will need to add the NuGet package using "Manage NuGet Packages" on your VS Solution before you can connect to the database on any Visual Studio project and add the following dependencies in the project.json in your VS Solution

{
"dependencies": {
"Microsoft.NETCore.UniversalWindowsPlatform": "5.3.1",
"System.Data.SqlClient": "4.3.0"
},
"frameworks": {
"uap10.0": {}
},
"runtimes": {
"win10-x86": {},
"win10-x86-aot": {}
}
}
Save and Restore NuGet Packages

Now you can add
#using System.Data.SqlClient;
without error

chiddaan

Hi @Jimbohalo10 , I will try and make use of your solution.

But I tried adding a NuGet package using the UI, for sql server. while installing it would give me error saying it's incompatible.

chiddaan

Oh well, it worked :P THanks