Comments by um_dw (Top 6 by date)

dear Sir
thanks for your reply this code is enough for me
thanks again

dear sir this query show all record
my database in ms-access pls help me

this is my code pls check its
OleDbConnection myConnection = default(OleDbConnection);
OleDbDataAdapter myCommand = default(OleDbDataAdapter);
// Create a connection to the "pubs" SQL database located on the
// local computer.
myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(@"App_Data/funda.mdb"));
// Connect to the SQL database using a SQL SELECT query to get all
// the data from the "Titles" table.

myCommand = new OleDbDataAdapter("SELECT TOP 3 ID, cat_type FROM catagory ORDER BY ID DESC", myConnection);
// Create and fill a DataSet.
DataSet ds = new DataSet();
myCommand.Fill(ds);
// Bind MyDataList to the DataSet. MyDataList is the ID for
// the DataList control in the HTML section of the page.
//this.MyDataList.DataSource = ds;
this.MyDataList.DataBind();

dear Sir my database on ms-access
i want show only 3 top record from cat_type column
so tell me what is the query i write