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

  • Question

  • User-1024509590 posted

    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?

    Sunday, February 10, 2013 3:14 PM

Answers

All replies

  • User-2143599517 posted

    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,

    Sunday, February 10, 2013 3:22 PM
  • User-1024509590 posted

    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?

    Monday, February 11, 2013 11:22 AM
  • User-2143599517 posted
    <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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 12, 2013 5:28 AM