stored procedure select distinct

Question

i want to select top 3 values from a table where a particular column should have distinct values only..

how to write the stored procedure in such case?? 

Answer 1

Dataset ds=new Dataset();
ds.ReadXml("path of xml file");
Gridview1.Datasource=ds;
Gridview1.DataBind();