using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class UpdateProfile : System.Web.UI.Page { SqlConnection conn = null; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { divPatientUpdate.Visible = false; } } protected void btnCancel_Click(object sender, EventArgs e) { btnCancel.Enabled = true; } protected void btnEdit_Click(object sender, EventArgs e) { if (btnEdit.Text == "Edit") { txtZip.Enabled = true; txtLastName.Enabled = true; txtFirstName.Enabled = true; txtEmail.Enabled = true; txtContactNo.Enabled = true; txtAge.Enabled = true; rbtnFemale.Enabled = true; rbtnMale.Enabled = true; cmbCity.Enabled = true; cmbState.Enabled = true; btnEdit.Text = "Save"; } else { if (btnEdit.Text == "Save") { UpdateData(); } } } private void UpdateData() { SqlConnection conn = null; SqlCommand cmd = null; try { conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PConnStr"].ConnectionString); string sql = "Update Patient set P_FName=@fname,P_LName=@lname,Age=@age, State=@state ,City=@city ,Email_id=@email ,Sex=@sex ,ContactNo=@contactno, Zip=@zip where P_FName in(select UserName from Login where P_LName=UserName)"; conn.Open(); cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@fname", txtFirstName.Text); cmd.Parameters.AddWithValue("@lname", txtLastName.Text); cmd.Parameters.AddWithValue("@age", txtAge.Text); cmd.Parameters.AddWithValue("@state", cmbState.Text); cmd.Parameters.AddWithValue("@city", cmbCity.Text); cmd.Parameters.AddWithValue("@email", txtEmail.Text); cmd.Parameters.AddWithValue("@contactno", txtContactNo.Text); cmd.Parameters.AddWithValue("@zip", txtZip.Text); if (rbtnFemale.Checked) { cmd.Parameters.AddWithValue("@sex", rbtnFemale.Text); } else { cmd.Parameters.AddWithValue("@sex", rbtnMale.Text); } cmd.ExecuteNonQuery(); Label1.Visible = true; Label1.Text = "Updated Successfully"; } catch (Exception ex) { Label1.Text = ex.ToString(); Label1.Visible = true; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } protected void Button1_Click(object sender, EventArgs e) { SqlDataAdapter da = null; DataSet dsUser = null; SqlDataReader dr; try { conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PConnStr"].ConnectionString); conn.Open(); string sql = "Select * from Patient where P_FName=@fname AND P_LName=@lname"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@fname",T1.Text); cmd.Parameters.AddWithValue("@lname",T2.Text); dr = cmd.ExecuteReader(); if (dr.Read()) { txtAge.Text = dr[3].ToString(); txtContactNo.Text = dr[8].ToString(); txtEmail.Text = dr[6].ToString(); txtFirstName.Text = dr[1].ToString(); txtLastName.Text = dr[2].ToString(); txtZip.Text = dr[9].ToString(); cmbState.Text = dr[4].ToString(); cmbCity.Text = dr[5].ToString(); string m = dr[7].ToString(); if (m == "Male") { rbtnMale.Checked = true; } else { rbtnFemale.Checked = true; } divPatientUpdate.Visible = true; } else { Label3.Text = "This record does not exist"; Label3.Visible = true; } } catch (Exception ex) { Label3.Text = ex.ToString(); Label3.Visible = true; } } }
UPDATE ... WHERE ID = @id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)