well looking for this in internet and testing step by step, i found the problem, very simple, i call the query method (for the stored procedure) but passing diferent arguments type, the query have nullable<int> type and i use int like argument's type, at the end for this reason i receive the error message, that method don't appear, because the arguments types are different in the right method (generated by dataset designer) and the method i call with error, all it's my fault i write the respective argument's type and all fuction well, thanks a lot for you time
On Wed, Oct 22, 2008 at 11:50 PM, Arsalan Tamiz <[EMAIL PROTECTED]> wrote: > Most probably you will NOT be mentioning the Method name in the Wizard. > Normally following are the steps to create a Typed DataSet using Wizard. > > Step #1: Create a Database Connection > Step #2: Save the ConnectionString > Step #3: Choose a Command Type (SQL Statement, New Stored Procedure, > Existing Stored Procedure) > Step #4: (Depends on previous step) assuming you have selected the > "existing stored procedure" option from previous step then in Step #4 it > will ask you the Procedure name > Step #5: Return type (tabular, single value, no value) > Step #6: Method Name to use in Coding > Step #7: Finish > > I think you are missing the Step #6, in which you will provide the method > name which then can be used in coding. If you have given the Method name = > "getsomedata" for example, then you should use it as, > > QueryTableAdapter.getsomedata() > > A part from this, you have used Stored Procedure to return a single value, > instead you should create a User-Defined Function (if some DML statements > are NOT being used) > > > On Thu, Oct 23, 2008 at 4:38 AM, Elvio Chavez <[EMAIL PROTECTED]>wrote: > >> Yes, the blue line appear, underneath the object(querytableadapter) that >> contain the method, i really don't know what happends, did everey thing >> again, add a query in dataset desing, configure the query type stored >> procedure, select the stored procedure, and check the option of return >> single value, >> all work fine in dataset desing window, can see the results by Previewdata >> options, after that drag the querytableadapter to a window form but when i >> try to use it by code i get the mentioned error, well another info, in the >> property panel when i select the instance of querydtableadapter added to >> windowsform the CommandCollection is empty, no command is shown, thanks , >> any other idea??? >> >> >> On Wed, Oct 22, 2008 at 2:18 PM, sallushan <[EMAIL PROTECTED]> wrote: >> >>> >>> Does your method appear in "intellisense"? >>> Are you seeing a blue wavy line underneath your method? >>> >>> If yes then there can be following possibilities, >>> >>> 1) Your method does NOT exist in the class >>> 2) There is a spelling mistake >>> 3) Your method's scope is limited i.e. private >>> >>> On Oct 22, 6:26 pm, "Elvio Chavez" <[EMAIL PROTECTED]> wrote: >>> > yes it's, when i compiling the code, i get the error, though i test >>> the >>> > tableadapter query in the dataset designer and work fine, when i go to >>> > preview it show me the expected value, i look inside the .xsd code of >>> the >>> > tableadapter, appear the select, delete, insert and update command code >>> but >>> > not my query calling the stored procedure, please if need more info i'm >>> > here.... thanks for asking >>> > >>> > >>> > >>> > On Tue, Oct 21, 2008 at 11:27 PM, sallushan <[EMAIL PROTECTED]> >>> wrote: >>> > >>> > > So is this the compile-time error? >>> > >>> > > On Oct 21, 9:09 pm, coliseoit <[EMAIL PROTECTED]> wrote: >>> > > > Hi, I create a tableadapter using the dataset designer, it's for >>> > > > call a stored procedure in DB that have two parameters (int, >>> string) >>> > > > and return a int single value, the stored procedure create a new >>> row >>> > > > in a table in my DB, but when i call the method of the tableadapter >>> by >>> > > > code i receive an error, VS can't find the method, >>> > > > I just want to call a stored procedure in my database sending two >>> > > > parameters and receiving one, how can i do using dataset and table >>> > > > adapter, my DB is SQL server express 2005- Hide quoted text - >>> > >>> > - Show quoted text - >>> >>> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/DotNetDevelopment You may subscribe to group Feeds using a RSS Feed Reader to stay upto date using following url <a href="http://feeds.feedburner.com/DotNetDevelopment";> http://feeds.feedburner.com/DotNetDevelopment</a> -~----------~----~----~----~------~----~------~--~---
