SQL Server with C#

[vijaygarg]

Hello All,

I have been working in with Oracle DB and .Net C# application using ODP.NET for some time. For one of the screen i need to connect with SQL Server Procedure which has code like following :

CREATE PROCEDURE sp_getdata @weekDate datetime AS

.

. /* Processing happens here */

.

SELECT field1, field2, ... FROM table /* return to the UI*/

GO

Here input parameter is passed to procedure and i have to use SELECT in UI. Can someone tell me what kind of objects should i add to get SELECT ... in C# code. This is used for readonly purposes.

Thanks

[NadaAbuGamel]

I think you can use datatable