public IEnumerable <SampleDataFileRow> ReadAllRowsDB()
{
DBController mydbC = new DBController();
MCDataSet.MediaDataTable media = mydbC.getMedia();
//System.Diagnostics.Debug.WriteLine("debug: "+media.Rows[0]["link"].ToString());
foreach (DataRow row in media.Rows)
{
yield return(new SampleDataFileRow
{
LineNumber = media.Rows.IndexOf(row),
LineText = row["link"].ToString(),
Id = (Int32)row["mediaID"]
});
}
/*
* foreach (String s in rows) {
* System.Diagnostics.Debug.WriteLine("ROW: " + s.ToString() + " END");
* }
*/
}
private List <KeyValuePair <string, String> > getcontent(int id) // media id to question content
{
DBController db = new DBController();
MCDataSet.MediaDataTable mdt = db.getQID_MID_Diff(id);
System.Diagnostics.Debug.WriteLine(mdt.Rows[0]["questionID"].ToString());
// Int32 qid = (Int32) mdt.Rows[0]["questionID"];
// Int32 aid = (Int32) mdt.Rows[0]["answerID"];
// MCDataSet.MediaDataTable qlink = db.getMediaFromQID(qid);
//mdt.Rows[0].Table.Columns["link"].DefaultValue.ToString();
//mdt.Rows[0].Table.Columns["rating"].DefaultValue.ToString();
List <KeyValuePair <string, String> > cont = new List <KeyValuePair <string, String> >()
{
new KeyValuePair <string, string>("title", "default"),
new KeyValuePair <string, string>("description", "default"),
new KeyValuePair <string, string>("rating", "default"),
};
return(cont);
}
public DBController()
{
mrow = new MCDataSet.MediaDataTable();
mAdap = new MCDataSetTableAdapters.MediaTableAdapter();
}
