sql - How to store variables for the next time a program runs -



sql - How to store variables for the next time a program runs -

i have programme reports how many times client has visited between our of day. in case, programme runs each day, find out how many customers came in between hours of 6 , 7. problem i'm running need maintain running tally of number of customers visted between hours. need output like:

today: 5 total: 5 today: 5 total: 10 today 5 total 15

i can store info in xml file, have 16 different locations i'm tracking that's lot of writing, , reading xml file, assume there improve way handle this? need programme load value of "total" today, plus previous days.

i fill values this:

firsthour = ds.tables(0).rows(i).item(x) secondhour = ds2.tables(0).rows(i).item(x) percentage = math.round(ds2.tables(0).rows(i).item(x) / ds.tables(0).rows(i).item(x) * 100, 2) firsthourtotal = ds.tables(0).rows(i).item(x) secondhourtotal = ds2.tables(0).rows(i).item(x)

obviously, need fisthourtotal, secondhourtotal, stored each of 16 results in array, accessed each day when programme runs.

probably not best way but....

if doing utilize my.settings , utilize system.collections.specialized.stringcollection type situation described.

nice , easy read , write to, remember my.settings.save after writing otherwise wait till close application before updating record!

sql vb.net

Comments

Post a Comment

Popular posts from this blog

java Multi query from Mysql using netbeans -

java Multi query from Mysql using netbeans - i have java code retrieve info mysql appropriate code in netbeans.the code below. want multi query such illustration finding total number of products , on.could help me please. in advance import java.sql.*; public class javamysqlselectexample { public static void main(string[] args) { seek { string mydriver = "com.mysql.jdbc.driver"; string myurl = "jdbc:mysql://localhost/sample"; class.forname(mydriver); connection conn = drivermanager.getconnection(myurl, "root", "mypasscode1"); string query = "select * products"; statement st = conn.createstatement(); resultset rs = st.executequery(query); while (rs.next()==true) { int code = rs.getint("code"); string productname = rs.getstring("product_name"); string producttype = rs.getstring("product_type"); system.out.format(" %d, %s, %s\n", code, pr
Read more

c# - DotNetZip fails with "stream does not support seek operations" -

c# - DotNetZip fails with "stream does not support seek operations" - i using dotnetzip in c# unzip stream follows: public static void unzipfromstream(stream stream, string outdir) { //omit seek grab block using (zipfile zip = zipfile.read(stream)){ foreach (zipentry e in zip){ e.extract(outdir, extractexistingfileaction.overwritesilently); } } } stream obtained using webclient client = new webclient(); stream fs = client.openread(url); however, got next exception exception during extracting zip stream system.notsupportedexception: stream not back upwards seek operations. @ system.net.connectstream.get_position() @ ionic.zip.zipfile.read(stream zipstream, textwriter statusmessagewriter, encoding encoding, eventhandler`1 readprogress) on server side(asp.net mvc 4), returning filepathresult or filestreamresult both caused exception. should obtain stream differently on client side? or how create server homec
Read more

c++ - StartServiceCtrlDispatcher don't can access 1063 error -

c++ - StartServiceCtrlDispatcher don't can access 1063 error - i write on c++ service , have error, , don't can fixed it. my service main function int main (int argc, tchar *argv[]) {dword f; for(int i=0;i<113;i++) f = getlasterror(); servicepath = lptstr(argv[0]); outputdebugstring(_t("my sample service: main: entry")); //installservice(); service_table_entry servicetable[] = { {service_name, (lpservice_main_function) servicemain}, {null, null} }; // startservice(); if(!startservicectrldispatcher(servicetable)) { f = getlasterror(); //addlogmessage("error: startservicectrldispatcher"); } else if( memcmp(argv[argc-1],"install",7)) { installservice(); } else if( memcmp(argv[argc-1],"remove",6)) { removeservice(); } else if( memcmp(argv[argc-1],"start",5)) { startservice(); } else if( memcmp(argv[argc-1],"stop",4))
Read more