What Could Be The Problem With My Code? Its Not Updating The Database

Hi

My code that Im using is not updating the database, Im using the following stored procedure :-


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[Update_VMI_Capture]
(
@ID int,
@Weighbridge nvarchar(50),
@Volume float,
@DateTime datetime,
@Fuel_Type nvarchar(50)
)
AS
SET NOCOUNT OFF;
UPDATE VMI_Capture
SET Weighbridge = @Weighbridge, Volume = @Volume, DateTime=@DateTime, Fuel_Type=@Fuel_Type
WHERE ([ID] = @ID)


When Im running this procedure using SQL Server Management Studio it runs perfect.

The problem is when I use a little C# code to run this procedure like :-


int ID = Convert.ToInt32(Request.QueryString["ID"]);
SQLCONN get_con = new SQLCONN();
System.Data.SqlClient.SqlConnection connect = new System.Data.SqlClient.SqlConnection(get_con.RETSQLCONN());
System.Data.SqlClient.SqlCommand cmd_get_Data = new System.Data.SqlClient.SqlCommand("Update_VMI_Capture", connect);
cmd_get_Data.CommandType = System.Data.CommandType.StoredProcedure;
cmd_get_Data.Parameters.Add("@ID", System.Data.SqlDbType.Int).Value = ID;
cmd_get_Data.Parameters.Add("@Weighbridge", System.Data.SqlDbType.NVarChar, 50).Value = txtNumber.Text;
cmd_get_Data.Parameters.Add("@Volume", System.Data.SqlDbType.Float).Value = Convert.ToSingle(txtVolume.Text);
cmd_get_Data.Parameters.Add("@DateTime", System.Data.SqlDbType.DateTime).Value = Convert.ToDateTime(txtDate.Text);
cmd_get_Data.Parameters.Add("@Fuel_Type", System.Data.SqlDbType.NVarChar, 50).Value = txtFuel.Text;
connect.Open();
LabelStatus.Text = cmd_get_Data.ExecuteNonQuery().ToString();
connect.Close();


LabeStatus return 1, but when I check the table in the database there is no change and I dont understand why? am I doiing this wrong please help.