c# - List view cannot get user info from session -

c# - List view cannot get user info from session -

i have created in login form session usrnme user name. binds listviews , gridviews in user panel page depending on usrnme session. if current user logs in username work normally, in registration form after new user registers, page shows nothing, user name. have created session in registration form collect info of user , bind listviews depending on new user name doesn't work.

here login form codebehind:

protected void loginbtn_click(object sender, eventargs e) { sqlconnection log = new sqlconnection(configurationmanager.connectionstrings["beravaconnectionstring"].connectionstring); log.open(); string checkuser = "select count(*) userinfo uid='" + usrnamlogintxtbx.text + "'"; sqlcommand cmd = new sqlcommand(checkuser, log); int temp = convert.toint32(cmd.executescalar().tostring()); log.close(); if (temp == 1) { log.open(); string checkpasswordquery = "select password userinfo uid='" + usrnamlogintxtbx.text + "'"; sqlcommand passcom = new sqlcommand(checkpasswordquery, log); string password = passcom.executescalar().tostring().replace(" ",""); if (password == usrnamloginpassbx.text) { session["usrnme"] = usrnamlogintxtbx.text; response.redirect("user panel.aspx"); } else { passwronglbl.text = "password incorrect"; } } else { wronglogusernamelbl.text = "invalid user name"; } }

here registration form:

string sc = configurationmanager.connectionstrings["beravaconnectionstring"].connectionstring.tostring(); protected void page_load(object sender, eventargs e) { if (!page.ispostback) { datatable countrycascd = new datatable(); using (sqlconnection con = new sqlconnection(configurationmanager.connectionstrings["beravaconnectionstring"].connectionstring)) { sqldataadapter adaptar = new sqldataadapter("select [countryid],[country] [countr]", con); adaptar.fill(countrycascd); countrdrdolst.datasource = countrycascd; countrdrdolst.datatextfield = "country"; countrdrdolst.datavaluefield = "countryid"; countrdrdolst.databind(); } countrdrdolst.items.insert(0, new listitem("välj land", "0")); } } protected void btnsave_click(object sender, eventargs e) { sqlconnection cn = new sqlconnection(sc); sqlcommand cmd = new sqlcommand(); string sqlstatment = "insert userinfo (uid, fn, ln, password, repass, email,country, state,city, post, img, logo,regdate) values (@uid,@fn,@ln,@password,@repass,@email,@country,@state,@city,@post,@img,@logo,@regdate)"; cmd.connection = cn; cmd.commandtype = commandtype.text; cmd.commandtext = sqlstatment; //insert parameters first cmd.parameters.addwithvalue("@uid", usrnme.text); cmd.parameters.addwithvalue("@fn", fnbox.text); cmd.parameters.addwithvalue("@ln", lnamebox.text); cmd.parameters.addwithvalue("@password", passtxtbx1.text); cmd.parameters.addwithvalue("@repass", passtxtbx2.text); cmd.parameters.addwithvalue("@email", emailbox.text); cmd.parameters.addwithvalue("@country", countrdrdolst.selecteditem.text); cmd.parameters.addwithvalue("@state", statedrdolst.selecteditem.text); cmd.parameters.addwithvalue("@city", citiesdrdolst.selecteditem.text); cmd.parameters.addwithvalue("@post", postbox.text); cmd.parameters.addwithvalue("@img", persimgfileupload1.filename); cmd.parameters.addwithvalue("@logo", logofileupload.filename); //get current date time here cmd.parameters.addwithvalue("@regdate", datetime.now); if (!string.isnullorempty(usrnme.text)) { lblcheckusername.text = "user name exist"; lblcheckusername.forecolor = system.drawing.color.red; } else { lblcheckusername.text = "user name available"; lblcheckusername.forecolor = system.drawing.color.green; } if (persimgfileupload1.hasfile) { persimgfileupload1.saveas(server.mappath("~/images/users/" + persimgfileupload1.filename)); } if (logofileupload.hasfile) { logofileupload.saveas(server.mappath("~/images/logos/" + logofileupload.filename)); } sqldataadapter advertisement = new sqldataadapter(cmd); dataset ds = new dataset(); ad.selectcommand = cmd; ad.fill(ds); response.redirect("user panel.aspx"); } protected void usrnme_textchanged(object sender, eventargs e) { session["usrnmereg"] = usrnme.text; }

here user panel codebehind:

protected void page_load(object sender, eventargs e) { if (session["usrnme"] != null) { usrnmelbl.text = session["usrnme"].tostring(); using (sqlconnection userlistview = new sqlconnection(sc)) { // open connection userlistview.open(); // build info adapter sqldataadapter userinfoda = new sqldataadapter("select * [userinfo] ([uid] = @uid)", sc); // grab location (guaranteed exist above if-statement string usrnme = convert.tostring(session["usrnme"]); // add together parameters info adapter userinfoda.selectcommand.parameters.addwithvalue("@uid", usrnme); // define info set dataset userinfods = new dataset(); // fill info set userinfoda.fill(userinfods); // bind results userinfo.datasource = userinfods.tables[0]; userinfo.databind(); } } else { return; } } protected void addadsbtn_click(object sender, eventargs e) { guid newguid = guid.newguid(); sqlconnection cn = new sqlconnection(sc); sqlcommand cmd = new sqlcommand(); string sqlstatment = "insert [ads] ([section], [category], [uid], [adstit], [adsdesc], [country], [state], [city], [adsprice], [img1], [img2], [img3], [img4], [img5], [wtags]) values (@section, @category, @uid, @adstit, @adsdesc, @country, @state, @city, @adsprice, @img1, @img2, @img3, @img4, @img5, @wtags)"; cmd.connection = cn; cmd.commandtype = commandtype.text; cmd.commandtext = sqlstatment; //insert parameters first cmd.parameters.addwithvalue("@section", catedrdoads.selecteditem.text); cmd.parameters.addwithvalue("@category", subcatedrdoads.selecteditem.text); cmd.parameters.addwithvalue("@uid", usrnmelbl.text); cmd.parameters.addwithvalue("@adstit", addadstittxtbx.text); //cmd.parameters.addwithvalue("@adsdesc", editor1.text); cmd.parameters.addwithvalue("@country", countrdrdolst.selecteditem.text); cmd.parameters.addwithvalue("@state", statedrdolst.selecteditem.text); cmd.parameters.addwithvalue("@city", citiesdrdolst.selecteditem.text); cmd.parameters.addwithvalue("@adsprice", adsaddpristxtbx.text); cmd.parameters.addwithvalue("@img1", fileupload1.filename); cmd.parameters.addwithvalue("@img2", fileuploadimg2.filename); cmd.parameters.addwithvalue("@img3", fileuploadimg3.filename); cmd.parameters.addwithvalue("@img4", fileuploadimg4.filename); cmd.parameters.addwithvalue("@img5", fileuploadimg5.filename); cmd.parameters.addwithvalue("@wtags", addadswtagtxtbtn.text); sqldataadapter advertisement = new sqldataadapter(cmd); dataset ds = new dataset(); ad.selectcommand = cmd; ad.fill(ds); response.redirect("user panel.aspx"); }

i think understood problem right. in registration page have code, sets user name in session. why have "usrnmereg" instead of "usrnme"?. session key refering in user panel code.

protected void usrnme_textchanged(object sender, eventargs e) { session["usrnmereg"] = usrnme.text; }

i think need phone call next line of code, in btnsave_click event before redirecting user panel page

session["usrnme"] = usrnme.text

c# asp.net session