private void pictureBox1_Click(object sender, EventArgs e) { Form anasayfa = new anasayfa(); anasayfa.Show(); this.Hide(); }
private void button3_Click(object sender, EventArgs e) { Form anasayfa = new anasayfa(); anasayfa.Show(); this.Hide(); }
private void button1_Click_1(object sender, EventArgs e) { try { mysqlbaglan.Open(); MySqlCommand komut = new MySqlCommand("select * from kullanici where kullaniciAdi='" + textBox1.Text.Trim() + "' and sifre='" + textBox2.Text.Trim() + "'", mysqlbaglan); MySqlDataReader dr = komut.ExecuteReader(); if (dr.Read()) { Form arkaplan = new arkaplan(); arkaplan.Show(); this.Hide(); Form anasayfa = new anasayfa(); anasayfa.Show(); } else { MessageBox.Show("Kullanıcı Adı Veya Şifre Hatalı", "Giriş Hatası", MessageBoxButtons.OK, MessageBoxIcon.Stop); } mysqlbaglan.Close(); } catch (Exception) { MessageBox.Show("Giriş Başarısız! Lütfen internet bağlantınızı kontrol edip programı yeniden başlatınız.", "Bağlantı Hatası", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button2_Click(object sender, EventArgs e) { { try { mysqlbaglan.Open(); string komut = "insert into kayitlar(urun,cikisTarihi,miktar,aracPlaka,aracModel,musteriTC,musteriAd,musteriSoyad,ucret,odemeTuru) values('" + textBox1.Text + "', '" + dateTimePicker1.Text + "', '" + textBox2.Text + comboBox1.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + comboBox3.Text + "','" + comboBox2.Text + "')"; MySqlCommand kmt = new MySqlCommand(komut, mysqlbaglan); kmt.ExecuteNonQuery(); MessageBox.Show("Kayıt Başarıyla Gerçekleştirildi."); Form anasayfa = new anasayfa(); anasayfa.Show(); this.Hide(); } catch (Exception) { MessageBox.Show("Beklenmeyen Bir Hata Ouştu Lütfen İnternet Bağlantınızı Kontrol Ediniz Ve Yeniden Deneyiniz. ", "Bağlantı Hatası", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }
private void button1_Click(object sender, EventArgs e) { onay = MessageBox.Show("Onaylıyor musunuz?", "Onay", MessageBoxButtons.YesNo); if (onay == DialogResult.Yes) { try { Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application(); objExcel.Visible = true; Microsoft.Office.Interop.Excel.Workbook objBook = objExcel.Workbooks.Open("c:\\toplutasima.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); Microsoft.Office.Interop.Excel.Worksheet objSheet = (Microsoft.Office.Interop.Excel.Worksheet)objBook.Worksheets.get_Item(1); Microsoft.Office.Interop.Excel.Range objRange; objRange = objSheet.get_Range("A12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox1.Text); objRange = objSheet.get_Range("B12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox2.Text); objRange = objSheet.get_Range("E12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox3.Text); objRange = objSheet.get_Range("H12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox4.Text); objRange = objSheet.get_Range("J12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox5.Text); objRange = objSheet.get_Range("K12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox6.Text); objRange = objSheet.get_Range("P12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox7.Text); objRange = objSheet.get_Range("Q12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox8.Text); objRange = objSheet.get_Range("R12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox9.Text); objRange = objSheet.get_Range("S12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox10.Text); objRange = objSheet.get_Range("R2", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox11.Text); objRange = objSheet.get_Range("R3", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, dateTimePicker1.Text); objRange = objSheet.get_Range("R4", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, dateTimePicker2.Text); objRange = objSheet.get_Range("R5", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox12.Text); objRange = objSheet.get_Range("R6", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox23.Text); objRange = objSheet.get_Range("R7", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox45.Text); objRange = objSheet.get_Range("R8", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox34.Text); objRange = objSheet.get_Range("A14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox22.Text); objRange = objSheet.get_Range("B14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox21.Text); objRange = objSheet.get_Range("E14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox20.Text); objRange = objSheet.get_Range("H14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox19.Text); objRange = objSheet.get_Range("J14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox18.Text); objRange = objSheet.get_Range("K14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox17.Text); objRange = objSheet.get_Range("P14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox16.Text); objRange = objSheet.get_Range("Q14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox15.Text); objRange = objSheet.get_Range("R14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox14.Text); objRange = objSheet.get_Range("S14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox13.Text); objRange = objSheet.get_Range("A16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox33.Text); objRange = objSheet.get_Range("B16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox32.Text); objRange = objSheet.get_Range("E16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox31.Text); objRange = objSheet.get_Range("H16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox30.Text); objRange = objSheet.get_Range("J16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox29.Text); objRange = objSheet.get_Range("K16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox28.Text); objRange = objSheet.get_Range("P16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox27.Text); objRange = objSheet.get_Range("Q16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox26.Text); objRange = objSheet.get_Range("R16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox25.Text); objRange = objSheet.get_Range("S16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox24.Text); objRange = objSheet.get_Range("A18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox44.Text); objRange = objSheet.get_Range("B18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox43.Text); objRange = objSheet.get_Range("E18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox42.Text); objRange = objSheet.get_Range("H18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox41.Text); objRange = objSheet.get_Range("J18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox40.Text); objRange = objSheet.get_Range("K18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox39.Text); objRange = objSheet.get_Range("P18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox38.Text); objRange = objSheet.get_Range("Q18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox37.Text); objRange = objSheet.get_Range("R18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox36.Text); objRange = objSheet.get_Range("S18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox35.Text); objRange = objSheet.get_Range("A20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox55.Text); objRange = objSheet.get_Range("B20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox54.Text); objRange = objSheet.get_Range("E20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox53.Text); objRange = objSheet.get_Range("H20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox52.Text); objRange = objSheet.get_Range("J20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox51.Text); objRange = objSheet.get_Range("K20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox50.Text); objRange = objSheet.get_Range("P20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox49.Text); objRange = objSheet.get_Range("Q20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox48.Text); objRange = objSheet.get_Range("R20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox47.Text); objRange = objSheet.get_Range("S20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox46.Text); objRange = objSheet.get_Range("A22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox66.Text); objRange = objSheet.get_Range("B22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox65.Text); objRange = objSheet.get_Range("E22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox64.Text); objRange = objSheet.get_Range("H22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox63.Text); objRange = objSheet.get_Range("J22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox62.Text); objRange = objSheet.get_Range("K22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox61.Text); objRange = objSheet.get_Range("P22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox60.Text); objRange = objSheet.get_Range("Q22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox59.Text); objRange = objSheet.get_Range("R22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox58.Text); objRange = objSheet.get_Range("S22", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox57.Text); objRange = objSheet.get_Range("A24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox77.Text); objRange = objSheet.get_Range("B24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox76.Text); objRange = objSheet.get_Range("E24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox75.Text); objRange = objSheet.get_Range("H24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox74.Text); objRange = objSheet.get_Range("J24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox73.Text); objRange = objSheet.get_Range("K24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox72.Text); objRange = objSheet.get_Range("P24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox71.Text); objRange = objSheet.get_Range("Q24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox70.Text); objRange = objSheet.get_Range("R24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox69.Text); objRange = objSheet.get_Range("S24", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox68.Text); objRange = objSheet.get_Range("A26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox88.Text); objRange = objSheet.get_Range("B26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox87.Text); objRange = objSheet.get_Range("E26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox86.Text); objRange = objSheet.get_Range("H26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox85.Text); objRange = objSheet.get_Range("J26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox84.Text); objRange = objSheet.get_Range("K26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox83.Text); objRange = objSheet.get_Range("P26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox82.Text); objRange = objSheet.get_Range("Q26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox81.Text); objRange = objSheet.get_Range("R26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox80.Text); objRange = objSheet.get_Range("S26", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox79.Text); objRange = objSheet.get_Range("A28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox99.Text); objRange = objSheet.get_Range("B28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox98.Text); objRange = objSheet.get_Range("E28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox97.Text); objRange = objSheet.get_Range("H28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox96.Text); objRange = objSheet.get_Range("J28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox95.Text); objRange = objSheet.get_Range("K28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox94.Text); objRange = objSheet.get_Range("P28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox93.Text); objRange = objSheet.get_Range("Q28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox92.Text); objRange = objSheet.get_Range("R28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox91.Text); objRange = objSheet.get_Range("S28", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox90.Text); objRange = objSheet.get_Range("a30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox110.Text); objRange = objSheet.get_Range("b30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox109.Text); objRange = objSheet.get_Range("E30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox108.Text); objRange = objSheet.get_Range("H30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox107.Text); objRange = objSheet.get_Range("J30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox106.Text); objRange = objSheet.get_Range("K30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox105.Text); objRange = objSheet.get_Range("P30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox104.Text); objRange = objSheet.get_Range("Q30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox103.Text); objRange = objSheet.get_Range("R30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox102.Text); objRange = objSheet.get_Range("S30", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox101.Text); objRange = objSheet.get_Range("a32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox121.Text); objRange = objSheet.get_Range("b32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox120.Text); objRange = objSheet.get_Range("E32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox119.Text); objRange = objSheet.get_Range("H32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox118.Text); objRange = objSheet.get_Range("J32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox117.Text); objRange = objSheet.get_Range("K32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox116.Text); objRange = objSheet.get_Range("P32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox115.Text); objRange = objSheet.get_Range("Q32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox114.Text); objRange = objSheet.get_Range("R32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox113.Text); objRange = objSheet.get_Range("S32", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox112.Text); objRange = objSheet.get_Range("a34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox132.Text); objRange = objSheet.get_Range("b34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox131.Text); objRange = objSheet.get_Range("E34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox130.Text); objRange = objSheet.get_Range("H34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox129.Text); objRange = objSheet.get_Range("J34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox128.Text); objRange = objSheet.get_Range("K34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox127.Text); objRange = objSheet.get_Range("P34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox126.Text); objRange = objSheet.get_Range("Q34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox125.Text); objRange = objSheet.get_Range("R34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox124.Text); objRange = objSheet.get_Range("S34", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox123.Text); objRange = objSheet.get_Range("a36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox143.Text); objRange = objSheet.get_Range("b36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox142.Text); objRange = objSheet.get_Range("E36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox141.Text); objRange = objSheet.get_Range("H36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox140.Text); objRange = objSheet.get_Range("J36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox139.Text); objRange = objSheet.get_Range("K36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox138.Text); objRange = objSheet.get_Range("P36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox137.Text); objRange = objSheet.get_Range("Q36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox136.Text); objRange = objSheet.get_Range("R36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox135.Text); objRange = objSheet.get_Range("S36", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox134.Text); objRange = objSheet.get_Range("a38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox154.Text); objRange = objSheet.get_Range("b38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox153.Text); objRange = objSheet.get_Range("E38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox152.Text); objRange = objSheet.get_Range("H38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox151.Text); objRange = objSheet.get_Range("J38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox150.Text); objRange = objSheet.get_Range("K38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox149.Text); objRange = objSheet.get_Range("P38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox148.Text); objRange = objSheet.get_Range("Q38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox147.Text); objRange = objSheet.get_Range("R38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox146.Text); objRange = objSheet.get_Range("S38", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox145.Text); objRange = objSheet.get_Range("a40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox165.Text); objRange = objSheet.get_Range("b40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox164.Text); objRange = objSheet.get_Range("E40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox163.Text); objRange = objSheet.get_Range("H40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox162.Text); objRange = objSheet.get_Range("J40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox161.Text); objRange = objSheet.get_Range("K40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox160.Text); objRange = objSheet.get_Range("P40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox159.Text); objRange = objSheet.get_Range("Q40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox158.Text); objRange = objSheet.get_Range("R40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox157.Text); objRange = objSheet.get_Range("S40", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox156.Text); objRange = objSheet.get_Range("a42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox176.Text); objRange = objSheet.get_Range("b42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox175.Text); objRange = objSheet.get_Range("E42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox174.Text); objRange = objSheet.get_Range("H42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox173.Text); objRange = objSheet.get_Range("J42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox172.Text); objRange = objSheet.get_Range("K42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox171.Text); objRange = objSheet.get_Range("P42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox170.Text); objRange = objSheet.get_Range("Q42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox169.Text); objRange = objSheet.get_Range("R42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox168.Text); objRange = objSheet.get_Range("S42", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox167.Text); objRange = objSheet.get_Range("a44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox187.Text); objRange = objSheet.get_Range("b44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox186.Text); objRange = objSheet.get_Range("E44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox185.Text); objRange = objSheet.get_Range("H44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox184.Text); objRange = objSheet.get_Range("J44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox183.Text); objRange = objSheet.get_Range("K44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox182.Text); objRange = objSheet.get_Range("P44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox181.Text); objRange = objSheet.get_Range("Q44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox180.Text); objRange = objSheet.get_Range("R44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox179.Text); objRange = objSheet.get_Range("S44", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox178.Text); objRange = objSheet.get_Range("a46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox198.Text); objRange = objSheet.get_Range("b46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox197.Text); objRange = objSheet.get_Range("E46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox196.Text); objRange = objSheet.get_Range("H46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox195.Text); objRange = objSheet.get_Range("J46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox194.Text); objRange = objSheet.get_Range("K46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox193.Text); objRange = objSheet.get_Range("P46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox192.Text); objRange = objSheet.get_Range("Q46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox191.Text); objRange = objSheet.get_Range("R46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox190.Text); objRange = objSheet.get_Range("S46", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox189.Text); objRange = objSheet.get_Range("a48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox209.Text); objRange = objSheet.get_Range("b48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox208.Text); objRange = objSheet.get_Range("E48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox207.Text); objRange = objSheet.get_Range("H48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox206.Text); objRange = objSheet.get_Range("J48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox205.Text); objRange = objSheet.get_Range("K48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox204.Text); objRange = objSheet.get_Range("P48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox203.Text); objRange = objSheet.get_Range("Q48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox202.Text); objRange = objSheet.get_Range("R48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox201.Text); objRange = objSheet.get_Range("S48", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox200.Text); objSheet.PrintOutEx(1, 1, 2, true); Form anasayfa = new anasayfa(); anasayfa.Show(); this.Hide(); } catch (Exception) { } } }
public void yazdir() { Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application(); objExcel.Visible = true; Microsoft.Office.Interop.Excel.Workbook objBook = objExcel.Workbooks.Open("c:\\ambartesellum.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); Microsoft.Office.Interop.Excel.Worksheet objSheet = (Microsoft.Office.Interop.Excel.Worksheet)objBook.Worksheets.get_Item(1); Microsoft.Office.Interop.Excel.Range objRange; objRange = objSheet.get_Range("J4", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, dateTimePicker2.Text); objRange = objSheet.get_Range("C4", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox7.Text); //ALICI BİLGİLERİ objRange = objSheet.get_Range("A7", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox2.Text); objRange = objSheet.get_Range("A8", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox1.Text); objRange = objSheet.get_Range("C9", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox2.Text); objRange = objSheet.get_Range("C10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox4.Text); /////////////////////////////////////////////////////////////////// //GÖNDEREN BİLGİLERİ objRange = objSheet.get_Range("G7", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox4.Text); objRange = objSheet.get_Range("G8", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox6.Text); objRange = objSheet.get_Range("I9", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox8.Text); objRange = objSheet.get_Range("I10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox5.Text); /////////////////////////////////////////////////////////////////// //MALIN ÖZELLİKLERİ //ADET objRange = objSheet.get_Range("A13", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox9.Text); objRange = objSheet.get_Range("A14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox10.Text); objRange = objSheet.get_Range("A15", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox11.Text); objRange = objSheet.get_Range("A16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox12.Text); //////////////////////////////////////////////////////////////////// //KAB objRange = objSheet.get_Range("B13", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox14.Text); objRange = objSheet.get_Range("B14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox15.Text); objRange = objSheet.get_Range("B15", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox16.Text); objRange = objSheet.get_Range("B16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox17.Text); //////////////////////////////////////////////////////////////////// //CİNSİ objRange = objSheet.get_Range("C13", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox19.Text); objRange = objSheet.get_Range("C14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox20.Text); objRange = objSheet.get_Range("C15", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox21.Text); objRange = objSheet.get_Range("C16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox22.Text); //////////////////////////////////////////////////////////////////// //KG objRange = objSheet.get_Range("F13", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox24.Text); objRange = objSheet.get_Range("F14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox25.Text); objRange = objSheet.get_Range("F15", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox26.Text); objRange = objSheet.get_Range("F16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox27.Text); //////////////////////////////////////////////////////////////////// objRange = objSheet.get_Range("K16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox40.Text); objRange = objSheet.get_Range("G16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox39.Text); objRange = objSheet.get_Range("I16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox3.Text); objSheet.PrintOutEx(1, 1, 2, true); Form anasayfa = new anasayfa(); anasayfa.Show(); this.Hide(); }
///////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////// private void button1_Click(object sender, EventArgs e) { onay = MessageBox.Show("Onaylıyor musunuz?", "Onay", MessageBoxButtons.YesNo); if (onay == DialogResult.Yes) { try { mysqlbaglan.Open(); string komut = "insert into fatura(sayin,vdno,no,adres,adres2,tarih,fisNo,tarih1,aciklama,adet,kab,cins,kilo,fiyat,tutar,fisNo2,tarih2,aciklama2,adet2,kab2,cins2,kilo2,fiyat2,tutar2,fisNo3,tarih3,aciklama3,adet3,kab3,cins3,kilo3,fiyat3,tutar3,fisNo4,tarih4,aciklama4,adet4,kab4,cins4,kilo4,fiyat4,tutar4,fisNo5,tarih5,aciklama5,adet5,kab5,cins5,kilo5,fiyat5,tutar5,fisNo6,tarih6,aciklama6,adet6,kab6,cins6,kilo6,fiyat6,tutar6,toplam,genelToplam,tesellumNo) values('" + comboBox1.Text + "', '" + textBox2.Text + "','" + textBox1.Text + "','" + textBox16.Text + "','" + textBox23.Text + "', '" + dateTimePicker1.Text + "', '" + comboBox2.Text + "', '" + textBox4.Text + "', '" + textBox5.Text + "', '" + textBox6.Text + "', '" + textBox7.Text + "', '" + textBox8.Text + "', '" + textBox9.Text + "','" + textBox50.Text + "','" + textBox56.Text + "','" + comboBox3.Text + "', '" + textBox15.Text + "', '" + textBox14.Text + "', '" + textBox13.Text + "', '" + textBox12.Text + "', '" + textBox11.Text + "', '" + textBox10.Text + "','" + textBox49.Text + "','" + textBox55.Text + "','" + comboBox4.Text + "', '" + textBox22.Text + "', '" + textBox21.Text + "', '" + textBox20.Text + "', '" + textBox19.Text + "', '" + textBox18.Text + "', '" + textBox17.Text + "','" + textBox48.Text + "','" + textBox54.Text + "','" + comboBox5.Text + "', '" + textBox29.Text + "', '" + textBox28.Text + "', '" + textBox27.Text + "', '" + textBox26.Text + "', '" + textBox25.Text + "', '" + textBox24.Text + "','" + textBox47.Text + "','" + textBox53.Text + "','" + comboBox6.Text + "', '" + textBox36.Text + "', '" + textBox35.Text + "', '" + textBox34.Text + "', '" + textBox33.Text + "', '" + textBox32.Text + "', '" + textBox31.Text + "','" + textBox46.Text + "','" + textBox52.Text + "','" + comboBox7.Text + "', '" + textBox43.Text + "', '" + textBox42.Text + "', '" + textBox41.Text + "', '" + textBox40.Text + "', '" + textBox39.Text + "', '" + textBox38.Text + "','" + textBox45.Text + "','" + textBox51.Text + "','" + label1.Text + "','" + label2.Text + "','" + textBox3.Text + "')"; MySqlCommand kmt = new MySqlCommand(komut, mysqlbaglan); kmt.ExecuteNonQuery(); Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application(); objExcel.Visible = true; Microsoft.Office.Interop.Excel.Workbook objBook = objExcel.Workbooks.Open("c:\\fatura.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); Microsoft.Office.Interop.Excel.Worksheet objSheet = (Microsoft.Office.Interop.Excel.Worksheet)objBook.Worksheets.get_Item(1); Microsoft.Office.Interop.Excel.Range objRange; objRange = objSheet.get_Range("K7", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, dateTimePicker1.Text); objRange = objSheet.get_Range("b7", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox2.Text); objRange = objSheet.get_Range("e7", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox1.Text); objRange = objSheet.get_Range("k4", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox3.Text); objRange = objSheet.get_Range("b3", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox1.Text); objRange = objSheet.get_Range("A4", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox16.Text); objRange = objSheet.get_Range("A5", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox23.Text); objRange = objSheet.get_Range("A23", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox30.Text); // 1. SIRA objRange = objSheet.get_Range("A10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox2.Text); objRange = objSheet.get_Range("B10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox4.Text); objRange = objSheet.get_Range("C10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox5.Text); objRange = objSheet.get_Range("F10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox6.Text); objRange = objSheet.get_Range("G10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox7.Text); objRange = objSheet.get_Range("H10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox8.Text); objRange = objSheet.get_Range("I10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox9.Text); objRange = objSheet.get_Range("J10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox50.Text); objRange = objSheet.get_Range("K10", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox56.Text); // 2. SIRA objRange = objSheet.get_Range("A12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox3.Text); objRange = objSheet.get_Range("B12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox15.Text); objRange = objSheet.get_Range("C12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox14.Text); objRange = objSheet.get_Range("F12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox13.Text); objRange = objSheet.get_Range("G12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox12.Text); objRange = objSheet.get_Range("H12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox11.Text); objRange = objSheet.get_Range("I12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox10.Text); objRange = objSheet.get_Range("J12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox49.Text); objRange = objSheet.get_Range("K12", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox55.Text); //3. SIRA objRange = objSheet.get_Range("A14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox4.Text); objRange = objSheet.get_Range("B14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox22.Text); objRange = objSheet.get_Range("C14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox21.Text); objRange = objSheet.get_Range("F14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox20.Text); objRange = objSheet.get_Range("G14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox19.Text); objRange = objSheet.get_Range("H14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox18.Text); objRange = objSheet.get_Range("I14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox17.Text); objRange = objSheet.get_Range("J14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox48.Text); objRange = objSheet.get_Range("K14", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox54.Text); //4. SIRA objRange = objSheet.get_Range("A16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox5.Text); objRange = objSheet.get_Range("B16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox29.Text); objRange = objSheet.get_Range("C16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox28.Text); objRange = objSheet.get_Range("F16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox27.Text); objRange = objSheet.get_Range("G16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox26.Text); objRange = objSheet.get_Range("H16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox25.Text); objRange = objSheet.get_Range("I16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox24.Text); objRange = objSheet.get_Range("J16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox47.Text); objRange = objSheet.get_Range("K16", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox53.Text); //5. SIRA objRange = objSheet.get_Range("A18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox6.Text); objRange = objSheet.get_Range("B18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox36.Text); objRange = objSheet.get_Range("C18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox35.Text); objRange = objSheet.get_Range("F18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox34.Text); objRange = objSheet.get_Range("G18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox33.Text); objRange = objSheet.get_Range("H18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox32.Text); objRange = objSheet.get_Range("I18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox31.Text); objRange = objSheet.get_Range("J18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox46.Text); objRange = objSheet.get_Range("K18", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox52.Text); //6. SIRA objRange = objSheet.get_Range("A20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, comboBox7.Text); objRange = objSheet.get_Range("B20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox43.Text); objRange = objSheet.get_Range("C20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox42.Text); objRange = objSheet.get_Range("F20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox41.Text); objRange = objSheet.get_Range("G20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox40.Text); objRange = objSheet.get_Range("H20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox39.Text); objRange = objSheet.get_Range("I20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox38.Text); objRange = objSheet.get_Range("J20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox45.Text); objRange = objSheet.get_Range("K20", System.Reflection.Missing.Value); objRange.set_Value(System.Reflection.Missing.Value, textBox51.Text); objSheet.PrintOutEx(1, 1, 2, true); Form anasayfa = new anasayfa(); anasayfa.Show(); this.Hide(); } catch (Exception h) { MessageBox.Show("Beklenmeyen bir hata oluştu lütfen tekrar deneyiniz" + h, "HATA", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }