admingl/zcxy.aspx.cs

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

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

public partial class admingl_zcxy : System.Web.UI.Page
{
    SqlServer.SqlServerManager DB = new SqlServer.SqlServerManager();
    string sql = "";
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            sql = "select * from T_canshu ";
            DataTable dt = DB.GetTable(sql);
            if (dt.Rows.Count > 0)
            {
                content1.Value = dt.Rows[0]["zcxy"].ToString();
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        StringBuilder strSql = new StringBuilder();
        strSql.Append("update T_canshu set ");
        strSql.Append("zcxy=@zcxy");
        SqlParameter[] parameters = {					
					new SqlParameter("@zcxy", SqlDbType.Text)};
        parameters[0].Value = content1.Value;
        DB.ExecuteSql(strSql.ToString(), parameters);
        SqlServer.Message.Show(this, "设置成功");
    }
}