how increase totaldownloads value in database file code given below
sqlconnection sqlcon = new sqlconnection(configurationmanager.connectionstrings["con"].tostring()); sqlcommand sqlcmd = new sqlcommand(); sqldataadapter da = new sqldataadapter(); datatable dt = new datatable(); datarow dr; protected void page_load(object sender, eventargs e) { if (session["userid"] == null) { lblmessage.visible = true; gridview1.visible = false; //appcontent.visible = false; } else { if (!page.ispostback) { sqlconnection sqlcon = new sqlconnection(configurationmanager.connectionstrings["con"].tostring()); arraylist myarraylist = convertdatasettoarraylist(); literal objliteral = new literal(); stringbuilder objsbuilder = new stringbuilder(); //add column datatable display products dt.columns.add("appimg"); dt.columns.add("appname"); dt.columns.add("applink"); dt.columns.add("apptype"); dt.columns.add("totalvisitors"); dt.columns.add("totaldownloads"); dt.columns.add("remainingvisitors"); // display each item of arraylist foreach (object row in myarraylist) { //add rows datatable , bind in grid view dr = dt.newrow(); dr["appimg"] = ((datarow)row)["appimg"].tostring(); dr["appname"] = ((datarow)row)["appname"].tostring(); dr["applink"] = ((datarow)row)["applink"].tostring(); dr["apptype"] = ((datarow)row)["apptype"].tostring(); dr["totalvisitors"] = "plan visitors: " + ((datarow)row)["totalvisitors"].tostring(); dr["totaldownloads"] = "downloaded: " + ((datarow)row)["totaldownloads"].tostring(); dr["remainingvisitors"] = "remaining visitors: " + ((datarow)row)["remainingvisitors"].tostring(); dt.rows.add(dr); } gridview1.datasource = dt; gridview1.databind(); } } } public arraylist convertdatasettoarraylist() { sqlconnection sqlcon = new sqlconnection(configurationmanager.connectionstrings["con"].tostring()); sqlcommand cmd = new sqlcommand(); if (session["userid"] != null && (session["usertypeid"] != null && convert.toint32(session["usertypeid"]) != 2)) { cmd.commandtext = "select * tblapp apptype = '" + session["userostype"] + "' order totalvisitors"; } else { cmd.commandtext = "select * tblapp order totalvisitors"; } cmd.connection = sqlcon; sqlcon.open(); cmd.executenonquery(); sqldataadapter da = new sqldataadapter(); da.selectcommand = cmd; dataset dsapp = new dataset(); da.fill(dsapp, "tblapp"); arraylist myarraylist = new arraylist(); foreach (datarow dtrow in dsapp.tables[0].rows) { myarraylist.add(dtrow); } sqlcon.close(); return myarraylist; } protected void gridview1_rowcommand(object sender, gridviewcommandeventargs e) { if (e.commandname == "download") { button ib = (button)e.commandsource; int index = convert.toint32(ib.commandargument); gridviewrow row = gridview1.rows[index]; label l2 = (label)row.findcontrol("label2"); label lbtotallvisitors = (label)row.findcontrol("label4"); label lbltotaldownloads = (label)row.findcontrol("label5"); label lblremainingvisitors = (label)row.findcontrol("label6"); string updatesql = "update tbluser set downloadedapps = '" + lbl + "', amount = '" + session["amount"] + "', totalamount='" + session["totalamount"] + "' id= '" + session["userid"] + "'"; using (sqlconnection sqlconn = new sqlconnection(configurationmanager.connectionstrings["con"].tostring())) { using (sqlcommand updatecommand = new sqlcommand(updatesql, sqlconn)) { sqlconn.open(); updatecommand.executenonquery(); updatecommand.connection.close(); } } response.redirect(l2.text); } }
update table set column = column + 1
Comments
Post a Comment