Using ObjectDataSource

Thursday, 17 February 2011 03:24

requests-dataset-static-new-sqldataadapter

// description of your code here







  ID="DetailsView1"  

  runat="server"  

  DataSourceID="ObjectDataSource" 

  AllowPaging="true"> 





  ID="ObjectDataSource"  

  runat="server"  

  TypeName="RequestListing" 

  SelectMethod="GetAllRequests"> 











//class 

using System.Configuration;

using System.Data;

using System.Data.SqlClient;



public class RequestListing

{

    private static string _cnnString = ConfigurationManager.ConnectionStrings [ "ApplicationServices" ].ToString();



    public static DataTable GetAllRequests()

    {

        SqlDataAdapter adp = new SqlDataAdapter( "select * from requests", _cnnString );



        DataSet ds = new DataSet( "requests" );

        adp.Fill( ds, "requests" );



        return ds.Tables [ "requests" ];

    }

}