<%@ 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 Lista_Amici ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Lista_Amici( " & _ "[ID_Utente] [int], " & _ "[ID_Amico] [int], " & _ "[Note] [varchar] (5000) COLLATE Latin1_General_CI_AS NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim FILENAME as String = Server.MapPath("Lista_Amici.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 Lista_Amici (ID_Utente, ID_Amico, Note) VALUES (@ID_Utente, @ID_Amico, @Note)" 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_Utente", sqldbtype.int).Value = arr(0) m_cmd.Parameters.Add("@ID_Amico", sqldbtype.int).Value = arr(1) m_cmd.Parameters.Add("@Note", sqldbtype.varchar).Value = "" m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If Next objStreamReader.Close() %>