Use a parameterized statement. Every time. No excuses. They avoid a fracking
ton of possible problems.
cmd.CommandText = "INSERT INTO TBL_Customers customer_name,FK_fk_id,commissary,FK_area_id,customer_address,tel1,tel2,id_number,datebirth,tel4) VALUES (@customer_name,@FK_fk_id,@commissary,@FK_area_id,@customer_address,@tel1,@tel2,@id_number,@datebirth,@tel4)" ;
cmd.Parameters.AddWithValue ( "@customer_name" , txtname.Text );
cmd.Parameters.AddWithValue ( "@datebirth" , this.dateTimePicker1datebirth ) ;