Working with mssql stored procedures

[saktya]

Use the data adapter with store procedure command type...

MSDN can help
http://msdn.microsoft.com/en-us/library/59x02y99.aspx