Tips & Tricks

Re: FIX - DataSet Error "Could not find a non generic method"

ziazai123 — Mon, 28 Dec 2009 09:54:13 GMT

I am also getting following error:

ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'UpdateQuery' that has parameters: Region, EID_No, MasterEIDNo, Exchg, Bldg_ID, Block, Section, Plot, p1, Obj_No, OLT, FDH, p4, Building, Owner, ResTenants, BzTenants, TenantUpdateOn, Status, PECNo, CreatedOn, Active, EID No, Bldg ID, DP/IFP, Obj No, Bldg/Villa, FTTHID.

                        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="Delete"
                            InsertMethod="Insert" OldValuesParameterFormatString="{0}" SelectMethod="GetDataBy"
                            TypeName="dstFtthDataTableAdapters.FTTHDataTableAdapter" UpdateMethod="UpdateQuery">
                            <DeleteParameters>
                                <asp:Parameter Name="Original_FTTHID" Type="Int32" />
                                <asp:Parameter Name="Original_Region" Type="String" />
                                <asp:Parameter Name="Original_EID_No" Type="String" />
                                <asp:Parameter Name="Original_MasterEIDNo" Type="String" />
                                <asp:Parameter Name="Original_Exchg" Type="String" />
                                <asp:Parameter Name="Original_Bldg_ID" Type="String" />
                                <asp:Parameter Name="Original_Block" Type="String" />
                                <asp:Parameter Name="Original_Section" Type="String" />
                                <asp:Parameter Name="Original_Plot" Type="String" />
                                <asp:Parameter Name="p2" Type="String" />
                                <asp:Parameter Name="Original_Obj_No" Type="String" />
                                <asp:Parameter Name="Original_OLT" Type="String" />
                                <asp:Parameter Name="Original_FDH" Type="Double" />
                                <asp:Parameter Name="p5" Type="String" />
                                <asp:Parameter Name="Original_Building" Type="String" />
                                <asp:Parameter Name="Original_Owner" Type="String" />
                                <asp:Parameter Name="Original_ResTenants" Type="Int32" />
                                <asp:Parameter Name="Original_BzTenants" Type="Int32" />
                                <asp:Parameter Name="Original_TenantUpdateOn" Type="DateTime" />
                                <asp:Parameter Name="Original_Status" Type="String" />
                                <asp:Parameter Name="Original_PECNo" Type="String" />
                                <asp:Parameter Name="Original_CreatedOn" Type="DateTime" />
                                <asp:Parameter Name="Original_Active" Type="Boolean" />
                            </DeleteParameters>
                            <UpdateParameters>
                                <asp:Parameter Name="Region" Type="String" />
                                <asp:Parameter Name="EID_No" Type="String" />
                                <asp:Parameter Name="MasterEIDNo" Type="String" />
                                <asp:Parameter Name="Exchg" Type="String" />
                                <asp:Parameter Name="Bldg_ID" Type="String" />
                                <asp:Parameter Name="Block" Type="String" />
                                <asp:Parameter Name="Section" Type="String" />
                                <asp:Parameter Name="Plot" Type="String" />
                                <asp:Parameter Name="p1" Type="String" />
                                <asp:Parameter Name="Obj_No" Type="String" />
                                <asp:Parameter Name="OLT" Type="String" />
                                <asp:Parameter Name="FDH" Type="Single" />
                                <asp:Parameter Name="p4" Type="String" />
                                <asp:Parameter Name="Building" Type="String" />
                                <asp:Parameter Name="Owner" Type="String" />
                                <asp:Parameter Name="ResTenants" Type="Int32" />
                                <asp:Parameter Name="BzTenants" Type="Int32" />
                                <asp:Parameter Name="TenantUpdateOn" Type="DateTime" />
                                <asp:Parameter Name="Status" Type="String" />
                                <asp:Parameter Name="PECNo" Type="String" />
                                <asp:Parameter Name="CreatedOn" Type="DateTime" />
                                <asp:Parameter Name="Active" Type="Boolean" />
                                <asp:Parameter Name="FTTHID" Type="Int32" />
                            </UpdateParameters>
                            <SelectParameters>
                                <asp:Parameter Name="FTTHID" Type="Int32" />
                                <asp:ControlParameter ControlID="lstRegion" Name="Region" PropertyName="SelectedValue"
                                    Type="String" />
                                <asp:ControlParameter ControlID="txtEID" Name="EIDNo" PropertyName="Text" Type="String" />
                                <asp:ControlParameter ControlID="txtExchange" Name="Exchg" PropertyName="Text" Type="String" />
                                <asp:ControlParameter ControlID="lstSector" Name="Block" PropertyName="SelectedValue"
                                    Type="String" />
                                <asp:ControlParameter ControlID="txtSection" Name="Section" PropertyName="Text" Type="String" />
                                <asp:ControlParameter ControlID="txtPlot" Name="Plot" PropertyName="Text" Type="String" />
                                <asp:ControlParameter ControlID="txtOLT" Name="OLT" PropertyName="Text" Type="String" />
                                <asp:ControlParameter ControlID="txtFDH" Name="FDH" PropertyName="Text" Type="Single" />
                            </SelectParameters>
                            <InsertParameters>
                                <asp:Parameter Name="Region" Type="String" />
                                <asp:Parameter Name="EID_No" Type="String" />
                                <asp:Parameter Name="MasterEIDNo" Type="String" />
                                <asp:Parameter Name="Exchg" Type="String" />
                                <asp:Parameter Name="Bldg_ID" Type="String" />
                                <asp:Parameter Name="Block" Type="String" />
                                <asp:Parameter Name="Section" Type="String" />
                                <asp:Parameter Name="Plot" Type="String" />
                                <asp:Parameter Name="p1" Type="String" />
                                <asp:Parameter Name="Obj_No" Type="String" />
                                <asp:Parameter Name="OLT" Type="String" />
                                <asp:Parameter Name="FDH" Type="Double" />
                                <asp:Parameter Name="p4" Type="String" />
                                <asp:Parameter Name="Building" Type="String" />
                                <asp:Parameter Name="Owner" Type="String" />
                                <asp:Parameter Name="ResTenants" Type="Int32" />
                                <asp:Parameter Name="BzTenants" Type="Int32" />
                                <asp:Parameter Name="TenantUpdateOn" Type="DateTime" />
                                <asp:Parameter Name="Status" Type="String" />
                                <asp:Parameter Name="PECNo" Type="String" />
                                <asp:Parameter Name="CreatedOn" Type="DateTime" />
                                <asp:Parameter Name="Active" Type="Boolean" />
                            </InsertParameters>
                        </asp:ObjectDataSource>

Please do something on urgent basis.

Re: FIX - DataSet Error "Could not find a non generic method"

DonJasper — Thu, 26 Mar 2009 16:28:42 GMT

Well just to add to the collective wisdom. I was running across this same error, tried the suggested fixes to no avail. After running through that gamut, I followed a suspicion that I had.

The table I was working with had field names that started with Original_ (in this case Original_Source and Original_Value). When the Update statement is created – those fields are called p1 and p4 (in my case - your mileage may vary), I figured that this substitution would be followed through “behind the scenes”. Wrong.

When I exclude those fields from the tableadapter query (select blah blah from table) hey presto all is happy again. I can rebuild my screens and get on with it.

So I’ll speculate that Visual Studio has made up its mind that only it’s allowed to use fields that start with “Original_” . If there is a scheme to substitute the user-define fields – to avoid the ridiculous restriction that “While working through the UI for tableadapters you’re not allowed to use fields that start with Original_” – then it doesn’t work.

Whether this ridiculous – but present – restriction requires the use of an underscore and I would’ve missed the educational opportunity had the fields been named OriginalSource and OriginalValue – I’ll never know. Unless someone wishes to further explore this behavior and post the results.

Re: FIX - DataSet Error "Could not find a non generic method"

nevinph — Wed, 24 Sep 2008 14:08:12 GMT

now im going back again.. the same old errors are circling around as i follow those steps..

sigh :( .. though some had work but the prob now is the GUID it return 0000-00000-000 sigh! it is really getting boring after a week of finding the solution.

Re: FIX - DataSet Error "Could not find a non generic method"

libsta — Tue, 22 Jul 2008 09:26:49 GMT

The real problem with this error message is that it is too broad.

When I added my Update method to my TableAdapter in my XSD using the TableAdapter Query Configuration tool, the tool inexplicably dropped one of my input parameters.

Re: FIX - DataSet Error "Could not find a non generic method"

smithersgs — Thu, 17 Jul 2008 14:19:19 GMT

I cant see Advanced Options.

I created a dataset by adding a new and using a stored proc, but I cant see the Advanced Options you mentioned. Your reply sounds logical, but I dont know what you mean.

Re: FIX - DataSet Error "Could not find a non generic method"

hannous — Sun, 11 May 2008 10:17:20 GMT

I would not call this a bug in Visual Studio as much as something misleading.

I found the following to be the neatest way to fix the problem while keeping everything else logical. That means I did not add a meaningless parameter (that will not be used) to my update method nor change the ReadOnly property of the Id to False.

I kept my function as it is. [ex. public bool UpdateText(string text, int id)] and I went to the ObjectDataSource's UpdateParameters collection and removed the Id parameter. Then I change the format of the old value parameter to only {0} (this way {0} will be id instead of original_id) and it worked. The GridView update called my update function correctly passing it the correct parameters.

I hope this will help someone else who's stuck.

Re: FIX - DataSet Error "Could not find a non generic method"

fslharthy — Thu, 08 May 2008 08:36:36 GMT

wow, its working :) thanks

Re: FIX - DataSet Error "Could not find a non generic method"

JayPH — Tue, 08 Apr 2008 15:43:24 GMT

Unfortunately none of the above is working for me.

Firstly I'm not sure that the lingo I'm using is right but I'll try

I have a FormView contol that has an ObjectDataSource. This is plugged into my BLL that accesses the DAL. The DAL is configured to use existing Stored Procedures.

When I try to do a delete I get this error message:

ObjectDataSource 'ObjectDataSourceModules' could not find a non-generic method 'ModuleDelete' that takes parameters of type "myBusinessLogicLayer.Module'.

This is the code in the BLL:

public static void ModuleDelete(string moduleCode)

{

using (ModulesTableAdapter db = new ModulesTableAdapter())

{

db.ModuleDelete(moduleCode);

}

The ObjectDataSource has a property

DataObjectTypeName="myBusinessLogicLayer.Module"

If I the delete that property I get a new error:

ObjectDataSource 'ObjectDataSourceModules' could not find a non-generic method 'ModuleDelete' that has parameters: moduleCode, Code.

I'm only passing one parameter as declared in the ObjectDataSource:

<asp:Parameter Name="moduleCode" Type="String" />

</DeleteParameters>

My stored procedure has a primary key that is not auto incremented but it's set to read only false in the edit template

ALTER PROCEDURE [dbo].[ModuleDelete]

@Code nvarchar(50)

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON; DELETE FROM Modules

WHERE Code = @Code

END

SOrry for the essay but I'm on day 3 with this now.

I really like the idea of separating the DAL from the presentation layer but I could write my own Data Access code with much less fuss.

If anyone can help I would be very grateful

Re: FIX - DataSet Error "Could not find a non generic method"

Lightsabre — Sun, 02 Mar 2008 20:40:43 GMT

I encountered the same issue with my update on a datagrid that uses an ODS with SPs. The work around for me is as follows:

confiure the existing table adapter
first select the Use SQL statements
then click on Advanced Options
uncheck the Refresh the Data Table
click OK then click Previous
Select use existing SPs
Verify you have the correct SPs then click Finish

Please note, I have an existing TA with SPs. So I just had to reconfigure using the above. This workaround may not be typical and therefore may not work for you.

Re: FIX - DataSet Error "Could not find a non generic method"

boby76 — Thu, 17 Jan 2008 17:37:38 GMT

Hi Everybody I have the same error (ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'UpdatePre' that has parameters: Comp, Job_Number, Request_Date, Customer, Contact_Name, Tel, Email, Media, Job_Size, Colors, Number_of_Lots, Proof, Job_Detail, PrepressID) when I tried to update the values in my dataset. (before I had the problem to Insert and Delete and I changed OldValuesParameterFormatString="original_{0}" to OldValuesParameterFormatString="{0}" and it worked fine for Insert and Delete but I am still getting this error when I try to update values in my dataset with a Gridview).

I use a dataset (TableAdapter Prepress_Request_Form) connected to a MSDE Server and with a SQLOLEDB connection.

The PrimaryKey is PrepressID and my Methods of my dataset are the followings:

1)GetPre()

SELECT Prepress_Request_Form.*
FROM Prepress_Request_Form

2)DeletePre()

DELETE FROM [Prepress_Request_Form] WHERE (([PrepressID] = ?))

3) InsertPre()

INSERT INTO [Prepress_Request_Form] ([Comp], [Job_Number], [Request_Date], [Customer], [Contact_Name], [Tel], , [Media], [Job_Size], [Colors], [Number_of_Lots], [Proof], [Job_Detail]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

4)UpdatePre()

UPDATE [Prepress_Request_Form] SET [Comp] = ?, [Job_Number] = ?, [Request_Date] = ?, [Customer] = ?, [Contact_Name] = ?, [Tel] = ?, = ?, [Media] = ?, [Job_Size] = ?, [Colors] = ?, [Number_of_Lots] = ?, [Proof] = ?, [Job_Detail] = ? WHERE (([PrepressID] = ?))

Here is my code:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Edit.aspx.vb" Inherits="Edit" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="DeletePre"

InsertMethod="InsertPre" OldValuesParameterFormatString="{0}" SelectMethod="GetPre"

TypeName="TestTableAdapters.Prepress_Request_FormTableAdapter" UpdateMethod="UpdatePre">

<asp:Parameter Name="PrepressID" Type="Int32" />

</DeleteParameters>

<asp:Parameter Name="Comp" Type="Int32" />

<asp:Parameter Name="Job_Number" Type="Int32" />

<asp:Parameter Name="Request_Date" Type="DateTime" />

<asp:Parameter Name="Customer" Type="String" />

<asp:Parameter Name="Contact_Name" Type="String" />

<asp:Parameter Name="Tel" Type="String" />

<asp:Parameter Name="Email" Type="String" />

<asp:Parameter Name="Media" Type="String" />

<asp:Parameter Name="Job_Size" Type="String" />

<asp:Parameter Name="Colors" Type="String" />

<asp:Parameter Name="Number_of_Lots" Type="String" />

<asp:Parameter Name="Proof" Type="String" />

<asp:Parameter Name="Job_Detail" Type="String" />

<asp:Parameter Name="PrepressID" Type="Int32" />

</UpdateParameters>

<asp:Parameter Name="Comp" Type="Int32" />

<asp:Parameter Name="Job_Number" Type="Int32" />

<asp:Parameter Name="Request_Date" Type="DateTime" />

<asp:Parameter Name="Customer" Type="String" />

<asp:Parameter Name="Contact_Name" Type="String" />

<asp:Parameter Name="Tel" Type="String" />

<asp:Parameter Name="Email" Type="String" />

<asp:Parameter Name="Media" Type="String" />

<asp:Parameter Name="Job_Size" Type="String" />

<asp:Parameter Name="Colors" Type="String" />

<asp:Parameter Name="Number_of_Lots" Type="String" />

<asp:Parameter Name="Proof" Type="String" />

<asp:Parameter Name="Job_Detail" Type="String" />

</InsertParameters>

</asp:ObjectDataSource>

</div>

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="PrepressID"

DataSourceID="ObjectDataSource1" DefaultMode="Insert" Height="50px" Width="125px">

<asp:BoundField DataField="PrepressID" HeaderText="PrepressID" InsertVisible="False"

ReadOnly="True" SortExpression="PrepressID" />

<asp:BoundField DataField="Comp" HeaderText="Comp" SortExpression="Comp" />

<asp:BoundField DataField="Job_Number" HeaderText="Job_Number" SortExpression="Job_Number" />

<asp:BoundField DataField="Request_Date" HeaderText="Request_Date" SortExpression="Request_Date" />

<asp:BoundField DataField="Customer" HeaderText="Customer" SortExpression="Customer" />

<asp:BoundField DataField="Contact_Name" HeaderText="Contact_Name" SortExpression="Contact_Name" />

<asp:BoundField DataField="Tel" HeaderText="Tel" SortExpression="Tel" />

<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />

<asp:BoundField DataField="Media" HeaderText="Media" SortExpression="Media" />

<asp:BoundField DataField="Job_Size" HeaderText="Job_Size" SortExpression="Job_Size" />

<asp:BoundField DataField="Colors" HeaderText="Colors" SortExpression="Colors" />

<asp:BoundField DataField="Number_of_Lots" HeaderText="Number_of_Lots" SortExpression="Number_of_Lots" />

<asp:BoundField DataField="Proof" HeaderText="Proof" SortExpression="Proof" />

<asp:BoundField DataField="Job_Detail" HeaderText="Job_Detail" SortExpression="Job_Detail" />

<asp:CommandField ShowInsertButton="True" />

</Fields>

</asp:DetailsView>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="PrepressID"

DataSourceID="ObjectDataSource1">

<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />