Insert Firebird Database C#

1
votes
FbCommand fbCmm = 
      new FbCommand("INSERT INTO PRODUTO
                   (CODIGO,EAN,DESCRICAO,VAL_PRODUTO,VAL_CUSTO,CAT_PRECO)" 
                   + "Values (@txt_codigo.Text, @txt_ean, @txt_descricao,
                   @txt_valPro, @txt_valCus, @txt_catPre)", ConexaoFirebird.Conexao);

enter image description here]

What's wrong with that sentence? I did a open connection in other class - ConexaoFirebird.Conexao();

2
c#firebird
Where are the variables assigned values? e.g. @txt_ean? Also, what is the text property of the codigo variable (@txt_codigo.Text)? - JohnLBevan

2 Answers

3
votes

You're executing a parameterized query without providing values for those parameters. See the documentation:

FbCommand cmd = new FbCommand("insert into t1(id, text) values (@id, @text);");
cmd.CommandType = CommandType.Text;

cmd.Parameters.Add("@id", 123);
cmd.Parameters.Add("@text", "my string");

cmd.ExecuteNonQuery();

Here they bind the values 123 and "my string" to the parameters named id and text respectively.

Also note that parameter names are generally rescticted to alphanumeric, so txt_codigo.Text isn't likely going to work.

0
votes

You should use quote for decimal, string field types, your statement is correct but not clear, you can create clear sql text with sql command builder or you can use Command object of your connection.