using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;

public?partial?class?AddressAdd?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（this.Session[“userID“]==?null）
????????{
????????????Response.Redirect（“Login.aspx“）;
????????}
????}
????protected?void?btnBack_Click（object?sender?EventArgs?e）
????{
????????Response.Redirect（“AddressList.aspx“）;
????}
????protected?void?btnSubmit_Click（object?sender?EventArgs?e）
????{
????????SqlConnection?conn?=?new?SqlConnection（ConfigurationManager.AppSettings[“DBConnectionString“]）;
????????SqlCommand?insertCmd?=?new?SqlCommand（“insert?into?AddressLists（userIdfrdNamefrdPhonefrdMobilePhonefrdAddressfrdEmailfrdQQ）?values（@userId@Name@Phone@MobilePhone@Address@Email@QQ）“?conn）;
????????insertCmd.Parameters.Add（“@userId“?SqlDbType.VarChar?15）;????????
????????insertCmd.Parameters.Add（“@Name“?SqlDbType.VarChar?10）;????????
????????insertCmd.Parameters.Add（“@Phone“?SqlDbType.VarChar?15）;
????????insertCmd.Parameters.Add（“@MobilePhone“?SqlDbType.VarChar?11）;????????
????????insertCmd.Parameters.Add（“@Address“?SqlDbType.VarChar?200）;
????????insertCmd.Parameters.Add（“@Email“?SqlDbType.VarChar?50）;
????????insertCmd.Parameters.Add（“@QQ“?SqlDbType.VarChar?15）;
????????insertCmd.Parameters[“@userId“].Value?=?Session[“userID“].ToString（）;
????????insertCmd.Parameters[“@Name“].Value?=?txtName.Text;
????????insertCmd.Parameters[“@Phone“].Value?=?txtUtel2.Text;
????????insertCmd.Parameters[“@MobilePhone“].Value?=?txtUtel3.Text;????????
????????insertCmd.Parameters[“@Address“].Value?=?txtUaddr.Text;
????????insertCmd.Parameters[“@Email“].Value?=?txtUemail.Text;
????????insertCmd.Parameters[“@QQ“].Value?=?txtUQQ.Text;
????????try
????????{
????????????conn.Open（）;
????????????int?flag?=?insertCmd.ExecuteNonQuery（）;
????????????if?（flag?>?0）
????????????{
????????????????Response.Write（“ript?language=javascript>alert（‘成功添加好友記錄！‘）ript>“）;
????????????}
????????????else
????????????{
????????????????Response.Write（“ript?language=javascript>alert（‘添加好友記錄失敗，查看輸入是否正確！‘）ript>“）;
????????????}
????????}
????????catch?（System.Exception?ee）
????????{
????????????Response.Write（“ript?language=javascript>alert（‘“?+?ee.Message.ToString（）?+?“‘）ript>“）;
????????}
????????finally
????????{
????????????conn.Close（）;
????????}
????}
}