using System; using System.Data; using System.Data.OracleClient; // required for oracle public class PayrollDAL { public DataTable GetJobs() { // using HR account of Oracle10g. OracleConnection con = new OracleConnection("uid=hr;pwd=hr;server=localhost"); OracleDataAdapter da = new OracleDataAdapter("select * from jobs", con); DataSet ds = new DataSet(); da.Fill(ds, "jobs"); return ds.Tables["jobs"]; // return a DataTable from DataSet } }
<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> </script> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>List Of Jobs</title> </head> <body> <form id="form1" runat="server"> <h1>List Of Jobs</h1> <asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True"> </asp:GridView> <asp:ObjectDataSource ID="ObjectDataSource1" TypeName="PayrollDAL" SelectMethod ="GetJobs" runat="server"> </asp:ObjectDataSource> </form> </body> </html>