use existing store procedure is disabled

Hot Topic

auto generate a value in database
calling CL programs in AS400 from a Winapp
Help with XML
About Ngen
generic DictionaryBase
How do i get the currently open network files?
What is the connection string to write for importing mixed data from excel sheet to data grid
App.config HELP!!
Binary serialization stream/buffering issue.
Retriving records from Oracle table without using Views

.NET Development

Write to file that is in use
Loading referenced assemblies using Reflection
To clean pool of connections in ADO.NET
difference between web service and website in VWD 2005?
the meaning of 'not working'
Problem uninstalling DLL from GAC
Connecting to a database on a website
data access problem
How to set a File's Version Info
Database insert problem

use existing store procedure is disabled

Does anyone to why when I right click on a tableAdapter to add query I don't get the "use existing store procedure" option. All I get is :

1- Use SQL statment

and the other 2 are disabled:

create a new stored procedure and use existing stored procedure




Answer this question

use existing store procedure is disabled

  • BitShift

    Which .NET data provider are you using If it's System.Data.OracleClient, the query configuration wizard does not support generating a TableAdapter from a stored procedure.

    In that case, you can work around the issue by using a dummy dynamic SQL command (e.g. using text "SELECT * FROM DUAL"), then change the CommandType to StoredProcedure, set CommandText to target stored procedure name and fill the parameters collection (if there are parameters in your stored procedure).

    If you use that workaround, make sure you make the CommandText/CommandType/Parameters changes in the properties in the DataSet designer UI, not in the generated code. The code will be regenerated anytime a change is made in the designer, but if you set the info in the property window, it will regenerate using your new settings.

    If you are using a different provider, please provide more information about which one. Without further investigation, I'm not sure what limitations the others may have, but I know about this one for OracleClient.

    Thanks,
    Sarah



  • jatwood

    Ensuure that you use the suitable Provider

    and what you mean with table provider


  • mahioper

    In my TableAdapter Configuration Wizard the two options that refer to stored procedures are greyed out. Also the advanced button that I have read so much about is not there either. There's the "query builder" on the right. And on the bottom left of the window there should be "advanced"

    I looked ad am using this data provider: System.Data.OleDb

    is it because im using that data provider that I don't have these options available to me Should I use a different one Do I have a choice I'm working with an access database.

  • Vijay Guru Prasadh

    this is in visual studio 2005. I didnt undersant what you meant with the suitable provider

  • J Quick

    did you ever get this sorted out i'm in the same boat and can't get the wizard to allow executing an oracle sproc inside a package.

    thanks in advance.
  • use existing store procedure is disabled
Answer this question