<%@ 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 Generali ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Generali( " & _ "[ID] [int] NOT NULL , " & _ "[Dimensione] [int] NULL , " & _ "[Reame] [int] NULL , " & _ "[Paese] [int] NULL , " & _ "[Is_Dead] [int] NULL , " & _ "[Nome] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Scheda] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Proprietary] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Exp] [int] NULL , " & _ "[Livello] [numeric](15, 4) NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim FILENAME as String = Server.MapPath("Generali.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,";") If arr(9) = "Null" Then arr(9) = "" End If Dim x Dim Val = 1 If Val = 1 Then If arr(0) < 5794 OR arr(0) > 5803 tHEN m_sql = "INSERT INTO Generali (ID, Dimensione, Reame, Paese, Is_Dead, Nome, Scheda, Proprietary, Exp, Livello) VALUES (@ID, @Dimensione, @Reame, @Paese, @Is_Dead, @Nome, @Scheda, @Proprietary, @Exp, @Livello)" 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("@Dimensione", sqldbtype.int).Value = arr(1) m_cmd.Parameters.Add("@Reame", sqldbtype.int).Value = arr(2) m_cmd.Parameters.Add("@Paese", sqldbtype.int).Value = arr(3) m_cmd.Parameters.Add("@Is_Dead", sqldbtype.int).Value = arr(4) m_cmd.Parameters.Add("@Nome", sqldbtype.varchar).Value = arr(5) m_cmd.Parameters.Add("@Scheda", sqldbtype.varchar).Value = "" m_cmd.Parameters.Add("@Proprietary", sqldbtype.varchar).Value = arr(7) m_cmd.Parameters.Add("@Exp", sqldbtype.int).Value = arr(8) m_cmd.Parameters.Add("@Livello", sqldbtype.float).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If End If Next objStreamReader.Close() %>