stored procedure to SQL DataSource
<p>I have a stored procedure which combines values from 2 tables. This is the stored procedure:</p>

<pre><code>ALTER PROCEDURE dbo.SplitTime
    @time  nvarchar(50),    
    @classid nvarchar(50)

    AS
    /* SET NOCOUNT ON */

    DECLARE @delimiter char(1)
    DECLARE @index INT
    DECLARE @value nvarchar(4000)

    SET @index = 1
    SET @delimiter='-'

    WHILE @index != 0

    BEGIN
        SELECT @index = CHARINDEX(@Delimiter,LTRIM(@time))

        IF @index !=0
            SELECT @value = LTRIM(LEFT(@time,@index - 1))
        ELSE
            SELECT @value = LTRIM(@time)

        SET @value = LTRIM(RTRIM(@value))

        IF @value &lt;&gt; ''
            INSERT into StartEndTimes(times,ID) values(LTRIM(@value),@classid)

        SELECT @time =LTRIM(RIGHT(@time,LEN(@time) - @index))


        IF LEN(@time) = 0 BREAK

    END

    SELECT * from StartEndTimes,ClassInfo 
</code></pre>

<p>So, basically I split the time which is of format 6:00 - 9:00 and store it in another table. Now, I need to assign this stored procedure to a sqldatasource in asp.net. But I'm not sure how to send the parameters. Both the parameters come from ClassInfo table. Can you please help me? </p>
