001.using System;
002.using System.Collections.Generic;
003.using System.Linq;
004.using System.Web;
005.using System.Web.UI;
006.using System.Web.UI.WebControls;
007.using System.Data;
008.using System.Data.SqlClient;
009.using System.Text;
010.
011.namespace AspNetMember
012.{
013. public partial class frmUpdateProfile : System.Web.UI.Page
014. {
015. protected void Page_Load(object sender, EventArgs e)
016. {
017.
018. if (Convert.ToString(Session["strUsername"]) == "")
019. {
020. Response.Redirect("frmLogin.aspx");
021. Response.End();
022. }
023.
024. this.pnlProfile.Visible = true;
025. this.pnlFinish.Visible = false;
026.
027. if (!Page.IsPostBack)
028. {
029. ShowDataInfo();
030. }
031. }
032.
033. protected void ShowDataInfo()
034. {
035. SqlConnection objConn = null;
036. string strConnString = null;
037. StringBuilder strSQL = default(StringBuilder);
038. SqlCommand objCmd = null;
039. SqlDataReader dtReader = null;
040.
041.
042. strConnString = "Data Source=JUNE-PC;Initial Catalog=mydatabase;Integrated Security=True";
043. objConn = new SqlConnection();
044. objConn.ConnectionString = strConnString;
045. objConn.Open();
046.
047.
048.
049. strSQL = new StringBuilder();
050. strSQL.Append(" SELECT * FROM membergun ");
051. strSQL.Append(" WHERE Username = @sUsername ");
052. objCmd = new SqlCommand(strSQL.ToString(), objConn);
053. objCmd.Parameters.Add("@sUsername", SqlDbType.VarChar).Value = Session["strUsername"];
054. dtReader = objCmd.ExecuteReader();
055.
056. if (dtReader.HasRows)
057. {
058. dtReader.Read();
059. this.lblUsername.Text = dtReader["Username"].ToString();
060. this.txtName.Text = dtReader["Name"].ToString();
061. this.txtAge.Text = dtReader["Age"].ToString();
062. this.txtVocation.Text = dtReader["Vocation"].ToString();
063. this.txtWorkplace.Text = dtReader["Workplace"].ToString();
064. this.txtAddress.Text = dtReader["Address"].ToString();
065. this.txtPhone.Text = dtReader["Phone"].ToString();
066. this.txtEmail.Text = dtReader["Email"].ToString();
067.
068. }
069.
070. dtReader.Close();
071. objConn.Close();
072. objConn = null;
073.
074. }
075.
076. protected void btnUpdate_Click(object sender, EventArgs e)
077. {
078. SqlConnection objConn = null;
079. string strConnString = null;
080. StringBuilder strSQL = default(StringBuilder);
081. SqlCommand objCmd = null;
082. int intCount = 0;
083.
084.
085. strConnString = "Data Source=JUNE-PC;Initial Catalog=mydatabase;Integrated Security=True";
086. objConn = new SqlConnection();
087. objConn.ConnectionString = strConnString;
088. objConn.Open();
089.
090.
091. strSQL = new StringBuilder();
092. strSQL.Append(" SELECT COUNT(*) FROM membergun ");
093. strSQL.Append(" WHERE Email = @sEmail AND Username <> @sUsername");
094. objCmd = new SqlCommand(strSQL.ToString(), objConn);
095. objCmd.Parameters.Add("@sEmail", SqlDbType.VarChar).Value = this.txtEmail.Text;
096. objCmd.Parameters.Add("@sUsername", SqlDbType.VarChar).Value = Session["strUsername"];
097. intCount = (int)objCmd.ExecuteScalar();
098. if (intCount >= 1)
099. {
100. this.lblStatus.ForeColor = System.Drawing.Color.Red;
101. this.lblStatus.Text = "Email already exists!!";
102. return;
103. }
104.
105.
106. strSQL = new StringBuilder();
107. strSQL.Append(" UPDATE membergun ");
108. strSQL.Append(" SET Password = @sPassword ");
109. strSQL.Append(" ,Name = @sName ");
110. strSQL.Append(" ,Age = @sAge ");
111. strSQL.Append(" ,Vocation = @sVocation ");
112. strSQL.Append(" ,Workplace = @sWorkplace ");
113. strSQL.Append(" ,Address = @sAddress ");
114. strSQL.Append(" ,Phone = @sPhone ");
115. strSQL.Append(" ,Email = @sEmail ");
116. strSQL.Append(" WHERE Username = @sUsername");
117. objCmd = new SqlCommand(strSQL.ToString(), objConn);
118. objCmd.Parameters.Add("@sPassword", SqlDbType.VarChar).Value = this.txtPassword.Text;
119. objCmd.Parameters.Add("@sName", SqlDbType.VarChar).Value = this.txtName.Text;
120. objCmd.Parameters.Add("@sAge", SqlDbType.VarChar).Value = this.txtAge.Text;
121. objCmd.Parameters.Add("@sVocation", SqlDbType.VarChar).Value = this.txtVocation.Text;
122. objCmd.Parameters.Add("@sWorkplace", SqlDbType.VarChar).Value = this.txtWorkplace.Text;
123. objCmd.Parameters.Add("@sAddress", SqlDbType.VarChar).Value = this.txtAddress.Text;
124. objCmd.Parameters.Add("@sPhone", SqlDbType.VarChar).Value = this.txtPhone.Text;
125. objCmd.Parameters.Add("@sEmail", SqlDbType.VarChar).Value = this.txtEmail.Text;
126. objCmd.Parameters.Add("@sUsername", SqlDbType.VarChar).Value = Session["strUsername"];
127. objCmd.ExecuteNonQuery();
128.
129. objConn.Close();
130. objConn = null;
131.
132. this.pnlProfile.Visible = false;
133. this.pnlFinish.Visible = true;
134. }
135.
136. protected void txtAge_TextChanged(object sender, EventArgs e)
137. {
138.
139. }
140. }
141.}
Quote:
