admin/mail/mail.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;

namespace web.admin.mail
{
    public partial class mail : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

                    using (DataTable dt = new AcsHelper().ExecuteDataTable("select * from mail where id=1"))
                    {
                        foreach (DataRow r in dt.Rows)
                        {
                            this.TextBox1.Text = r["f_username"].ToString();
                            this.TextBox2.Text = r["f_password"].ToString();
                            this.TextBox3.Text = r["f_smtp"].ToString();
                            this.TextBox4.Text = r["j_username"].ToString();
                        }
                    }

            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string t1 = this.TextBox1.Text;
            string t2 = this.TextBox2.Text;
            string t3 = this.TextBox3.Text;
            string t4 = this.TextBox4.Text;

            string sqlstring = "update [mail] set f_username=@f_username,f_password=@f_password,f_smtp=@f_smtp,j_username=@j_username where id = 1";
            OleDbParameter[] op = new OleDbParameter[] { 
                    new OleDbParameter("@f_username",t1),
                    new OleDbParameter("@f_password",t2),
                    new OleDbParameter("@f_smtp",t3),
                    new OleDbParameter("@j_username",t4),
                };
            int a = new AcsHelper().ExecuteNonQuery(sqlstring, op);
            if (a > 0)
            {
                Response.Write("<script>alert('修改成功！');location.href='" + Request.RawUrl + "';</script>");
            }
        }
    }
}