hi again....i have this
---------------------------
DateTime datum_datum = new System.DateTime();
int intFeel = 35;
int datum_id = 1;
SqlConnection myConn = new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;Initial Catalog=krisen; uid=sa; pwd=");
SqlCommand myComm = new SqlCommand("doInsertSkale", myConn);
myComm.CommandType = CommandType.StoredProcedure;
myComm.Parameters.Add(new SqlParameter("@datum_datum", SqlDbType.DateTime,
8, ParameterDirection.Input, false,
0, 0, "datum_datum",DataRowVersion.Current ,null));
myComm.Parameters.Add(new SqlParameter("@datum_feel", SqlDbType.Int,
4, ParameterDirection.Input, false,
0, 0, "intFeel", DataRowVersion.Default, null));
myComm.Parameters.Add(new SqlParameter("@datum_id", SqlDbType.Int,
4, ParameterDirection.Input, false,
0, 0, "datum_id", DataRowVersion.Default, null));
myComm.UpdatedRowSource = UpdateRowSource.OutputParameters;
myConn.Open();
myComm.ExecuteNonQuery();
myConn.Close();
-------------------------------------------
But it just returnes this error
---------------------------------
Procedure 'doInsertSkale' expects parameter '@d..._datum', which was not supplied.
----------------------------------------
The SP looks like this
---------------------------------------
(
@datum_datum DATETIME,
@datum_feel INTEGER,
@datum_id INTEGER OUTPUT)
AS
SET NOCOUNT OFF;
SELECT @datum_id = MAX(datum_id) + 1
FROM t_datum;
INSERT INTO t_datum(datum_id, datum_datum, datum_feel)
VALUES(@datum_id, @datum_datum, @datum_feel);
-----------------------------------
What´s wrong???