|
Thursday, 17 February 2011 03:24 |
// 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" ];
}
}
 Read more: |
