<%@ 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 Gilde ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Gilde ( " & _ "[ID] [int] NOT NULL , " & _ "[Nome] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Tag] [char] (3) NULL , " & _ "[Descrizione] [varchar] (5000) NULL , " & _ "[Grado_1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_2] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_3] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_4] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_5] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim FILENAME as String = Server.MapPath("Gilde.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 Gilde (ID, Nome, Tag, Descrizione, Grado_1, Grado_2, Grado_3, Grado_4, Grado_5) VALUES (@ID, @Nome, @Tag, @Descrizione, @Grado_1, @Grado_2, @Grado_3, @Grado_4, @Grado_5)" 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("@Nome", sqldbtype.varchar).Value = arr(1) m_cmd.Parameters.Add("@Tag", sqldbtype.char).Value = arr(2) m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "" m_cmd.Parameters.Add("@Grado_1", sqldbtype.varchar).Value = arr(4) m_cmd.Parameters.Add("@Grado_2", sqldbtype.varchar).Value = arr(5) m_cmd.Parameters.Add("@Grado_3", sqldbtype.varchar).Value = arr(6) m_cmd.Parameters.Add("@Grado_4", sqldbtype.varchar).Value = arr(7) m_cmd.Parameters.Add("@Grado_5", sqldbtype.varchar).Value = arr(8) m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If Next objStreamReader.Close() %>