<%@ 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 Missioni ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Missioni ( " & _ "[ID] [int] NOT NULL , " & _ "[Type_Mission] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Time_Started] [datetime] NULL , " & _ "[Time_Arrive] [datetime] NULL , " & _ "[Army_Of] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Dimensione_Started] [int] NULL , " & _ "[Reame_Started] [int] NULL , " & _ "[Paese_Started] [int] NULL , " & _ "[Dimensione_Arrive] [int] NULL , " & _ "[Reame_Arrive] [int] NULL , " & _ "[Paese_Arrive] [int] NULL , " & _ "[Ris_Legna] [int] NULL , " & _ "[Ris_Pietra] [int] NULL , " & _ "[Ris_Ferro] [int] NULL , " & _ "[Ris_Zolfo] [int] NULL , " & _ "[Ris_Oro] [int] NULL , " & _ "[Morti_Atk] [int] NULL , " & _ "[Morti_Ass] [int] NULL , " & _ "[Winner] [char] (3) COLLATE Latin1_General_CI_AS NULL , " & _ "[Avviso] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Ric_Legna] [int] NULL , " & _ "[Ric_Pietra] [int] NULL , " & _ "[Ric_Ferro] [int] NULL , " & _ "[Ric_Zolfo] [int] NULL , " & _ "[Ric_Oro] [int] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim FILENAME as String = Server.MapPath("Missioni.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 arr(20) = "" Then arr(20) = 0 End If If arr(21) = "" Then arr(21) = 0 End If If arr(22) = "" Then arr(22) = 0 End If If arr(23) = "" Then arr(23) = 0 End If If arr(24) = "" Then arr(24) = 0 End If If arr(16) = "" Then arr(16) = 0 End If If arr(17) = "" Then arr(17) = 0 End If If arr(18) = "" Then arr(18) = 0 End If If arr(8) = "" Then arr(8) = 0 End If If arr(9) = "" Then arr(9) = 0 End If If arr(10) = "" Then arr(10) = 0 End If Dim x Dim Val = 1 If Val = 1 Then m_sql = "INSERT INTO Missioni (ID, Type_Mission, Time_Started, Time_Arrive, Army_Of, Dimensione_Started, Reame_Started, Paese_Started, Dimensione_Arrive, Reame_Arrive, Paese_Arrive, Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro, Morti_Atk, Morti_Ass, Winner, Avviso, Ric_Legna, Ric_Pietra, Ric_Ferro, Ric_Zolfo, Ric_Oro) VALUES (@ID, @Type_Mission, @Time_Started, @Time_Arrive, @Army_Of, @Dimensione_Started, @Reame_Started, @Paese_Started, @Dimensione_Arrive, @Reame_Arrive, @Paese_Arrive, @Ris_Legna, @Ris_Pietra, @Ris_Ferro, @Ris_Zolfo, @Ris_Oro, @Morti_Atk, @Morti_Ass, @Winner, @Avviso, @Ric_Legna, @Ric_Pietra, @Ric_Ferro, @Ric_Zolfo, @Ric_Oro)" 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("@Type_Mission", sqldbtype.varchar).Value = arr(1) m_cmd.Parameters.Add("@Time_Started", sqldbtype.datetime).Value = arr(2) m_cmd.Parameters.Add("@Time_Arrive", sqldbtype.datetime).Value = arr(3) m_cmd.Parameters.Add("@Army_Of", sqldbtype.varchar).Value = arr(4) m_cmd.Parameters.Add("@Dimensione_Started", sqldbtype.int).Value = arr(5) m_cmd.Parameters.Add("@Reame_Started", sqldbtype.int).Value = arr(6) m_cmd.Parameters.Add("@Paese_Started", sqldbtype.int).Value = arr(7) m_cmd.Parameters.Add("@Dimensione_Arrive", sqldbtype.int).Value = arr(8) m_cmd.Parameters.Add("@Reame_Arrive", sqldbtype.int).Value = arr(9) m_cmd.Parameters.Add("@Paese_Arrive", sqldbtype.int).Value = arr(10) m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.float).Value = arr(11) m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.float).Value = arr(12) m_cmd.Parameters.Add("@Ris_Ferro", sqldbtype.float).Value = arr(13) m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.float).Value = arr(14) m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.float).Value = arr(15) m_cmd.Parameters.Add("@Morti_Atk", sqldbtype.int).Value = arr(16) m_cmd.Parameters.Add("@Morti_Ass", sqldbtype.int).Value = arr(17) m_cmd.Parameters.Add("@Winner", sqldbtype.char).Value = arr(18) m_cmd.Parameters.Add("@Avviso", sqldbtype.char).Value = arr(19) m_cmd.Parameters.Add("@Ric_Legna", sqldbtype.float).Value = arr(20) m_cmd.Parameters.Add("@Ric_Pietra", sqldbtype.float).Value = arr(21) m_cmd.Parameters.Add("@Ric_Ferro", sqldbtype.float).Value = arr(22) m_cmd.Parameters.Add("@Ric_Zolfo", sqldbtype.float).Value = arr(23) m_cmd.Parameters.Add("@Ric_Oro", sqldbtype.float).Value = arr(24) m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If Next objStreamReader.Close() %>