public void updatDB() { Subjectname.Items.Clear(); try { SQLiteConnection sqliteCon = new SQLiteConnection(@"Data Source = messages.db;"); sqliteCon.Open(); List <Msg> dbmsg = new List <Msg>(); SQLiteCommand cmdRead = new SQLiteCommand("SELECT * FROM Messages ", sqliteCon); SQLiteDataReader reader = cmdRead.ExecuteReader(); //try //{ while (reader.Read()) { string msgID = reader.GetString(0); string msgSender = reader.GetString(1); string msgSubject = reader.GetString(2); string msgBody = reader.GetString(3); dbmsg.Add(new Msg() { MsgID = msgID, MsgSender = msgSender, MsgSubject = msgSubject, MsgBody = msgBody }); } foreach (Msg msg in dbmsg) { ADD_NEW_DATA data = new ADD_NEW_DATA(msg.MsgSubject, msg.MsgID, "Data3"); Subjectname.Items.Add(data); //Subjectname.Items.Add(msg.MsgSubject); // sercetBox.Items.Add(msg.MsgID); } sqliteCon.Close(); } catch (Exception ex) { Debug.WriteLine("Exception"); Debug.WriteLine(ex.Message); } }
public void updatDB() { Subjectname.Items.Clear(); try { SQLiteConnection sqliteCon = new SQLiteConnection(@"Data Source = messages.db;"); sqliteCon.Open(); List<Msg> dbmsg = new List<Msg>(); SQLiteCommand cmdRead = new SQLiteCommand("SELECT * FROM Messages ", sqliteCon); SQLiteDataReader reader = cmdRead.ExecuteReader(); //try //{ while (reader.Read()) { string msgID = reader.GetString(0); string msgSender = reader.GetString(1); string msgSubject = reader.GetString(2); string msgBody = reader.GetString(3); dbmsg.Add(new Msg() { MsgID = msgID, MsgSender = msgSender, MsgSubject = msgSubject, MsgBody = msgBody }); } foreach (Msg msg in dbmsg) { ADD_NEW_DATA data = new ADD_NEW_DATA(msg.MsgSubject, msg.MsgID, "Data3"); Subjectname.Items.Add(data); //Subjectname.Items.Add(msg.MsgSubject); // sercetBox.Items.Add(msg.MsgID); } sqliteCon.Close(); } catch (Exception ex) { Debug.WriteLine("Exception"); Debug.WriteLine(ex.Message); } }