private void statistikaToolStripMenuItem_Click(object sender, EventArgs e) { statistikaForm f5 = new statistikaForm(); f5.ShowDialog(); }
private void bttnUcitaj_Click(object sender, EventArgs e) { try { //učitavanje Excel komentara u tablicu za komentare 'tblImportKomentari' string PathConn1 = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + textBoxPathKomentari.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";"; OleDbConnection oleDBkonekcija = new OleDbConnection(PathConn1); SqlConnection konekcija = new SqlConnection(@"Data Source=LOVRA-PC;Initial Catalog=PulsDB;Integrated Security=True"); //konekcijski string za povezivanje na bazu 'PulsDB' na mom lokalnom serveru 'LOVRA-PC' konekcija.Open(); //otvaramo konekciju na bazu SqlCommand command1 = new SqlCommand("DELETE FROM tblImportStatistics", konekcija); //Query za brisanje podataka iz tablice 'tblImportKomentari'. command1.ExecuteNonQuery(); //izvršavanje query-a zapisanog u 'command1' SqlCommand command2 = new SqlCommand("DELETE FROM tblImportKomentari", konekcija); //Query za brisanje podataka iz tablice 'tblImportStatistics'. command2.ExecuteNonQuery(); //izvršavanje query-a zapisanog u 'command2' OleDbCommand selection = new OleDbCommand("SELECT * FROM [Sheet1$]", oleDBkonekcija); OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.SelectCommand = selection; DataSet ds = new DataSet(); adapter.Fill(ds); komentariKontroleForm kkF = new komentariKontroleForm(); kkF.tblImportKomentariDataGridView.DataSource = ds.Tables[0]; oleDBkonekcija.Close(); SqlBulkCopy import = new SqlBulkCopy(konekcija); import.DestinationTableName = "tblImportKomentari"; import.WriteToServer(ds.Tables[0]); //učitavanje Excel statistike u tablicu za statistiku 'tblImportStatistics' string PathConn2 = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + txtboxPathStatistika.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";"; OleDbConnection oleDbkonekcija2 = new OleDbConnection(PathConn2); OleDbCommand selection2 = new OleDbCommand("SELECT * FROM [List1$]", oleDbkonekcija2); OleDbDataAdapter adapter2 = new OleDbDataAdapter(); adapter2.SelectCommand = selection2; DataSet ds2 = new DataSet(); adapter2.Fill(ds2); statistikaForm sF = new statistikaForm(); sF.tblImportStatisticsDataGridView.DataSource = ds2.Tables[0]; oleDbkonekcija2.Close(); SqlBulkCopy import2 = new SqlBulkCopy(konekcija); import2.DestinationTableName = "tblImportStatistics"; import2.WriteToServer(ds2.Tables[0]); konekcija.Close(); //zatvaramo konekciju na bazu //Opening second form this.Hide(); kompletnaStatistikaForm f5 = new kompletnaStatistikaForm(); f5.ShowDialog(); this.Close(); } catch { MessageBox.Show("Došlo je do pogreške prilikom učitavanja.\n\nProvjerite sve i pokušajte ponovno."); } }