OK, I'm going to answer this question and then close it as although I couldn't get the real fancy Microsoft way of adding a datasource I did it the old fashioned way. Not the super nice way but this was just me learning, so after you see this example please know that I'm a long way off still.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using MySql.Data.MySqlClient;
namespace MyFitnessApp
{
public partial class _Default : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
MySqlConnection mss = new MySqlConnection("server=IP Address;Port=####;Database=db_name;Uid=userId;Pwd=password;");
string strSQL = "";
strSQL = "SELECT * FROM TABLE;";
MySqlDataAdapter mda = new MySqlDataAdapter(strSQL,mss);
DataSet myDS = new DataSet();
mda.Fill(myDS,"TABLE");
this.GridView1.DataSource = myDS;
this.GridView1.DataBind();
}
}
}
}
I'd like to figure out how to call the connectionstring from the web.config but this is what I found in several examples.
What is ironic is that I'm much more comfortable in VB.Net and I'm learning C#. The example I found was written in VB.Net and I converted it to C#. (:
