DataList控件使用代码

最新推荐文章于 2021-01-08 16:28:56 发布

wk122348545

最新推荐文章于 2021-01-08 16:28:56 发布

阅读量443

点赞数

分类专栏： Datalist 文章标签： textbox server dataset object asp string

本文链接：https://blog.csdn.net/wk122348545/article/details/2973919

版权

Datalist 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

html代码

说明:<%# DataBinder.Eval(Container.DataItem,"字段名",{0:格式符}%> 这是绑字源

以下是c#中的代码

protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            this.createdb();
        }
    }
    private void createdb()
    {
        SqlConnection scn = new SqlConnection("server=.;database=zhang;uid=sa;pwd=410");
        SqlDataAdapter adp = new SqlDataAdapter();
        adp.SelectCommand = new SqlCommand("select * from chang", scn);
        DataSet ds = new DataSet();
        adp.Fill(ds, "chang");
        this.DataList1.DataSource = ds.Tables["chang"].DefaultView;
        this.DataList1.DataKeyField = "changid";
        this.DataList1.DataBind();

    }
    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "select")
        {
            this.DataList1.SelectedIndex = e.Item.ItemIndex;
            this.createdb();
        }
    }
    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
    {
        this.DataList1.EditItemIndex = e.Item.ItemIndex;
        this.createdb();
    }
    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        string idd = DataList1.DataKeys[e.Item.ItemIndex].ToString();
        string txt = ((TextBox)e.Item.FindControl("TextBox1")).Text;
        SqlConnection cn = new SqlConnection("server=.;database=zhang;uid=sa;pwd=410");
        cn.Open();
        SqlCommand cm = new SqlCommand("update chang set chang1='" + txt + "' where changid='" + idd + "'", cn);
        cm.ExecuteNonQuery();
        cn.Close();
        this.DataList1.EditItemIndex = -1;
        this.createdb();