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> -~----------~----~----~----~------~----~------~--~---
