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(); }