Hi to all!!

I am trying to update a table within my application, but I have problems with the insert command, defined like this:

            cmd = new SqlCommand("INSERT INTO CATEGORIAS(cat_descripcion, cat_precio_hora) " +
                "VALUES (@cat_descripcion, @cat_precio_hora); " +
                "SELECT cod_categoria, cat_descripcion, cat_precio_hora " +
                "FROM CATEGORIAS WHERE (cod_categoria = @@IDENTITY)", myConnection);
            cmd.Parameters.Add("@cat_descripcion", SqlDbType.VarChar, 30, "cat_descripcion");
            cmd.Parameters.Add("@cat_precio_hora", SqlDbType.Decimal, 9, "cat_precio_hora");
            daProveedores.InsertCommand = cmd;

I think the problem is the column 'cat_precio_hora', that is defined like numeric(10,2) in my creation script.

I don't know how to do?

Anybody can help?

:)

-------------------------------
World only exists into your mind.

Hey,

Try creating a SQLParameter object. You should be able to do it that way.

Brian