Could not find a non-generic method - VB - ASP.NET

Hi Everybody I have the 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], [email], [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] = ?, [email] = ?, [Media] = ?, [Job_Size] = ?, [Colors] = ?, [Number_of_Lots] = ?, [Proof] = ?, [Job_Detail] = ? WHERE (([PrepressID] = ?))

Here is my code:

Expand|Select|Wrap|Line Numbers

 
<%@ 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">
 
<html xmlns="http://www.w3.org/1999/xhtml" >
 
<head runat="server">
 
<title>Untitled Page</title>
 
</head>
 
<body>
 
<form id="form1" runat="server">
 
<div>
 
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="DeletePre"
 
InsertMethod="InsertPre" OldValuesParameterFormatString="{0}" SelectMethod="GetPre"
 
TypeName="TestTableAdapters.Prepress_Request_FormTableAdapter" UpdateMethod="UpdatePre">
 
<DeleteParameters>
 
<asp:Parameter Name="PrepressID" Type="Int32" />
 
</DeleteParameters>
 
<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" />
 
<asp:Parameter Name="PrepressID" Type="Int32" />
 
</UpdateParameters>
 
<InsertParameters>
 
<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">
 
<Fields>
 
<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">
 
<Columns>
 
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
 
<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" />
 
</Columns>
 
</asp:GridView>
 
</form>
 
</body>
 
</html>

Any Idea please will be very appreciated.

Thank you very much!!

Jan 17 '08 #1

Subscribe Post Reply

1758

stepterr

157

100+

This might help you a bit. Check out this site

Jan 18 '08 #2

Similar topics

things I wish python could do

by: Ryan Paul | last post by:

I've spent a lot of time using python, and personally, I feel like it is vastly superior when compared to languages like java, and c++, but there are still a few things that detract from its...

Python

Could C++ do this without the #pragma

by: Steven T. Hatton | last post by:

Stroustrup says this: http://www.research.att.com/~bs/bs_faq2.html#macro "So, what's wrong with using macros?" "And yes, I do know that there are things known as macros that doesn't...

C / C++

1254-002 Cannot find a rule to create target /u02/apps_r/dev/ben/lib/fcfz02.a from dependencies.

by: simduss | last post by:

Hi, First of all, I'm a beginner with Unix. I have a "make" (Unix command) problem with a Pro*C sub-program since I installed Oracle8i (before I was at 7.3.4). I have a script builder that...

C / C++

Error message: Could not find installable ISAM

by: JP Lacasse | last post by:

I translate a web application from ASP to ASP.NET and I keep getting the following error: Could not find installable ISA I used the same ConnectString ("DBQ=" &...

ASP.NET

Could not load file or assembly..The system cannot find the file specified

by: semedao | last post by:

Hi All, I developed Outlook add-in with VS 2005 , everything work fine , until the machine reboot unnormally , when I opened the solution again many projects was not there ! (I have more then...

C# / C Sharp

Socket Exception: A non blocking socket operation could not be completed immediately.

by: Rollasoc | last post by:

Hi, We have a range of four products that can talk to our software (Written in C# & managed C++) via ethernet. Using standard socket class. This has all been working fine for a long time now,...

.NET Framework

Could not find file Error

by: Amritha.Datta | last post by:

Can anyone tell me why the below code returns error? Exception Details: System.IO.FileNotFoundException: Could not find file Dim strLFolder As String = "c:\Temp\F Files" Dim intClientID As...

ASP.NET

Program to find occurences of a word in a file

by: Neehar | last post by:

Hello For one of the interviews I took recently, I was given an offline programming quiz. In 30 minutes I had to write code in C++ to counts the number of times each unique word appears in a...

C / C++

Error on SOAP Call on only one machine: Could not find default endpoint element that references contract 'ServiceReference1.SLDSoap' in the ServiceModel client configuration section

by: Lance Wynn | last post by:

Hello, I am receiving this error when trying to instantiate a webservice component. I have 2 development machines, both are XP sp2 with VS 2008 installed. On one machine, the code works fine. On...

Visual Basic .NET

Could anybody explain this macro for me?

by: webinfinite | last post by:

#define D(y...) (const int ) {y} My understand is that D is taking in a various length parameter y which is an array of const int. Am I right? Thanks.

C / C++

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp