hi,

I am using GridView and XmlDataSource to display and edit XML file.

The error happen while i am in the update event handler (OnRowUpdating).

I notice that the error happen even if there is noting in the event handler.

I have no idea what the problem is.

TIA

can someone  help here please.

TIA

The XmlDataSource does not support updating. Of the data sources that ship with ASP.net 2.0 only SqlDataSource and ObjectDataSource support insert/update/delete.

 

Thanks,

Eilon

 

In the msdn Microsoft say it can.

http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.xmldatasource.aspx

The XmlDataSource can return XmlDataDocument and it also have Save function.

This is very strange error i have here.

i am getting the error even if the function is empty , but while i am adding

 Response.Write("someText");

Response.End();

I am getting no error.

While i am removing the Response.End(); i am getting the error again.

TIA

I'm sorry, what I meant was that the data source does not support automatic insert/update/delete through its IDataSourceControl/DataSourceView interfaces, which is what GridView uses. What you can do is handle the GridView's RowUpdating event, manually update the XML data in the XmlDataSource by calling GetXmlDocument(), call the Save() method, and finally cancel the RowUpdating event (so that the GridView doesn't try to make the data source do an automatiac update).

The reason you don't get an error when you call Response.End() is that it does exactly that - it ends the response - so the XmlDataSource never has a chance to throw its exception.

Thanks,

Eilon

If you use an XmlDataSource control and added an Update command button to update the Row, you will get the NotSupported exception because the GridView will call the Update method of the XmlDataSource's XmlDataSourceView. The XmlDataSource don't support updates and of that reason the XmlDataSourceView's Update method will throw the NotSupported Exception.

To remove the exception you have to cancel the RowUpdate by setting the event argument's Cancel property to true. By doing that the XmlDataSourceView's Update method will not be called.

The only way to update the document when you use the XmlDataSource is to add the update logic to the RowUpdating event by your self (You need to handle the update). I have an example on my blog where I use the XmlDataSource to update the XML document; it can probably give you some idea:

 http://fredrik.nsquared2.com/viewpost.aspx?PostID=270

What you can do is handle the GridView's RowUpdating event, manually update the XML data in the XmlDataSource by calling GetXmlDocument(), call the Save() method,

I did exactly that

and finally cancel the RowUpdating event (so that the GridView doesn't try to make the data source do an automatiac update).

Can you explain how can i do it?

TIA

 

Hello.

I think I have solution for you. Please review my .Net 2.0 Updatable Xml DataSource. It is updatabale XmlDataSource implemenation. This mean that it support automatic inserting, updating and deleting. As bonus it supports paging and sorting.

I will check out Mikes Updatable Xml DataSource control.  But I'd like the answer to this question as well.  I am handeling the RowUpdated event myself, but I still get the "Specified method is not supported" error.  Do I maybe need to also handle the RowUpdating event as well?  And what is this about ... "cancel the RowUpdate by setting the event argument's Cancel property to true".  I don't see any way of manipulating event arguments.  Please help us understand that better.  Thanks.

Protected Sub gv1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gv1.RowUpdating
    ' code for updating row manually goes here
End Sub

Protected Sub gv1_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles gv1.RowUpdated
    ' this prevents the error "Specified method is not supported." from being displayed.
    e.ExceptionHandled = True
End Sub

"cancel the RowUpdate by setting the event argument's Cancel property to true".

I guess that should be something like "set the event's ExceptionHandled property to True."

Hi all,

I think there's a slightly simpler way of doing this...

 

We must handle the RowUpdating event of the GridView, as the XMLDataSource doesn't fully support updating, so...

 

 

Protected Sub gv1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles resourcesGridView.RowUpdating

' Your update code goes here.

' So the row doesn't display in edit mode...
	resourcesGridView.EditIndex = -1
' Cancel the event, so the grid view doesn't try to make the data source do an auto update, and we avoid the 'method not supported error'...
	e.Cancel = True

End Sub

Cheers,

Tony 

 
 

Hi

I tried to use TemplateField instead using CommandField then it removed the error because it avoid calling method from XMLDataSource.

This is my sample code. For CommandName  attribute, do not use "Edit", "Update" or "Cancel" because it will try to call specified method  from XMLDataSource and will give Error.

<asp:TemplateField HeaderText = "Options">
         <ItemTemplate>
                 <asp:LinkButton ID="EditLinkButton" runat="server" Text="Edit" CommandName="EditCommand"></asp:LinkButton>
         </ItemTemplate>
         <EditItemTemplate>
                <asp:LinkButton ID="UpdateLinkButton" runat="server" Text="Update" CommandName="UpdateCommand"></asp:LinkButton>
                <asp:LinkButton ID="CancelLinkButton" runat="server" Text="Cancel" CommandName="CancelCommand"></asp:LinkButton>
        </EditItemTemplate>
</asp:TemplateField>  

 

 

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
       
        LinkButton sourceLinkButton = (LinkButton)e.CommandSource;
        int rowIndex = ((GridViewRow)sourceLinkButton.Parent.Parent).RowIndex;

        if (e.CommandName == "EditCommand")
        {
            GridView1.EditIndex = rowIndex;
        }
        else if (e.CommandName == "UpdateCommand")
        {
            /* Update method will be here */
            GridView1.EditIndex = -1;
            GridView1.DataBind();
        }
        else if (e.CommandName == "CancelCommand")
        {
            GridView1.EditIndex = -1;
        }

}

 

Hope this help

Jeongwon 

 

 

Gentle people,

The following code fixed it for me:

protected void GridView2_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
       e.KeepInEditMode = false;
       e.ExceptionHandled = true;
}

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
       // find entry in iatTable
       XmlDocument myXMLDoc = this.XmlDataSource2.GetXmlDocument();

       string sElemId = e.Keys[0].ToString();
       XmlNode selElement = myXMLDoc.GetElementById(sElemId);

       string sAttributeName = string.Empty;

       foreach(XmlNode attr in selElement.Attributes)
       {
            try
            {
                   sAttributeName = attr.Name.ToString();
                   selElement.Attributes[sAttributeName].Value = e.NewValues[sAttributeName].ToString();
            }
            catch
            {
                    // catch exceptions when Attribute cannot be written to ( e.g. Keys)
                    myTrace.Information("No value to copy for: "+ sAttributeName);
            }
       }
       this.XmlDataSource2.Save();
       this.GridView2.DataBind();

       // e.Cancel = true;
}

 

ps. Great thread, helped me to find this solution

I tried your blog but still not able to get this working.  I am using VB.NET.  

I can get the selected row from the grid, but how can I update the XML file with this data?  How would I know which node corresponds to the selected row in the grid.  Would some one be able to help me?  Thanks a bunch for your help, in advace.

Here is the code that I've written looking at your solution, but Key(0) would return the value and not the key and hence nothing is getting updated.

Dim myXMLDoc As XmlDocument = Me.myTestXML.GetXmlDocument()
Dim strElementId As String = e.Keys(0)
Dim selectedElement As XmlNode = myXMLDoc.GetElementById(strElementId)
Dim objAttribute As XmlAttribute
Dim strAttributeName As String = ""

strAttributeName = objAttribute.Name.ToString
selectedElement.Attributes(strAttributeName).Value = e.NewValues(strAttributeName).ToString

Dim arrAttributes As XmlAttributeCollection = selectedElement.Attributes()
For Each objAttribute In arrAttributes
        strAttributeName = objAttribute.Name.ToString
        selectedElement.Attributes(strAttributeName).Value = e.NewValues(strAttributeName).ToString
Next

myTestXML.Save()

GridView1.DataBind()