예제 #1
0
    public void BindDate()
    {
        //绑定歌曲类型到下拉文本框
        BLL.T_Style BllStyle = new T_Style();
        DropDownList1.DataSource     = BllStyle.select().Tables[0];
        DropDownList1.DataTextField  = "Style";
        DropDownList1.DataValueField = "Id";
        DropDownList1.DataBind();

        //绑定歌手姓名到下拉文本框
        BLL.T_Singer BllSinger = new T_Singer();
        DpDSinger.DataSource     = BllSinger.select().Tables[0];
        DpDSinger.DataTextField  = "Name";
        DpDSinger.DataValueField = "Id";
        DpDSinger.DataBind();
    }
예제 #2
0
    protected void GVSinger_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        BLL.T_Singer SingerBll = new T_Singer();

        if (SingerBll.Select(Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text)).Tables[0].Rows.Count > 0)
        {
            S_Id.Value      = SingerBll.Select(Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text)).Tables[0].Rows[0][0].ToString();
            SingerName.Text = SingerBll.Select(Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text)).Tables[0].Rows[0][1].ToString();
            //SingerSex.SelectedValue = SingerBll.Select(Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text)).Tables[0].Rows[0][2].ToString();
            Add.Visible    = false;
            Update.Visible = true;
        }
        else
        {
            Response.Write("No Date");
        }
    }
예제 #3
0
    protected void GVSinger_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Model.T_Singer Singer    = new Model.T_Singer();
        BLL.T_Singer   SingerBll = new T_Singer();

        //Singer.Id = Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text);
        Singer.Id = Convert.ToInt32(SingerBll.Select(Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text)).Tables[0].Rows[0][0].ToString());


        if (SingerBll.Delete(Singer))
        {
            Response.Write("DONE");
            BindDate();
        }
        else
        {
            Response.Write("FAILURE");
        }
    }