DataList Paging (cj168. 2 methods in Dataaccess.magsdb)

access| Paging public ICollection Getsearchresult (String txtsearch, int StartIndex, int PageSize)
{

SqlConnection myconnection = new SqlConnection (configurationsettings.appsettings["ConnectionString"]);
SqlDataAdapter mycommand = new SqlDataAdapter ("Getsearchresult", MyConnection);

MyCommand.SelectCommand.CommandType = CommandType.StoredProcedure;

SqlParameter parametertxtsearch = new SqlParameter ("@txtSearch", SqlDbType.VarChar, 255);
Parametertxtsearch.value = Txtsearch;
MYCOMMAND.SELECTCOMMAND.PARAMETERS.ADD (Parametertxtsearch);

DataSet myDataSet = new DataSet ();

Mycommand.fill (myDataSet, StartIndex, PageSize, "SearchResult");

return mydataset.tables["SearchResult"]. DefaultView;

}


public int Getsearchresultcount (String txtsearch)
{
Int intcount;
intcount = 0;


SqlConnection myconnection = new SqlConnection (configurationsettings.appsettings["ConnectionString"]);
SqlCommand mycommand = new SqlCommand ("Getsearchresultcount", MyConnection);
myCommand.CommandType = CommandType.StoredProcedure;

SqlParameter parametertxtsearch = new SqlParameter ("@txtSearch", SqlDbType.VarChar, 255);
Parametertxtsearch.value = Txtsearch;
MYCOMMAND.PARAMETERS.ADD (Parametertxtsearch);

Myconnection.open ();
SqlDataReader Dr =mycommand.executereader ();

if (Dr. Read ())
{
intcount = Int32.Parse (dr["co"). ToString ());
}
Else
{
intcount = 0;
}

Dr. Close ();
Return intcount;

}