Torna al Thread

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click Dim path As String = Server.MapPath("Export\MyTest.csv") Dim sw As StreamWriter = File.CreateText(path) Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + MapPath("App_Data\nome_database_access.mdb") Dim strSQL As String = "SELECT * FROM [nome_tabella]" Dim strResultsHolder As String = "" Dim objConnection As OleDbConnection = New OleDbConnection(strConnection) Dim objCommand As OleDbCommand = New OleDbCommand(strSQL, objConnection) Dim objDataReader As OleDbDataReader = Nothing Try objConnection.Open() con_open.Text = "Connection opened successfully.<br>" objDataReader = objCommand.ExecuteReader While (objDataReader.Read = True) 'Questa parte serve per scrivere su divList il risultato strResultsHolder = (strResultsHolder + objDataReader("nome_colonna_1")) strResultsHolder = (strResultsHolder + " ") strResultsHolder = (strResultsHolder + objDataReader("nome_colonna_2")) strResultsHolder = (strResultsHolder + "<br/>") 'Questo per scrivere sul file sw.WriteLine(objDataReader("nome_colonna_1") + ", " + objDataReader("nome_colonna_2")) End While sw.Flush() sw.Close() objDataReader.Close() objConnection.Close() con_close.Text = "<br/>Connection closed.<br/>" divList.InnerHtml = strResultsHolder Catch ex As Exception con_open.Text = "Connection failed to open successfully.<br/>" con_close.Text = e.ToString End Try 'End If End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5