addressdetail.aspx.cs

收发邮件功能

using System;
using System.Collections;
using System.Configuration;
using System.Data;
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.Data.SqlClient;

public partial class AddressDetail : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bind_Address();
        }
    }

    void Bind_Address()
    {
        int id = Convert.ToInt32(Request.QueryString["id"].ToString());
        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        //创建数据库连接对象
        SqlConnection myconn = new SqlConnection(settings);
        myconn.Open();

        string strsql = "select * from AddressBook Where ID=" + id;
        SqlCommand myCommand = new SqlCommand(strsql, myconn);
        SqlDataReader dr = myCommand.ExecuteReader();
        if (dr.Read())
        {
            username.Text = dr["Name"].ToString();
            email.Text = dr["Email"].ToString();
            tel.Text = dr["Tel"].ToString();
            mobile.Text = dr["MobilePhone"].ToString();
            address.Text = dr["Address"].ToString();
            zipcode.Text = dr["ZipCode"].ToString();
            other.Text = dr["Other"].ToString();
        }
        myconn.Close();
    }

    protected void btn_mod_Click(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(Request.QueryString["id"].ToString());

        string name = username.Text;
        string mail = email.Text;
        string tele = tel.Text;
        string mob = mobile.Text;
        string useraddress = address.Text;
        string code = zipcode.Text;
        string bak = other.Text;
        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        //创建数据库连接对象
        SqlConnection myconn = new SqlConnection(settings);
        myconn.Open();
        string strsql = "update AddressBook Set Email=" + "'" + mail + "'";
        strsql = strsql + ",Name=" + "'" + name + "'";
        strsql = strsql + ",Tel=" + "'" + tele + "'";
        strsql = strsql + ",MobilePhone=" + "'" + mob + "'";
        strsql = strsql + ",Address=" + "'" + useraddress + "'";
        strsql = strsql + ",ZipCode=" + "'" + code + "'";
        strsql = strsql + ",Other=" + "'" + bak + "'";

        SqlCommand myCommand = new SqlCommand(strsql, myconn);
        myCommand.ExecuteNonQuery();
        myconn.Close();
        Response.Redirect("address.aspx");
    }
    protected void btn_back_Click(object sender, EventArgs e)
    {
        Response.Redirect("address.aspx");
    }
}