AddressAdd.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace AddressList
{
    public partial class AddressAdd : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (this.Session["userId"] == null)
                Response.Redirect("Default.aspx");
        }

        protected void btnBack_Click(object sender, EventArgs e)
        {
            Response.Redirect("AddressList.aspx");
        }

        protected void butAdd_Click(object sender, EventArgs e)
        {
            //SqlConnection conn = new SqlConnection();
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DBConnectionString"]);
            SqlCommand insertCmd = new SqlCommand("insert into AddressLists(userId,frdName,frdPhone,frdMobilePhone,frdAddress,frdEmail,frdQQ) values(@userId,@Name,@Phone,@MobilePhone,@Address,@Email,@QQ)", conn);
            insertCmd.Parameters.Add("@userId", SqlDbType.VarChar, 100);
            insertCmd.Parameters.Add("@Name", SqlDbType.VarChar, 100);
            insertCmd.Parameters.Add("@Phone", SqlDbType.VarChar, 100);
            insertCmd.Parameters.Add("@MobilePhone", SqlDbType.VarChar, 100);
            insertCmd.Parameters.Add("@Address", SqlDbType.VarChar, 400);
            insertCmd.Parameters.Add("@Email", SqlDbType.VarChar, 200);
            insertCmd.Parameters.Add("@QQ", SqlDbType.VarChar, 100);
            insertCmd.Parameters["@userId"].Value = Session["userId"].ToString();
            //insertCmd.Parameters["@Name"].Value = txtName.Text;
            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("<script language=javascript>alert('成功添加好友记录！');window.location.href='AddressList.aspx'</script>");
                }
                else
                {
                    Response.Write("<script language=javascript>alert('添加好友记录失败，查看输入是否正确！')</script>");
                }