public void resimleriyukle()
{
	try
	{

		string klasoryolu = "C:\\wamp\\www\\site\\image\\data\\resimler\\";
		Directory.Delete(klasoryolu, true);
		Directory.CreateDirectory(klasoryolu);
		MessageBox.Show("Klasör Oluşturuldu");
		
		DirectoryInfo di = new DirectoryInfo("C:\\resim\\");
		FileInfo[] rgFiles = di.GetFiles();
		foreach (FileInfo fi in rgFiles)
		{
			using (MySqlConnection mysql_baglanti2 = new MySqlConnection("Server=localhost;Database=site;Uid=root;Pwd='';Charset=utf8;Connect Timeout=200;pooling=true;max pool size=1000000"))
			{
				mysql_baglanti2.Open();
				string modelnumaralari = "SELECT model FROM oc_product";
				using (MySqlCommand modeller = new MySqlCommand(modelnumaralari, mysql_baglanti2))
				{
					using (MySqlDataReader modelno = modeller.ExecuteReader())
					{
						if (modelno.Read())
						{

							while (modelno.Read())
							{
								if (fi.Name.Length == 17 && fi.Name == modelno["model"].ToString() + ".jpg")
								{
									using (MySqlConnection mysql_baglanti3 = new MySqlConnection("Server=localhost;Database=site;Uid=root;Pwd='';Charset=utf8;Connect Timeout=200;pooling=true;max pool size=1000000"))
									{
										mysql_baglanti3.Open();
										string guncelle = "update oc_product set image = 'data/resimler/" + fi.Name + "' where model = '" + fi.Name.Substring(0, 13) + "'";
										using (MySqlCommand mc = new MySqlCommand(guncelle, mysql_baglanti3))
										{
											mc.CommandTimeout = 9999;
											mc.ExecuteNonQuery();
											File.Copy("C:\\resim\\" + fi.Name, "C:\\wamp\\www\\site\\image\\data\\resimler\\" + fi.Name);
										}
										mysql_baglanti3.Close();
									}
								}
							}
						}
					}
				}
				mysql_baglanti2.Close();
			}
		}

   /* }

	catch (Exception hata)
	{
		MessageBox.Show(hata.Message.ToString());
	}*/
}