<%@ 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 Soldati_In_Missione ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Soldati_In_Missione ( " & _ "[Id_Soldato] [int] NULL , " & _ "[Id_Missione] [int] NULL , " & _ "[Type_Soldato] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Quantity_Soldato] [int] NULL , " & _ "[PF] [int] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim FILENAME as String = Server.MapPath("Soldati_In_Missione.csv") Dim objStreamReader as StreamReader objStreamReader = File.OpenText(FILENAME) Dim i For i = 1 to 20000 Dim contents as String = objStreamReader.ReadLine() Dim Riga = contents.Replace(vbCrLf, "
") Dim arr arr = Split(Riga,";") If arr(4) = "" Then arr(4) = 0 End If Dim x Dim Val = 1 If Val = 1 Then m_sql = "INSERT INTO Soldati_In_Missione (Id_Soldato, Id_Missione, Type_Soldato, Quantity_Soldato, PF ) VALUES (@Id_Soldato, @Id_Missione, @Type_Soldato, @Quantity_Soldato, @PF )" 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_Soldato", sqldbtype.int).Value = arr(0) m_cmd.Parameters.Add("@Id_Missione", sqldbtype.int).Value = arr(1) m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = arr(2) m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = arr(3) m_cmd.Parameters.Add("@PF", sqldbtype.int).Value = arr(4) m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If Next objStreamReader.Close() %>