Witam,
mam problem z wywołaniem procedury skladowanej w .Net (procedura zapisana po stronie servera Microsoft SQL Server 2005). Mam taki błąd:
Additional information: String or binary data would be truncated.
The statement has been terminated.
Moja procedura składowana:
ALTER PROCEDURE [dbo].[Usun_guza]
(
@id_guza int = 0,
@id_pacjenta int = 0
)
AS
BEGIN
DELETE FROM PACJENTMAGUZY
WHERE id_guza=@id_guza AND id_pacjenta=@id_pacjenta
END
A oto moje wywołanie w C#:
// Procedura składowana - usuwanie guza
SqlConnection myConnection = new SqlConnection(System.IO.File.ReadAllText("database.txt", Encoding.Default));
if (myConnection.State == ConnectionState.Closed) myConnection.Open();
SqlCommand cmd = new SqlCommand("dbo.Usun_guza", myConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parm1;
SqlParameter parm2;
parm1 = cmd.Parameters.Add(new SqlParameter("@id_guza", SqlDbType.Int));
parm1.Direction = ParameterDirection.Input;
cmd.Parameters["@id_guza"].Value = cur["id_guza1"];
parm2 = cmd.Parameters.Add(new SqlParameter("@id_pacjenta", SqlDbType.Int));
parm2.Direction = ParameterDirection.Input;
cmd.Parameters["@id_pacjenta"].Value = cur["id_pacjenta"];
cmd.ExecuteNonQuery();
Proszę o pomoc! :)