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!