oke, zrobilem to zapytanie z parametrami, ale otrzymuje w bazie wynik -1 ?
OleDbCommand command = new OleDbCommand();
command.Connection = new OleDbConnection(connString);
command.Connection.Open();
foreach (OrdersAdelaila.productType prod in order.order_details.products)
{
command.CommandText = "INSERT INTO Produkty VALUES(Id_Zam=@Id_Zam, Nr_Zam=@Nr_Zam,"
+ "Id=@Id, Nazwa=@Nazwa, Kod_Produktu = @Kod_Produktu , Kod_Zewnetrzny=@Kod_Zewnetrzny, "
+"Id_Magazynu=@Id_Magazynu, Ilość=@Ilość, Waga=@Waga, VAT=@VAT,"
+"Cena_Brutto_W_Panelu=@Cena_Brutto_W_Panelu, Cena_Brutto_W_Zam=@Cena_Brutto_W_Zam)";
command.Parameters.AddWithValue("@Id_Zam", check(order.id.ToString()));
command.Parameters.AddWithValue("@Nr_Zam", check(order.sn.ToString()));
command.Parameters.AddWithValue("@Id", check(prod.id.ToString()));
command.Parameters.AddWithValue("@Nazwa", check(prod.name.ToString()));
command.Parameters.AddWithValue("@Kod_Produktu", "0");
command.Parameters.AddWithValue("@Kod_Zewnetrzny", check(prod.product_sizecode));
command.Parameters.AddWithValue("@Id_Magazynu", check(prod.stock.ToString()));
command.Parameters.AddWithValue("@Ilość", check(prod.quantity.ToString()));
command.Parameters.AddWithValue("@Waga", check(prod.weight.ToString()));
command.Parameters.AddWithValue("@VAT", check(prod.vat.ToString()));
command.Parameters.AddWithValue("@Cena_Brutto_W_Panelu", check(prod.panel_price.ToString()));
command.Parameters.AddWithValue("@Cena_Brutto_W_Zam", check(prod.order_price.ToString()));
command.ExecuteNonQuery();
}
command.Connection.Close();