TableAdapter/DataSet calling Stored Procedure RSS

• • Reply
  

  Kellem00

  Member

  9 Points

  3 Posts

  Re: TableAdapter/DataSet calling Stored Procedure

  Apr 08, 2011 10:32 AM|LINK

  devThis

  object stupid;
      this.ChildrenTableAdapter.FillByParentId(this.myDS.ChildrenTable, out stupid, _parentId);

  Hi, I tried this approach and I get the following error

  'Helpdesk.ISSUEDataTable' is a 'type', which is not valid in the given context  

   

  Any help would be greatly appreciated as I have been stuck on this for two days now.

  Thanks,

  Michael

• • Reply
  

  oscar07202

  Member

  78 Points

  37 Posts

  Re: TableAdapter/DataSet calling Stored Procedure

  May 23, 2011 02:41 AM|LINK

  I got it to work

  oracle 11g r2

  odp.net

  vs 2010

  C#

   

  STORED PROCEDURE

  PROCEDURE magic_cursor (
    rs_account_id_IN IN NUMBER,
    CURSOR_RETURN OUT SYS_REFCURSOR);

   

  DATASET

  Named dataset, ds_magic.xsd

  I dragged and drop the stored procedure into the empty dataset (grey area).

  The datatable is called magicConfigurationsTable.

  The table adapter is called MagicConfigurationsTableTableAdapter and has a method GetData(RS_account_id_in, cursor_return)

   

  C# code

          //create a new table adapater instances

          ds_magicTableAdapters.MagicConfigurationsTableTableAdapter ta = new ds_magicTableAdapters.MagicConfigurationsTableTableAdapter();
         //create a new datatable

         ds_magic.MagicConfigurationsTableDataTable dt;

  
          //create a place holder for the cursor_return paramater in the MagicConfigurationsTableTableAdapter.GetData method
          object placeHolder;

          //create variable for rs_account_id_in paramter in the MagicConfigurationsTableTableAdapter.GetData method
          Decimal number = 9;

           //populate table
          dt = ta.GetData(number, out placeHolder);

   

           //your gridview on UI

           gridview1.datasource = dt;

           gridview1.databind();

   

   

   

  C# ftw