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
Post a Comment