addaddress.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 AddAddress : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btn_add_Click(object sender, EventArgs e)
    {
        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 = "insert into AddressBook(Email,Name,MobilPhone,Tel,Address,ZipCode,Other)";
        strsql = strsql + "Values('" + mail + "','" + name + "','" + mob + "','" + tele + "','" + useraddress + "','" + code + "','" + bak + "')";

        SqlCommand myCommand = new SqlCommand(strsql, myconn);
        myCommand.ExecuteNonQuery();
        myconn.Close();
        Response.Redirect("address.aspx");
    }
   
}