CODEWITHSUNDEEP
asp.netlistview
user3339242
user3339242

Reputation: 641

Exit ListView Update Mode after clicking button

I currently am using a listview to edit and update data. When I click edit it goes into the edit format that I want it to. I want to be able to exit the entire edit mode after the update button is clicked. Is this possible?

When I use ListView1.EditIndex = -1 it doesn't go back to the regular view.

protected void ListView1_ItemUpdating(object sender, ListViewUpdateEventArgs e)
    {
        updateButton = true;
        ListViewItem lvl = ListView1.Items[e.ItemIndex];
        var formTitleListBox = (ListBox)lvl.FindControl("ListBox1");
        var controlTypeListBox = (ListBox)lvl.FindControl("ControlType");
        var formSectionListBox = (ListBox)lvl.FindControl("formsection");
        var sortOrderTextBox = (TextBox)lvl.FindControl("SortOrderTextBox");
        var subsectionListBox = (ListBox)lvl.FindControl("subsection");
        var subSectionTextBox = (TextBox)lvl.FindControl("SubSectionOrderTextBox");
        var sectionItemListBox = (ListBox)lvl.FindControl("sectionitem");
        var sectionSortOrderTextBox = (TextBox)lvl.FindControl("SectionSortOrderTextBox");
        var validationRuleListBox = (ListBox)lvl.FindControl("RuleDesc");
        var crossItemListBox = (ListBox)lvl.FindControl("CrossItem");

        var hiddenID = (HiddenField)lvl.FindControl("HiddenPrimaryID");

        using (SqlConnection connection = new SqlConnection("Data Source=RCK-HRSA-DB01;Initial Catalog=ORHP_Dev03182014;User ID=ohitrural;Password=0h!trural"))
        {
            try
            {
                SqlCommand cmd1 = new SqlCommand("UPDATE ORHP_Dev03182014.Core.Form_Section_SubSection_Item_Rel SET FormID = @FormTitle, FormSectionID = @FormSection, SubSectionID = @SubSection, SectionItemID = @SectionItem, SortOrder = @SortOrder, SectionSortOrder = @SectionSortOrder, SubSectionSortOrder = @SubSectionSortOrder, ValidationRulesetId = @RuleDesc, ControlTypeID = @ControlType, CrossItemID = @CrossItem WHERE DataCollectionPeriodID = " + DropDownList2.SelectedValue + " AND FormSectionSubSectionItemRelID = @FormSectionSubSectionID");
                connection.Open();
                cmd1.Connection = connection;
                cmd1.CommandType = CommandType.Text;
                cmd1.Parameters.AddWithValue("@FormTitle", formTitleListBox.SelectedValue);
                cmd1.Parameters.AddWithValue("@ControlType", DbNullIfNull(controlTypeListBox.SelectedValue));
                cmd1.Parameters.AddWithValue("@FormSection", formSectionListBox.SelectedValue);
                cmd1.Parameters.AddWithValue("@SortOrder", DbNullIfNull(sortOrderTextBox.Text));
                cmd1.Parameters.AddWithValue("@SubSection", subsectionListBox.SelectedValue);
                cmd1.Parameters.AddWithValue("@SubSectionSortOrder", DbNullIfNull(subSectionTextBox.Text));
                cmd1.Parameters.AddWithValue("@SectionItem", sectionItemListBox.SelectedValue);
                cmd1.Parameters.AddWithValue("@SectionSortOrder", DbNullIfNull(sectionSortOrderTextBox.Text));
                cmd1.Parameters.AddWithValue("@RuleDesc", DbNullIfNull(validationRuleListBox.SelectedValue));
                cmd1.Parameters.AddWithValue("@CrossItem", DbNullIfNull(crossItemListBox.SelectedValue));
                cmd1.Parameters.AddWithValue("@FormSectionSubSectionID", hiddenID.Value);
                cmd1.ExecuteNonQuery();
                SqlDataAdapter dt = new SqlDataAdapter(cmd1);
                DataSet ds = new DataSet();
                searchDS = new DataSet();
                dt.Fill(ds);
                searchDS = ds;




                UpdatePanel1.Update();
                ListView1.DataSource = searchDS;                
                ListView1.EditIndex = -1;
                ListView1.DataBind();
                e.Cancel = true;


            }
            catch (Exception ex)
            {

            }



        }
    }

Upvotes: 0

Views: 622

Answers (1)

Tim Schmelter
Tim Schmelter

Reputation: 460238

Add ListView1.DataBind(); and also e.Cancel = true;.

// ...
cmd1.ExecuteNonQuery();
ListView1.EditIndex = -1;
ListView1.DataBind()
e.Cancel = true;
// ...

Side-note: remove the empty catch if you want to notice if something goes wrong.

Upvotes: 1

Related Questions