title: C# double into MySql db double not working
body: <p>I'm converting an webshop system to an another system with C#. This is from DB to DB with some convertion between.</p>
  
  <p>I have this code in C#:</p>
  
  <pre><code>Double proPriceTmp = Double.Parse(productPrice);
  Double realPrice = ((proPriceTmp / 121) * 100);
  
  string insertProduct = "INSERT INTO `" + ocPrefix + "product` ( `product_id`, `model`, `quantity`, `stock_status_id`, `image`, `manufacturer_id`, `shipping`, `price`, `tax_class_id`,`date_available`, `weight`, `weight_class_id`, `length`, `width`, `height`,`length_class_id`,`subtract`,`minimum`,`sort_order`,`status`,`date_added`,`date_modified`,`viewed`) VALUES ('" + product_id + "', @param_model, '" + product_quantity + "', '" + stock_status_id + "', '" + image + "', '" + manufacturer_id + "', '" + shipping + "', '" + realPrice + "', '" + numericUpDown1.Value + "', '" + date_available + "', '" + product_weight + "', '" + weigth_class_id + "', '" + product_length + "',  '" + product_width + "', '" + product_height + "', '" + length_class_id + "', '" + substracting + "', '" + minimum + "', '" + sort_order + "', '" + status + "', '" + product_created + "', '" + product_modified + "', '" + viewed + "')";
  MySqlCommand cmdInsertProduct = new MySqlCommand(insertProduct, connOc);
  cmdInsertProduct.CommandText = insertProduct;
  cmdInsertProduct.Parameters.AddWithValue("@param_model", product_name);
  cmdInsertProduct.ExecuteNonQuery();
  cmdInsertProduct.Dispose();
  </code></pre>
  
  <p>This are the values of the price variables ( thanks to the debugger ):</p>
  
  <pre><code>productPrice = "1,20000";
  proPriceTmp = 1.2;
  realPrice = 0.99173553719008256;
  </code></pre>
  
  <p>But the price in the DB is <code>0.0000</code>. I've already tryed inserting the info by hand, and that worked ( with that long number ), so that should work.</p>
  
  <p>The table looks like this:</p>
  
  <pre><code>CREATE TABLE `oc_product` (
    `product_id` int(11) NOT NULL AUTO_INCREMENT,
    `model` varchar(64) NOT NULL,
    `sku` varchar(64) NOT NULL,
    `upc` varchar(12) NOT NULL,
    `ean` varchar(14) NOT NULL,
    `jan` varchar(13) NOT NULL,
    `isbn` varchar(13) NOT NULL,
    `mpn` varchar(64) NOT NULL,
    `location` varchar(128) NOT NULL,
    `quantity` int(4) NOT NULL DEFAULT '0',
    `stock_status_id` int(11) NOT NULL,
    `image` varchar(255) DEFAULT NULL,
    `manufacturer_id` int(11) NOT NULL,
    `shipping` tinyint(1) NOT NULL DEFAULT '1',
    `price` decimal(15,4) NOT NULL DEFAULT '0.0000',
    `points` int(8) NOT NULL DEFAULT '0',
    `tax_class_id` int(11) NOT NULL,
    `date_available` date NOT NULL,
    `weight` decimal(15,8) NOT NULL DEFAULT '0.00000000',
    `weight_class_id` int(11) NOT NULL DEFAULT '0',
    `length` decimal(15,8) NOT NULL DEFAULT '0.00000000',
    `width` decimal(15,8) NOT NULL DEFAULT '0.00000000',
    `height` decimal(15,8) NOT NULL DEFAULT '0.00000000',
    `length_class_id` int(11) NOT NULL DEFAULT '0',
    `subtract` tinyint(1) NOT NULL DEFAULT '1',
    `minimum` int(11) NOT NULL DEFAULT '1',
    `sort_order` int(11) NOT NULL DEFAULT '0',
    `status` tinyint(1) NOT NULL DEFAULT '0',
    `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `viewed` int(5) NOT NULL DEFAULT '0',
    PRIMARY KEY (`product_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>So does anybody knows why this isn't working like it supposed to do? Even a little push in the right direction is enough...</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>As questioned, here is the value of <code>insertProduct</code>. As you can see, is the price there right...</p>
  
  <pre><code>"INSERT INTO `oc_product` ( `product_id`, `model`, `quantity`, `stock_status_id`, `image`, `manufacturer_id`, `shipping`, `price`, `tax_class_id`,`date_available`, `weight`, `weight_class_id`, `length`, `width`, `height`,`length_class_id`,`subtract`,`minimum`,`sort_order`,`status`,`date_added`,`date_modified`,`viewed`) VALUES ('51', @param_model, '999999999', '7', 'data/old/letter_trein.jpg', '0', '1', '0,991735537190083', '11', '2013-06-09', '600,000', '1', '0,000',  '0,000', '0,000', '1', '0', '0', '0', '1', '2013-01-09 12:26:02', '2013-10-24 10:23:47', '0')"
  </code></pre>