Use variable in Parameters

Question

Use variable in Parameters

Navigation

#1 by (0 votes)

1

I'm trying to run the line below, but I need to use variables. The line is as follows:

CM.Parameters.Add("desnome", System.Data.SqlDbType.VarChar).Value = USU.xdes_nome;

I need the following: desnome by variable Varchar by variable USU.xdes_nome per variable

Does anyone have a clue how I can do it?

c#

asked by anonymous 25.10.2017 / 14:45

1 answer

How to calculate two fields generated dynamically by the append () method? In what way could I create a class that would serve both API sandbox and API production?

score 0 · Answer 1

Your question is totally vague, but try the following:

    CM.Parameters.Add("@desnome", SqlDbType.Int);
    CM.Parameters["@desnome"].Value = USU.xdes_nome;

For the above example to work, you need to check the "user.xdes_name", if you are referring to a variable being called from some class, it is correct, otherwise modify the name.