i want to show top 3 record from table,pls help me

check my code
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();

my code is pls read every body and give solution

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();

Use TOP with ORDER BY clause in your query

If you want display TOP 3 records based on ID by descending order,

SELECT TOP 3 ID, cat_type FROM catagory ORDER BY ID DESC

or if you want display TOP 3 records based on ID by ascending order,

SELECT TOP 3 ID, cat_type FROM catagory ORDER BY ID ASC

If you want display TOP 3 records based on cat_type by descending order,

SELECT TOP 3 ID, cat_type FROM catagory ORDER BY cat_type DESC

or if you want display TOP 3 records based on cat_type by ascending order,

SELECT TOP 3 ID, cat_type FROM catagory ORDER BY cat_type ASC

Use the query based on your requirement.

EDIT
---------------------------------------------------------------
If you want to display only cat_type column then try like below

SELECT TOP 3 cat_type FROM catagory ORDER BY cat_type DESC

If still you are not clear then please show us what output do you want? Include the table structure with sample data. And show sample output which do you want. Let me know.

if your database is MSSQL try this

Select Top 3 ID, cat_type from category

or

if your database is MYSQL try this

SELECT ID,cat_type FROM category LIMIT 3

if not working please let me know

Thanks

Try

SELECT TOP 3 cat_type FROM catagory