erro de sintaxe query C#
Estou com esse erro :
/applications/core/interface/imageproxy/imageproxy.php?img=http://i.imgur.com/48JUeu5.png&key=99c0555cd7c566722044675e176bd42434b63bd7eeb28b854e069fdb75f9c438" alt="48JUeu5.png" />
quando vou executar o query da isso :/ Help me plz
private void materialRaisedButton2_Click(object sender, EventArgs e)
{
using (NpgsqlConnection connpg = new NpgsqlConnection(connectionStringpg))
{
connpg.Open();
string query = "INSERT INTO shop (good_id, item_id, item_name, price_gold, price_cash, count, buy_type, buy_type2, buy_type3, equip, tag, title, cupon_l, cupon_v, set) VALUES (@good_id, @item_id, @item_name @price_gold, @price_cash, @count, @buy_type, @buy_type2, @buy_type3, @equip, @tag, @title, @cupon_l, @cupon_v, @set)";
using (NpgsqlCommand cmd = new NpgsqlCommand(query, connpg))
{
cmd.Parameters.AddWithValue("@good_id", materialSingleLineTextField8.Text);
cmd.Parameters.AddWithValue("@item_id", materialSingleLineTextField9.Text);
cmd.Parameters.AddWithValue("@item_name", materialSingleLineTextField10.Text);
cmd.Parameters.AddWithValue("@price_gold", materialSingleLineTextField11.Text);
cmd.Parameters.AddWithValue("@price_cash", materialSingleLineTextField12.Text);
cmd.Parameters.AddWithValue("@count", materialSingleLineTextField13.Text);
cmd.Parameters.AddWithValue("@buy_type", materialSingleLineTextField14.Text);
cmd.Parameters.AddWithValue("@buy_type2", materialSingleLineTextField15.Text);
cmd.Parameters.AddWithValue("@buy_type3", materialSingleLineTextField16.Text);
cmd.Parameters.AddWithValue("@equip", materialSingleLineTextField17.Text);
cmd.Parameters.AddWithValue("@tag", materialSingleLineTextField18.Text);
cmd.Parameters.AddWithValue("@title", materialSingleLineTextField19.Text);
cmd.Parameters.AddWithValue("@cupon_l", materialSingleLineTextField20.Text);
cmd.Parameters.AddWithValue("@cupon_v", materialSingleLineTextField21.Text);
cmd.Parameters.AddWithValue("@set", materialSingleLineTextField22.Text);
//15 colunas
cmd.ExecuteNonQuery();
LogSKTL.getS().info_warning("inserido dados na tabela Shop");
LogSKTL.getS().vermelho("══════════════════════════════════════════════════════════════════════════════════════════════");
}
}
}Discussão (2)
Carregando comentários...