Click here to Skip to main content
15,891,513 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi ,all . i have some textbox and i want update database clicking button. please elp me.thanks in advance.
here is my code
code behind...
C#
protected void Page_Load(object sender, EventArgs e)
        {
            Dictionary<string, string> dct = CUser.GetUserInfo();
            tbxFirstName.Text = dct["FirstName"];
            tbxLastName.Text = dct["LastName"];
            tbxEmail.Text = dct["Email"];
            tbxPhone.Text = dct["Phone"];
            tbxPassportNumber.Text = dct["PassportNumber"];
            tbxUsername.Text = dct["Username"];

            if (!Page.IsPostBack)
            {

            }
        }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            CUser cUser = new CUser();
            cUser.FirstName = tbxFirstName.Text;
            cUser.LastName = tbxLastName.Text;
            cUser.Phone = tbxPhone.Text;
            cUser.Email = tbxEmail.Text;
            cUser.Username = tbxUsername.Text;
            cUser.PassportNumber = tbxPassportNumber.Text;
            cUser.Attach();

            if (!cUser.Save())
            {

            }
        }
    }
}


this my methods...
C#
public bool Save()
 {
     try
     {
         using (var db = new MiniFootballEntities())
         {

             db.Users.AddObject(entity);
             db.SaveChanges();

             return true;
         }
     }
     catch (Exception err)
     {
         return false;

     }
 }
 public void Attach (User user)
 {
     using (var db = new MiniFootballEntities())
     {
         db.Users.Attach(user);
         db.SaveChanges();
     }
 }
 public static Dictionary<string, string> GetUserInfo()
 {
     try
     {
         using (var db = new MiniFootballEntities())
         {
             var data = db.Users.First();


             Dictionary<string, string> dct = new Dictionary<string, string>();

             dct.Add("FirstName", data.FirstName);
             dct.Add("LastName", data.LastName);
             dct.Add("Email", data.Email);
             dct.Add("Phone", data.Phone);
             dct.Add("PassportNumber", data.PassportNumber);
             dct.Add("Username", data.Username);
             return dct;
         }
     }
     catch (Exception err)
     {
         return null;
     }
 }
Posted
Updated 29-Oct-13 8:21am
v2
Comments
BulletVictim 30-Oct-13 3:56am    
What exactly is your problem?
From your current question I would say it is a standard SQL statement that needs tor be passed to the database.

Also just a note: only post the code in which you have the problem.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900