c# - Saving to database, then reading from database, data is not there -


i have page, user can modify it's information. when page loads, fills in users information text input fields. can change information , hit save. data should saved database , should reflected in text fields, because of refresh. not save data. if remove reading of data, data saved when button clicked, when data reading there, data not saved.

this code in "read data" part, in page_load():

string loggedinuser = system.web.httpcontext.current.user.identity.name;     sqlconnection connectdb = new sqlconnection("data source=serverhere;initial catalog=cataloghere;user id=usernamehere;password=passwordhere;"); //opretter database connection string     sqldatareader inforeader = null;     sqlcommand getuserinfo = new sqlcommand("select firstname,lastname,age,city,contact,bio userinfo username = @username", connectdb);     getuserinfo.parameters.add("@username", loggedinuser);     connectdb.open();     inforeader = getuserinfo.executereader();     inforeader.read();     {         tbinfofirstname.text = inforeader["firstname"].tostring();         tbinfolastname.text = inforeader["lastname"].tostring();         tbinfoage.text = inforeader["age"].tostring();         tbinfocity.text = inforeader["city"].tostring();         tbinfokontakt.text = inforeader["contact"].tostring();         tbinfoabout.text = inforeader["bio"].tostring();     };     connectdb.close(); 

this code save button:

string loggedinuser = system.web.httpcontext.current.user.identity.name;      sqlconnection connectdb = new sqlconnection("data source=serverhere;initial catalog=cataloghere;user id=usernamehere;password=passwordhere;");      sqlcommand savepersoninfo = new sqlcommand("update userinfo set firstname = @firstname,lastname = @lastname,age = @age,city = @city,contact = @contact,bio = @bio username = @username", connectdb);     savepersoninfo.parameters.addwithvalue("@firstname", tbinfofirstname.text);      savepersoninfo.parameters.addwithvalue("@lastname", tbinfolastname.text);     savepersoninfo.parameters.addwithvalue("@age", tbinfoage.text);     savepersoninfo.parameters.addwithvalue("@city", tbinfocity.text);     savepersoninfo.parameters.addwithvalue("@contact", tbinfokontakt.text);     savepersoninfo.parameters.addwithvalue("@bio", tbinfoabout.text);     savepersoninfo.parameters.addwithvalue("@username", loggedinuser);       connectdb.open();      savepersoninfo.executenonquery();      //response.redirect("manage.aspx");      connectdb.close(); 

as said, save code works on it's own, not when reading code active, eg: not commented out.

i believe page_load event launched before event button on postback. in case reading taken old data again filling fields , recording old data again. have checked it?

if so, put code in page_load in if (ispostback!):

public void page_load() {     // ...      if (!ispostback) {         // code read data     } } 

Comments

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

How to show in django cms breadcrumbs full path? -

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -