How to call an oracle procedure that selects 100 records from a table and display in a GridView? RSS

• • Reply
  

  Unnikrishnan...

  0 Points

  2 Posts

  How to call an oracle procedure that selects 100 records from a table and display in a GridView?

  Feb 10, 2013 07:14 PM|LINK

  How to call  in asp.net, an oracle procedure that selects 100 records from a table and display in a GridView with a page Index of 10?

• • Reply
  

  anj1212

  Member

  333 Points

  74 Posts

  Re: How to call an oracle procedure that selects 100 records from a table and display in a GridVi...

  Feb 10, 2013 07:22 PM|LINK

  Hi,

  First write a stored procedure in database and call from c# or vb.net server side code with OracleClient.

  follow below links its definelty helpful,

  http://www.c-sharpcorner.com/UploadFile/john_charles/CallingOraclestoredproceduresfromMicrosoftdotNET06222007142805PM/CallingOraclestoredproceduresfromMicrosoftdotNET.aspx

  https://forums.oracle.com/forums/thread.jspa?messageID=4566433

  regards,

• • Reply
  

  Unnikrishnan...

  0 Points

  2 Posts

  Re: How to call an oracle procedure that selects 100 records from a table and display in a GridVi...

  Feb 11, 2013 03:22 PM|LINK

  Hi,

  Thanks for the reply.

  That gives a general idea.

  Can I get some article for the below scenario

  The procedure has a select statement that has 100 rows say "select * from employees"

  This result set I want to display in a gridview of the web page.

  Any idea, how to do this?

• • Reply
  

  anj1212

  Member

  333 Points

  74 Posts

  Re: How to call an oracle procedure that selects 100 records from a table and display in a GridVi...

  Feb 12, 2013 09:28 AM|LINK

  <asp:GridView ID="gridView" runat="server" AllowPaging="True">
   <PagerSettings Mode="NextPreviousFirstLast" FirstPageText="First" PreviousPageText="Previous"
  NextPageText="Next" LastPageText="Last" /> </asp:GridView>

  
  and clear explanation and working example,

  http://mattberseth.com/blog/2008/04/using_a_datapager_with_the_gri.html

  • Edited by anj1212 on Feb 12, 2013 09:29 AM
  • Marked as answer by Young Yang - MSFT on Feb 18, 2013 08:36 AM