I am trying to update an sql table using stored procedures, C# and ADO.
My code samples are as follows
C#
public void Save(Object s, EventArgs e)
{
sqlConnection sqlConn = new
SqlConnection(C onfigurationSet tings.AppSettin gs["CdDbParam"]);
SqlCommand sqlCmd = new SqlCommand("sp_ Update_CallOutD etails",
sqlConn);
SqlCmd.CommandT ype = CommandType.Sto redProcedure ;
sqlCmd.Paramete rs.Add("@vchCal lOutNo", txtbCallOutNo.T ext);
sqlCmd.Paramete rs.Add("@vchCal lOutDetails", txtbCallOutDeta ils.Text);
sqlConn.Open();
sqlCmd.ExecuteN onQuery();
sqlConn.Close() ;
}
Stored proc
CREATE PROCEDURE [fieldman],[sp_Update_CallO utDetails]
@vchCallOutNo VARCHAR(10), @vchCallOutDeta ils VARCHAR(1024) AS
UPDATE CallOuts
SET CallOutDetails = @vchCallOutDeta ils
WHERE CallOutNo = @vchCallOutNo
Using EXECUTE form within SQL works fine.
I get no error messages.
I think the problem is with ADO but where should I look?
(If this is the wrong forum could someone point me in the right
direction).