Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_beginners thread: Stored procedures


Message #1 by "Isac Backlund" <isac@m...> on Wed, 25 Sep 2002 13:05:57 +0200
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???



  Return to Index