Display data in GridView using StoredProcdure

Question

Hi.
 I am working in sqlserver and i want to display a data in gridview using storedprocedure please define how can we display the record with code and describe what is the difference between (AS)(IN)(BEGIN) IN STOREDPROCEDURE.