Stored Procedure Results

From: Kait (miss_kait_at_yahoo.com)
Date: 01/26/05 

Date: 26 Jan 2005 10:07:27 -0800

I have a stored procedure which is as follows:

Alter Procedure "uspConfig"

(
@FO int,
@Pull varchar(4)
)
As
DELETE FROM tblEEConfig
INSERT INTO tblEEConfig
SELECT FO, Pull, Config, StartSNRange FROM tblSerialNum WHERE FO = @FO
AND Pull = @Pull;

This proc will only return one record. I would like to display the
Config and StartSNRange in a text box on a .net form.

After trying the .executereader method, the .parameter.add method and a
few others this is the code I am trying in a button click event:

Dim dsResults As String
Dim dsStartResults As String
dsResults = daEEConfig.Fill(DsEEConfig1).ToString
dsStartResults = daEEConfigStart.Fill(DsEEConfigStart1).ToString
txtFileLoc.Text = txtFileLoc.Text & dsResults & "\" & dsStartResults

I feel that I am way off the mark with this, but as it is, I have
already spent too much time trying to get this accomplished. Any
suggestions, either for the proc or the .net code, would be greatly
appreciated! Thanks!