C# MSSQL2000 update

pln · *nix forums beginner Joined: 21 Jul 2006 Posts: 2

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(ConfigurationSettings.AppSettings["CdDbParam"]);
SqlCommand sqlCmd = new SqlCommand("sp_Update_CallOutDetails",
sqlConn);
SqlCmd.CommandType = CommandType.StoredProcedure ;

sqlCmd.Parameters.Add("@vchCallOutNo", txtbCallOutNo.Text);
sqlCmd.Parameters.Add("@vchCallOutDetails", txtbCallOutDetails.Text);

sqlConn.Open();
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
}

Stored proc
CREATE PROCEDURE [fieldman],[sp_Update_CallOutDetails]
@vchCallOutNo VARCHAR(10), @vchCallOutDetails VARCHAR(1024) AS
UPDATE CallOuts
SET CallOutDetails = @vchCallOutDetails
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).

Nick Keighley · *nix forums Guru Wannabe Joined: 03 Apr 2005 Posts: 209

pln wrote:

Flash Gordon · *nix forums Guru Joined: 28 Feb 2005 Posts: 1258

pln wrote:

pln · *nix forums beginner Joined: 21 Jul 2006 Posts: 2

OK. I asked because there wasn't a C# group.

michaelquinlivan@gmail.co · *nix forums beginner Joined: 03 Jul 2006 Posts: 24

pln wrote:

Flash Gordon · *nix forums Guru Joined: 28 Feb 2005 Posts: 1258

pln wrote:

Google