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();
}
}
运行如图:
就这样了!!!!^_^ ^_^