datagrid修改和删除

作者:admin 日期:2008-06-03

字体大小: 小中大

using Socut.Data;

public partial class news_edit : System.Web.UI.Page
{
    public CData myData = new CData();
    public DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        // 在此处放置用户代码以初始化页面
        string strID = Request["id"];
        ds = myData.GetDataSet("Select n_id,n_title,n_content FROM socut_news Where n_id='" + strID + "'", 0, 0, "dsTable");
        if (!Page.IsPostBack)//此句一定要加，否则无法更新
        {
            TextBox1.Text = ds.Tables["dsTable"].Rows[0][1].ToString();
            TextBox2.Text = ds.Tables["dsTable"].Rows[0][2].ToString();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strID = Request["id"];
        myData.GetExecuteNonQuery("Update socut_news SET n_title='" + TextBox1.Text + "',n_content='" + TextBox2.Text + "' Where n_id='" + strID + "'");
        Label1.Text = "更新成功！";
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string strID = Request["id"];
        myData.GetExecuteNonQuery("Delete FROM socut_news Where n_id='" + strID + "'");
        Label1.Text = "删除成功！";

    }
}