DataList 控件具体用法 (下)

来源：互联网发布：开发java web最快的ide 编辑：程序博客网时间：2024/04/27 14:59

7．看到上面的事件了吗。下面要做的任务就是写这些事件

protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)

{

DataList1.EditItemIndex = e.Item.ItemIndex;

dataBindToDataList();

}

protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)

{

DataList1.EditItemIndex = -1;

dataBindToDataList();

}

protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)

{

string auid = Convert.ToString (DataList1.DataKeys[e.Item.ItemIndex]);

string phone = ((TextBox)e.Item.FindControl("txtphone")).Text;

SqlConnection con = data.Getcon();

con.Open();

SqlCommand cmd = new SqlCommand("update authors set phone='"+phone+"'where au_id='"+auid+ "' ",con);

cmd.ExecuteNonQuery();

DataList1.EditItemIndex = -1;

dataBindToDataList();

}

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)

{

string auid = Convert.ToString(DataList1.DataKeys[e.Item.ItemIndex]);

SqlConnection con = data.Getcon();

con.Open();

SqlCommand cmd = new SqlCommand("Delete from authors where au_id='" + auid + "' ", con);

cmd.ExecuteNonQuery();

DataList1.EditItemIndex = -1;

dataBindToDataList();

}

运行如图:

就这样了!!!!^_^ ^_^　