Get values from stored procedure into datatable

Hi,
I want to check wheather my stored procedure values have been loaded when i debug.
Is it possible to check the loaded values using datatable, Please provide us with the code format.

Ex:
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
Dhtmlxgridconnector conn=new Dhtmlxgridconnector(
“Execute Stored_Procedure_Name”,
“”,
dhtmlxDatabaseAdapterType.SqlServer2005, ConfigurationManager.ConnectionStrings[“ConnectionStringName”].ConnectionString);

        return connector;

}

When i set debug on return connector i want to see the values in the stored_procedure