c# - Unable to read most recently added to SQL Server Compact Edition -


i'm trying implement function view added item sql server ce database:

private void backbutt_click(object sender, eventargs e) {    try    {        sqlcedatareader myreader = null;         sqlcwcommand cm = new sqlcecommand("select max(ts_process) expr1, max(ts_verify) expr2 teststep", cn)         myreader = cm.executereader();         while (myreader.read())        {            steptb.text = myreader.getstring(0);            expectedtb.text = myreader.getstring(1);        }     }           catch (sqlceexception ex)     {         messagebox.show(ex.message);     } 

connection opened @ form load.

this displays last entry , not display previous entries.

any appreciated.

thanks

quick , easy fix, below code asked, altho not way you're gonna want use it.

        while (myreader.read())          {           steptb.text += myreader.getstring(0) + " ";            expectedtb.text += myreader.getstring(1) + " ";          } 

if want actual overview, datacontrols such repeaters , gridviews.


Comments