admin/anewupdate.aspx.cs

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

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

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

public partial class anewupdate : System.Web.UI.Page
{
    public void Page_Load(Object Sender, EventArgs E)
    {
        if (!IsPostBack) BindGrid();
    }
    public void myGrid_Edit(Object sender, DataGridCommandEventArgs E)
    {
        myGrid.EditItemIndex = (int)E.Item.ItemIndex;
        BindGrid();
    }

    public void myGrid_Cancel(Object sender, DataGridCommandEventArgs E)
    {
        myGrid.EditItemIndex = -1;
        BindGrid();
    }

    public void myGrid_Update(Object sender, DataGridCommandEventArgs E)
    {
        string myCnn = ConfigurationSettings.AppSettings["Con"];
        SqlConnection Conn = new SqlConnection(myCnn);

        String CnStr = "update 新闻表 set 标题=@标题 where 编号=@SNO";

        SqlCommand cm = new SqlCommand(CnStr, Conn);
        cm.Parameters.Add(new SqlParameter("@标题", SqlDbType.Char));

        cm.Parameters["@标题"].Value = ((TextBox)E.Item.Cells[3].Controls[0]).Text;


        // 给参数赋值
        cm.Parameters.Add(new SqlParameter("@SNO", SqlDbType.Char));
        cm.Parameters["@SNO"].Value = myGrid.DataKeys[(int)E.Item.ItemIndex];
        // 打开连接
        cm.Connection.Open();
        try
        {
            cm.ExecuteNonQuery();
            label1.Text = "信息修改成功";
        }
        catch (SqlException)
        {
            label1.Text = "修改失败";
            label1.Style["color"] = "red";
        }
        cm.Connection.Close();
        BindGrid();