public List<BarChart> getBarChart(string tid) { List<BarChart> bclist = new List<BarChart>(); using (MySqlConnection cn = new MySqlConnection()) { using (MySqlCommand cmd = new MySqlCommand()) { // obtain connection string information from app.config cn.ConnectionString = "server=localhost; userid=root; password=; database=twitter_stream;"; // tell the cmd to use the cn cmd.Connection = cn; // supply the cmd with the necessary SQL Y-M-D FULL cmd.CommandText = "SELECT * FROM contentsretrievedtemp WHERE tagId = '" + tid + "'"; //testing/print out sqlquery System.Diagnostics.Debug.WriteLine(cmd.CommandText); cn.Open(); // returns the results using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { BarChart bc = new BarChart(reader.GetString("mood"), reader.GetString("content")); bclist.Add(bc); } } } } return bclist; }
public static object getBarChart(string tagd) { List<BarChart> bclist = new List<BarChart>(); BarChart bc = new BarChart(); bclist = bc.getBarChart(tagd); object response = bclist; return response; }