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


All replies

  • User-2143599517 posted


    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,




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


    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,


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