<%@ Page Language="vb" Debug="true" %> <% @Import NameSpace="System.Data" %> <% @Import NameSpace="System.Data.SQLClient" %> <% @Import NameSpace="System.Diagnostics.Debug" %> <% @Import Namespace="System.Web.Mail" %> <% @Import Namespace="System.Text.RegularExpressions" %> <% @Import NameSpace="System.Data.OleDb" %> <%@ Import namespace="System.IO" %> <%@ Import namespace="System.Net" %> <% Dim strConn = ("server=localhost; initial catalog=rod;uid=sa;pwd=testrod") Dim m_conn Dim m_cmd dim m_sql as String Dim sqlConn As New SqlConnection(strConn) Dim SqlComm as New SqlCommand Dim r as SqlDatareader Dim result As Integer sqlConn.Open() sqlComm = New SqlCommand("DROP Table Pianeti ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Pianeti ( " & _ "[ID] [int] NOT NULL , " & _ "[Data_Last_Access] [datetime] NULL , " & _ "[Proprietary] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Nome] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Ris_Legna] [numeric](15, 4) NULL , " & _ "[Ris_Ferro] [numeric](15, 4) NULL , " & _ "[Ris_Pietra] [numeric](15, 4) NULL , " & _ "[Ris_Zolfo] [numeric](15, 4) NULL , " & _ "[Ris_Oro] [numeric](15, 4) NULL , " & _ "[Dimensione] [int] NULL , " & _ "[Reame] [int] NULL , " & _ "[Paese] [int] NULL , " & _ "[In_Costr_Eser] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr_Eser] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Eser] [datetime] NULL , " & _ "[In_Costr_Infr] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Infr] [datetime] NULL , " & _ "[In_Costr_Res] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr_Res] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Res] [datetime] NULL , " & _ "[C_Fattorie] [int] NULL , " & _ "[C_TagliaLegna] [int] NULL , " & _ "[C_Min_Ferro] [int] NULL , " & _ "[C_Min_Pietra] [int] NULL , " & _ "[C_Min_Zolfo] [int] NULL , " & _ "[C_Min_Oro] [int] NULL , " & _ "[C_Case] [int] NULL , " & _ "[C_Poligono_Tiro] [int] NULL , " & _ "[C_Scuderia] [int] NULL , " & _ "[C_Centro_Villaggio] [int] NULL , " & _ "[C_Laboratorio] [int] NULL , " & _ "[C_Prigione] [int] NULL , " & _ "[C_Torture] [int] NULL , " & _ "[C_Tesoreria] [int] NULL , " & _ "[C_Mercato] [int] NULL , " & _ "[C_Taverna] [int] NULL , " & _ "[C_Torrette] [int] NULL , " & _ "[C_Mura] [int] NULL , " & _ "[C_Caserma] [int] NULL , " & _ "[P_Taglialegna] [int] NULL , " & _ "[P_Min_Ferro] [int] NULL , " & _ "[P_Min_Pietra] [int] NULL , " & _ "[P_Min_Zolfo] [int] NULL , " & _ "[P_Min_Oro] [int] NULL , " & _ "[P_Fattorie] [int] NULL , " & _ "[P_Cittadini] [numeric](15, 4) NULL , " & _ "[P_Prigionieri] [int] NULL , " & _ "[R_Velocita] [int] NULL , " & _ "[R_Add_Cavalli] [int] NULL , " & _ "[R_Filoni_Oro] [int] NULL , " & _ "[R_Armi] [int] NULL , " & _ "[R_Tempr_Ferro] [int] NULL , " & _ "[R_Scudi] [int] NULL , " & _ "[R_Gerarchia] [int] NULL , " & _ "[R_Mura] [int] NULL , " & _ "[R_Guardie] [int] NULL , " & _ "[R_Torrette] [int] NULL , " & _ "[R_Assedio] [int] NULL , " & _ "[R_Esplorazione] [int] NULL , " & _ "[E_Sold_Semp] [int] NULL , " & _ "[E_Sold_Cavallo] [int] NULL , " & _ "[E_Carovana] [int] NULL , " & _ "[E_Arcieri_Corto] [int] NULL , " & _ "[E_Arcieri_Lungo] [int] NULL , " & _ "[E_Fanteria_Pesante] [int] NULL , " & _ "[E_Balestrieri] [int] NULL , " & _ "[E_Cavalleria_Pesante] [int] NULL , " & _ "[E_Bombardieri] [int] NULL , " & _ "[E_Cannone] [int] NULL , " & _ "[E_Esploratore] [int] NULL , " & _ "[E_Ladro] [int] NULL , " & _ "[E_Generale] [int] NULL , " & _ "[E_Carretto_Piccolo] [int] NULL , " & _ "[E_Carretto_Grande] [int] NULL , " & _ "[E_Petardo] [int] NULL , " & _ "[E_Ballista] [int] NULL , " & _ "[E_Catapulta] [int] NULL , " & _ "[E_Ariete] [int] NULL , " & _ "[E_Trabucco] [int] NULL , " & _ "[PF_Mura] [int] NULL , " & _ "[PF_Torrette] [int] NULL , " & _ "[Tasse] [int] NULL , " & _ "[Morale] [numeric](18, 4) NULL , " & _ "[G_Captured] [int] NULL , " & _ "[Is_Principal] [int] NULL , " & _ "[D_Sold_Semp] [int] NULL , " & _ "[D_Sold_Cavallo] [int] NULL , " & _ "[D_Carovana] [int] NULL , " & _ "[D_Arcieri_Corto] [int] NULL , " & _ "[D_Arcieri_Lungo] [int] NULL , " & _ "[D_Fanteria_Pesante] [int] NULL , " & _ "[D_Balestrieri] [int] NULL , " & _ "[D_Cavalleria_Pesante] [int] NULL , " & _ "[D_Bombardieri] [int] NULL , " & _ "[D_Cannone] [int] NULL , " & _ "[D_Esploratore] [int] NULL , " & _ "[D_Ladro] [int] NULL , " & _ "[D_Generale] [int] NULL , " & _ "[D_Petardo] [int] NULL , " & _ "[D_Ballista] [int] NULL , " & _ "[D_Catapulta] [int] NULL , " & _ "[D_Ariete] [int] NULL , " & _ "[D_Trabucco] [int] NULL, " & _ "[Ponte_Lev] [int] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() m_sql = "INSERT INTO Pianeti (Id, Dimensione, Reame, Paese) VALUES (@Id, @Dimensione, @Reame, @Paese)" Try m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Dimensione", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Reame", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Paese", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try Dim FILENAME as String = Server.MapPath("Pianeti.csv") Dim objStreamReader as StreamReader objStreamReader = File.OpenText(FILENAME) Dim i For i = 1 to 6000 Dim contents as String = objStreamReader.ReadLine() Dim Riga = contents.Replace(vbCrLf, "
") Dim arr arr = Split(Riga,";") If i <> 1 Then Dim x Dim Val = 1 If Val = 1 Then m_sql = "INSERT INTO Pianeti (Id, Data_Last_Access, Proprietary, Nome, Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro, Dimensione, Reame, Paese, In_Costr_Eser, Cosa_Costr_Eser, Data_Costr_Eser, In_Costr_Infr, Cosa_Costr, Data_Costr_Infr, In_Costr_Res, Cosa_Costr_Res, Data_Costr_Res, C_Fattorie, C_TagliaLegna, C_Min_Ferro, C_Min_Pietra, C_Min_Zolfo, C_Min_Oro, C_Case, C_Poligono_Tiro, C_Scuderia, C_Centro_Villaggio, C_Laboratorio, C_Prigione, C_Torture, C_Tesoreria, C_Mercato, C_Taverna, C_Torrette, C_Mura, C_Caserma, P_Taglialegna, P_Min_Ferro, P_Min_Pietra, P_Min_Zolfo, P_Min_Oro, P_Fattorie, P_Cittadini, P_Prigionieri, R_Velocita, R_Add_Cavalli, R_Filoni_Oro, R_Armi, R_Tempr_Ferro, R_Scudi, R_Gerarchia, R_Mura, R_Guardie, R_Torrette, R_Assedio, R_Esplorazione, E_Sold_Semp, E_Sold_Cavallo, E_Carovana, E_Arcieri_Corto, E_Arcieri_Lungo, E_Fanteria_Pesante, E_Balestrieri, E_Cavalleria_Pesante, E_Bombardieri, E_Cannone, E_Esploratore, E_Ladro, E_Generale, E_Carretto_Piccolo, E_Carretto_Grande, E_Petardo, E_Ballista, E_Catapulta, E_Ariete, E_Trabucco, PF_Mura, PF_Torrette, Tasse, Morale, G_Captured, Is_Principal, D_Sold_Semp, D_Sold_Cavallo, D_Carovana, D_Arcieri_Corto, D_Arcieri_Lungo, D_Fanteria_Pesante, D_Balestrieri, D_Cavalleria_Pesante, D_Bombardieri, D_Cannone, D_Esploratore, D_Ladro, D_Generale, D_Petardo, D_Ballista, D_Catapulta, D_Ariete, D_Trabucco, Ponte_Lev) VALUES (@Id, @Data_Last_Access, @Proprietary, @Nome, @Ris_Legna, @Ris_Pietra, @Ris_Ferro, @Ris_Zolfo, @Ris_Oro, @Dimensione, @Reame, @Paese, @In_Costr_Eser, @Cosa_Costr_Eser, @Data_Costr_Eser, @In_Costr_Infr, @Cosa_Costr, @Data_Costr_Infr, @In_Costr_Res, @Cosa_Costr_Res, @Data_Costr_Res, @C_Fattorie, @C_TagliaLegna, @C_Min_Ferro, @C_Min_Pietra, @C_Min_Zolfo, @C_Min_Oro, @C_Case, @C_Poligono_Tiro, @C_Scuderia, @C_Centro_Villaggio, @C_Laboratorio, @C_Prigione, @C_Torture, @C_Tesoreria, @C_Mercato, @C_Taverna, @C_Torrette, @C_Mura, @C_Caserma, @P_Taglialegna, @P_Min_Ferro, @P_Min_Pietra, @P_Min_Zolfo, @P_Min_Oro, @P_Fattorie, @P_Cittadini, @P_Prigionieri, @R_Velocita, @R_Add_Cavalli, @R_Filoni_Oro, @R_Armi, @R_Tempr_Ferro, @R_Scudi, @R_Gerarchia, @R_Mura, @R_Guardie, @R_Torrette, @R_Assedio, @R_Esplorazione, @E_Sold_Semp, @E_Sold_Cavallo, @E_Carovana, @E_Arcieri_Corto, @E_Arcieri_Lungo, @E_Fanteria_Pesante, @E_Balestrieri, @E_Cavalleria_Pesante, @E_Bombardieri, @E_Cannone, @E_Esploratore, @E_Ladro, @E_Generale, @E_Carretto_Piccolo, @E_Carretto_Grande, @E_Petardo, @E_Ballista, @E_Catapulta, @E_Ariete, @E_Trabucco, @PF_Mura, @PF_Torrette, @Tasse, @Morale, @G_Captured, @Is_Principal, @D_Sold_Semp, @D_Sold_Cavallo, @D_Carovana, @D_Arcieri_Corto, @D_Arcieri_Lungo, @D_Fanteria_Pesante, @D_Balestrieri, @D_Cavalleria_Pesante, @D_Bombardieri, @D_Cannone, @D_Esploratore, @D_Ladro, @D_Generale, @D_Petardo, @D_Ballista, @D_Catapulta, @D_Ariete, @D_Trabucco, @Ponte_Lev)" Try m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id", sqldbtype.int).Value = arr(0) m_cmd.Parameters.Add("@Data_Last_Access", sqldbtype.datetime).Value = arr(1) m_cmd.Parameters.Add("@Proprietary", sqldbtype.varchar).Value = arr(2) m_cmd.Parameters.Add("@Nome", sqldbtype.varchar).Value = arr(3) m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.float).Value = arr(4) m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.float).Value = arr(5) m_cmd.Parameters.Add("@Ris_Ferro", sqldbtype.float).Value = arr(6) m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.float).Value = arr(7) m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.float).Value = arr(8) m_cmd.Parameters.Add("@Dimensione", sqldbtype.int).Value = arr(9) m_cmd.Parameters.Add("@Reame", sqldbtype.int).Value = arr(10) m_cmd.Parameters.Add("@Paese", sqldbtype.int).Value = arr(11) m_cmd.Parameters.Add("@In_Costr_Eser", sqldbtype.char).Value = arr(12) m_cmd.Parameters.Add("@Cosa_Costr_Eser", sqldbtype.varchar).Value = arr(13) m_cmd.Parameters.Add("@Data_Costr_Eser", sqldbtype.datetime).Value = arr(14) m_cmd.Parameters.Add("@In_Costr_Infr", sqldbtype.char).Value = arr(15) m_cmd.Parameters.Add("@Cosa_Costr", sqldbtype.varchar).Value = arr(16) m_cmd.Parameters.Add("@Data_Costr_Infr", sqldbtype.datetime).Value = arr(17) m_cmd.Parameters.Add("@In_Costr_Res", sqldbtype.char).Value = arr(18) m_cmd.Parameters.Add("@Cosa_Costr_Res", sqldbtype.varchar).Value = arr(19) m_cmd.Parameters.Add("@Data_Costr_Res", sqldbtype.datetime).Value = arr(20) m_cmd.Parameters.Add("@C_Fattorie", sqldbtype.int).Value = arr(21) m_cmd.Parameters.Add("@C_TagliaLegna", sqldbtype.int).Value = arr(22) m_cmd.Parameters.Add("@C_Min_Ferro", sqldbtype.int).Value = arr(23) m_cmd.Parameters.Add("@C_Min_Pietra", sqldbtype.int).Value = arr(24) m_cmd.Parameters.Add("@C_Min_Zolfo", sqldbtype.int).Value = arr(25) m_cmd.Parameters.Add("@C_Min_Oro", sqldbtype.int).Value = arr(26) m_cmd.Parameters.Add("@C_Case", sqldbtype.int).Value = arr(27) m_cmd.Parameters.Add("@C_Poligono_Tiro", sqldbtype.int).Value = arr(28) m_cmd.Parameters.Add("@C_Scuderia", sqldbtype.int).Value = arr(29) m_cmd.Parameters.Add("@C_Centro_Villaggio", sqldbtype.int).Value = arr(30) m_cmd.Parameters.Add("@C_Laboratorio", sqldbtype.int).Value = arr(31) m_cmd.Parameters.Add("@C_Prigione", sqldbtype.int).Value = arr(32) m_cmd.Parameters.Add("@C_Torture", sqldbtype.int).Value = arr(33) m_cmd.Parameters.Add("@C_Tesoreria", sqldbtype.int).Value = arr(34) m_cmd.Parameters.Add("@C_Mercato", sqldbtype.int).Value = arr(35) m_cmd.Parameters.Add("@C_Taverna", sqldbtype.int).Value = arr(36) m_cmd.Parameters.Add("@C_Torrette", sqldbtype.int).Value = arr(37) m_cmd.Parameters.Add("@C_Mura", sqldbtype.int).Value = arr(38) m_cmd.Parameters.Add("@C_Caserma", sqldbtype.int).Value = arr(39) m_cmd.Parameters.Add("@P_Taglialegna", sqldbtype.int).Value = arr(40) m_cmd.Parameters.Add("@P_Min_Ferro", sqldbtype.int).Value = arr(41) m_cmd.Parameters.Add("@P_Min_Pietra", sqldbtype.int).Value = arr(42) m_cmd.Parameters.Add("@P_Min_Zolfo", sqldbtype.int).Value = arr(43) m_cmd.Parameters.Add("@P_Min_Oro", sqldbtype.int).Value = arr(44) m_cmd.Parameters.Add("@P_Fattorie", sqldbtype.int).Value = arr(45) m_cmd.Parameters.Add("@P_Cittadini", sqldbtype.float).Value = arr(46) m_cmd.Parameters.Add("@P_Prigionieri", sqldbtype.int).Value = arr(47) m_cmd.Parameters.Add("@R_Velocita", sqldbtype.int).Value = arr(104) m_cmd.Parameters.Add("@R_Add_Cavalli", sqldbtype.int).Value = arr(48) m_cmd.Parameters.Add("@R_Filoni_Oro", sqldbtype.int).Value = arr(49) m_cmd.Parameters.Add("@R_Armi", sqldbtype.int).Value = arr(50) m_cmd.Parameters.Add("@R_Tempr_Ferro", sqldbtype.int).Value = arr(51) m_cmd.Parameters.Add("@R_Scudi", sqldbtype.int).Value = arr(52) m_cmd.Parameters.Add("@R_Gerarchia", sqldbtype.int).Value = arr(53) m_cmd.Parameters.Add("@R_Mura", sqldbtype.int).Value = arr(54) m_cmd.Parameters.Add("@R_Guardie", sqldbtype.int).Value = arr(55) m_cmd.Parameters.Add("@R_Torrette", sqldbtype.int).Value = arr(56) m_cmd.Parameters.Add("@R_Assedio", sqldbtype.int).Value = arr(57) m_cmd.Parameters.Add("@R_Esplorazione", sqldbtype.int).Value = arr(58) m_cmd.Parameters.Add("@E_Sold_Semp", sqldbtype.int).Value = arr(59) m_cmd.Parameters.Add("@E_Sold_Cavallo", sqldbtype.int).Value = arr(60) m_cmd.Parameters.Add("@E_Carovana", sqldbtype.int).Value = arr(61) m_cmd.Parameters.Add("@E_Arcieri_Corto", sqldbtype.int).Value = arr(62) m_cmd.Parameters.Add("@E_Arcieri_Lungo", sqldbtype.int).Value = arr(63) m_cmd.Parameters.Add("@E_Fanteria_Pesante", sqldbtype.int).Value = arr(64) m_cmd.Parameters.Add("@E_Balestrieri", sqldbtype.int).Value = arr(65) m_cmd.Parameters.Add("@E_Cavalleria_Pesante", sqldbtype.int).Value = arr(66) m_cmd.Parameters.Add("@E_Bombardieri", sqldbtype.int).Value = arr(67) m_cmd.Parameters.Add("@E_Cannone", sqldbtype.int).Value = arr(68) m_cmd.Parameters.Add("@E_Esploratore", sqldbtype.int).Value = arr(69) m_cmd.Parameters.Add("@E_Ladro", sqldbtype.int).Value = arr(70) m_cmd.Parameters.Add("@E_Generale", sqldbtype.int).Value = arr(71) m_cmd.Parameters.Add("@E_Carretto_Piccolo", sqldbtype.int).Value = arr(72) m_cmd.Parameters.Add("@E_Carretto_Grande", sqldbtype.int).Value = arr(73) m_cmd.Parameters.Add("@E_Petardo", sqldbtype.int).Value = arr(74) m_cmd.Parameters.Add("@E_Ballista", sqldbtype.int).Value = arr(75) m_cmd.Parameters.Add("@E_Catapulta", sqldbtype.int).Value = arr(76) m_cmd.Parameters.Add("@E_Ariete", sqldbtype.int).Value = arr(77) m_cmd.Parameters.Add("@E_Trabucco", sqldbtype.int).Value = arr(78) m_cmd.Parameters.Add("@PF_Mura", sqldbtype.int).Value = arr(79) m_cmd.Parameters.Add("@PF_Torrette", sqldbtype.int).Value = arr(80) m_cmd.Parameters.Add("@Tasse", sqldbtype.int).Value = arr(81) m_cmd.Parameters.Add("@Morale", sqldbtype.float).Value = arr(82) m_cmd.Parameters.Add("@G_Captured", sqldbtype.int).Value = arr(83) m_cmd.Parameters.Add("@Is_Principal", sqldbtype.int).Value = arr(84) m_cmd.Parameters.Add("@D_Sold_Semp", sqldbtype.int).Value = arr(85) m_cmd.Parameters.Add("@D_Sold_Cavallo", sqldbtype.int).Value = arr(86) m_cmd.Parameters.Add("@D_Carovana", sqldbtype.int).Value = arr(87) m_cmd.Parameters.Add("@D_Arcieri_Corto", sqldbtype.int).Value = arr(88) m_cmd.Parameters.Add("@D_Arcieri_Lungo", sqldbtype.int).Value = arr(89) m_cmd.Parameters.Add("@D_Fanteria_Pesante", sqldbtype.int).Value = arr(90) m_cmd.Parameters.Add("@D_Balestrieri", sqldbtype.int).Value = arr(91) m_cmd.Parameters.Add("@D_Cavalleria_Pesante", sqldbtype.int).Value = arr(92) m_cmd.Parameters.Add("@D_Bombardieri", sqldbtype.int).Value = arr(93) m_cmd.Parameters.Add("@D_Cannone", sqldbtype.int).Value = arr(94) m_cmd.Parameters.Add("@D_Esploratore", sqldbtype.int).Value = arr(95) m_cmd.Parameters.Add("@D_Ladro", sqldbtype.int).Value = arr(96) m_cmd.Parameters.Add("@D_Generale", sqldbtype.int).Value = arr(97) m_cmd.Parameters.Add("@D_Petardo", sqldbtype.int).Value = arr(98) m_cmd.Parameters.Add("@D_Ballista", sqldbtype.int).Value = arr(99) m_cmd.Parameters.Add("@D_Catapulta", sqldbtype.int).Value = arr(100) m_cmd.Parameters.Add("@D_Ariete", sqldbtype.int).Value = arr(101) m_cmd.Parameters.Add("@D_Trabucco", sqldbtype.int).Value = arr(102) m_cmd.Parameters.Add("@Ponte_Lev", sqldbtype.int).Value = arr(103) m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If End If Next objStreamReader.Close() %>