System.NotSupportedException: Specified method is not supported.
-
- Posts: 4
- Joined: Fri 24 Feb 2006 21:30
System.NotSupportedException: Specified method is not supported.
I setup a simple 1 table GridView in ASP.NET 2.0. I had VS generate the UPDATE, INSERT command on the gridview. But when I attempt to update or insert a record i get an System.NotSupportedException: Specified method is not supported error. I tried switching to a DetailsView and switching databases but no good. I'm using
MySQL 5.0.19nt
MySQLDirect .NET version 3.50 beta
I get the following debug information:
[NotSupportedException: Specified method is not supported.]
CoreLab.MySql.z.a(DbType A_0) +133
CoreLab.MySql.MySqlParameter.set_DbType(DbType value) +10
System.Web.UI.WebControls.SqlDataSourceView.InitializeParameters(DbCommand command, ParameterCollection parameters, IDictionary exclusionList) +514
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +267
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1215
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +858
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +117
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
MySQL 5.0.19nt
MySQLDirect .NET version 3.50 beta
I get the following debug information:
[NotSupportedException: Specified method is not supported.]
CoreLab.MySql.z.a(DbType A_0) +133
CoreLab.MySql.MySqlParameter.set_DbType(DbType value) +10
System.Web.UI.WebControls.SqlDataSourceView.InitializeParameters(DbCommand command, ParameterCollection parameters, IDictionary exclusionList) +514
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +267
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1215
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +858
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +117
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
We have reproduced the problem. Now we are investigating it.
To solve the problem right now perform the following steps:
1. Go to the UpdateQuery property of the SqlDataSource component by clicking "..." in Properties window.
2. In "Command and Parameter Editor" click on "Show advanced properties" link.
3. Choose any column from the "Parameters:" listbox by simply clicking on it and in "Properties:" listbox correct its type to actual.
As you can see, the problem is that the type by default is "Object".
To solve the problem right now perform the following steps:
1. Go to the UpdateQuery property of the SqlDataSource component by clicking "..." in Properties window.
2. In "Command and Parameter Editor" click on "Show advanced properties" link.
3. Choose any column from the "Parameters:" listbox by simply clicking on it and in "Properties:" listbox correct its type to actual.
As you can see, the problem is that the type by default is "Object".
-
- Posts: 4
- Joined: Fri 24 Feb 2006 21:30
That worked great thank you. Is the bug in the drivers or the developer tools?
Currently I'm using:
MySQLDirect .NET version 3.50 beta
MySQL Developer Tools for VS 2005 1.70 beta
If it's in the driver will downgrading to the stable 3.20 version fix it? I know my next question is a difficult one to answer but will the bug be addressed in the next release and is there an approx date for this release?
Thanks alot for your assistance
Currently I'm using:
MySQLDirect .NET version 3.50 beta
MySQL Developer Tools for VS 2005 1.70 beta
If it's in the driver will downgrading to the stable 3.20 version fix it? I know my next question is a difficult one to answer but will the bug be addressed in the next release and is there an approx date for this release?
Thanks alot for your assistance
Upgraded to 5.0 - Getting error - System.NotSupportedException: Specified method is not supported
I am running into a similar situation. I just upgraded from 4.1 to 5.0. I am getting the error running my old webpages. It throws the messageSystem.NotSupportedException: Specified method is not supported.
I am not very clear on the steps you specified to resolve these. Could you plesae state them again.
This is a production website so I would appreciate if you could reply soon.
I am not very clear on the steps you specified to resolve these. Could you plesae state them again.
This is a production website so I would appreciate if you could reply soon.
Exact code which is giving problem.
This is the exact code. I am using Corelab.mysql but this is giving an error -Specfic format is not supported. ANY HELP?
string query = "select testcount from features f where f.mid = 14" ;
DataSet dssp;
dssp = new DataSet();
adsp = new MySqlDataAdapter(query, res.connQR);
adsp.Fill(dssp,"data");
string query = "select testcount from features f where f.mid = 14" ;
DataSet dssp;
dssp = new DataSet();
adsp = new MySqlDataAdapter(query, res.connQR);
adsp.Fill(dssp,"data");