如何在asp.net C#中的两个列表之间拖放后更新sql数据库？

// 数据库连接字符串
string connectionString = "YourConnectionString";

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // 绑定源列表和目标列表
        BindSourceList();
        BindTargetList();
    }
}

protected void BindSourceList()
{
    // 从数据库获取源列表数据
    DataTable sourceData = GetDataFromDatabase("SELECT * FROM SourceTable");

    // 将数据绑定到源列表
    sourceList.DataSource = sourceData;
    sourceList.DataBind();
}

protected void BindTargetList()
{
    // 从数据库获取目标列表数据
    DataTable targetData = GetDataFromDatabase("SELECT * FROM TargetTable");

    // 将数据绑定到目标列表
    targetList.DataSource = targetData;
    targetList.DataBind();
}

protected void sourceList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    {
        // 添加拖放事件处理程序
        string dragScript = "drag(event)";
        e.Item.Attributes.Add("draggable", "true");
        e.Item.Attributes.Add("ondragstart", dragScript);
    }
}

protected void targetList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    {
        // 添加拖放事件处理程序
        string dropScript = "drop(event)";
        e.Item.Attributes.Add("ondragover", "allowDrop(event)");
        e.Item.Attributes.Add("ondrop", dropScript);
    }
}

protected void targetList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
    if (e.CommandName == "Delete")
    {
        // 获取要删除的项的ID
        int itemId = Convert.ToInt32(e.CommandArgument);

        // 从数据库删除项
        DeleteItemFromDatabase(itemId);

        // 重新绑定目标列表
        BindTargetList();
    }
}

protected void SaveChangesButton_Click(object sender, EventArgs e)
{
    // 保存更改到数据库
    SaveChangesToDatabase();

    // 重新绑定列表
    BindSourceList();
    BindTargetList();
}

private DataTable GetDataFromDatabase(string query)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        using (SqlCommand command = new SqlCommand(query, connection))
        {
            connection.Open();
            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataTable dataTable = new DataTable();
            adapter.Fill(dataTable);
            return dataTable;
        }
    }
}

private void DeleteItemFromDatabase(int itemId)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        using (SqlCommand command = new SqlCommand("DELETE FROM TargetTable WHERE ID = @ID", connection))
        {
            command.Parameters.AddWithValue("@ID", itemId);
            connection.Open();
            command.ExecuteNonQuery();
        }
    }
}

private void SaveChangesToDatabase()
{
    // 遍历目标列表中的项，更新数据库
    foreach (RepeaterItem item in targetList.Items)
    {
        int itemId = Convert.ToInt32(((HiddenField)item.FindControl("itemId")).Value);
        string itemName = ((Label)item.FindControl("itemName")).Text;
        string itemDescription = ((Label)item.FindControl("itemDescription")).Text;

        // 更新数据库中的项
        UpdateItemInDatabase(itemId, itemName, itemDescription);
    }
}

private void UpdateItemInDatabase(int itemId, string itemName, string itemDescription)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        using (SqlCommand command = new SqlCommand("UPDATE TargetTable SET Name = @Name, Description = @Description WHERE ID = @ID", connection))
        {
            command.Parameters.AddWithValue("@Name", itemName);
            command.Parameters.AddWithValue("@Description", itemDescription);
            command.Parameters.AddWithValue("@ID", itemId);
            connection.Open();
            command.ExecuteNonQuery();
        }
    }
}