<%@ 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 Utenti ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Utenti ( " & _ "[Fama] [int] NULL , " & _ "[Last_Access] [datetime] NULL , " & _ "[Last_Id] [int] NULL , " & _ "[Gilda] [char] (3) NULL , " & _ "[Grado_Gilda] [int] NULL , " & _ "[Initial_Ip] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Accetta_Termini] [char] (7) COLLATE Latin1_General_CI_AS NULL , " & _ "[Icq_Uin] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , " & _ "[Msn] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Browser] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[username] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[password] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[id] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Background] [varchar] (5000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Email] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Attivo] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Premium_Check] [char] (1) COLLATE Latin1_General_CI_AS NULL , " & _ "[Premium_Data] [datetime] NULL , " & _ "[Registration_Data] [datetime] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim FILENAME as String = Server.MapPath("Utenti.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,";") Dim x Dim Val = 1 If Val = 1 Then m_sql = "INSERT INTO Utenti (Username, Password, Email, Attivo, Fama, Initial_Ip, Accetta_Termini, Icq_Uin, Msn, Gilda, Last_Id, Grado_Gilda, Premium_Check, Premium_Data, Registration_Data ) VALUES (@Username, @Password, @Email, @Attivo, @Fama, @Initial_Ip, @Accetta_Termini, @Icq_Uin, @Msn, @Gilda, @Last_Id, @Grado_Gilda, @Premium_Check, @Premium_Data, @Registration_Data)" Try m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Fama", sqldbtype.int).Value = arr(0) m_cmd.Parameters.Add("@Last_Id", sqldbtype.varchar).Value = arr(2) m_cmd.Parameters.Add("@Gilda", sqldbtype.varchar).Value = arr(3) m_cmd.Parameters.Add("@Grado_Gilda", sqldbtype.varchar).Value = arr(4) m_cmd.Parameters.Add("@Initial_Ip", sqldbtype.varchar).Value = arr(5) m_cmd.Parameters.Add("@Accetta_Termini", sqldbtype.varchar).Value = arr(6) m_cmd.Parameters.Add("@Icq_Uin", sqldbtype.varchar).Value = arr(7) m_cmd.Parameters.Add("@Username", sqldbtype.varchar).Value = arr(8) m_cmd.Parameters.Add("@Password", sqldbtype.varchar).Value = arr(9) m_cmd.Parameters.Add("@Id", sqldbtype.int).Value = arr(10) 'm_cmd.Parameters.Add("@Background", sqldbtype.varchar).Value = arr(11) m_cmd.Parameters.Add("@Email", sqldbtype.varchar).Value = arr(12) m_cmd.Parameters.Add("@Attivo", sqldbtype.varchar).Value = arr(13) m_cmd.Parameters.Add("@Msn", sqldbtype.varchar).Value = arr(14) m_cmd.Parameters.Add("@Browser", sqldbtype.varchar).Value = arr(15) m_cmd.Parameters.Add("@Premium_Check", sqldbtype.char).Value = arr(16) m_cmd.Parameters.Add("@Premium_Data", sqldbtype.datetime).Value = arr(17) m_cmd.Parameters.Add("@Registration_Data", sqldbtype.datetime).Value = "23/11/2005 15.22.05" m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If Next objStreamReader.Close() %>