<%@ 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 Vacanza ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Vacanza( " & _ "[ID] [int] NOT NULL , " & _ "[Id_Utente] [int] NOT NULL , " & _ "[Data_Inizio] [datetime] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim FILENAME as String = Server.MapPath("Vacanza.csv") Dim objStreamReader as StreamReader objStreamReader = File.OpenText(FILENAME) Dim i For i = 1 to 10000 Dim contents as String = objStreamReader.ReadLine() Dim Riga = contents.Replace(vbCrLf, "
") Dim arr arr = Split(Riga,";") Dim x Dim Val = 1 If Val = 1 Then m_sql = "INSERT INTO Vacanza (ID, Id_Utente, Data_Inizio) VALUES (@ID, @Id_Utente, @Data_Inizio)" 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("@Id_Utente", sqldbtype.int).Value = arr(1) m_cmd.Parameters.Add("@Data_Inizio", sqldbtype.datetime).Value = arr(2) m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If Next objStreamReader.Close() %>