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