Export Data from SQL Table into text file

[ryoka012]

Hi,

As state in my Title how can i export it on text file
By using Datasource.

DataGridView.Columns.Clear()
        Dim con As New SqlConnection(SQLConn)
 
            con.Open()
            Dim cmd As SqlCommand = con.CreateCommand
            cmd.CommandText = "Select * from Table"
            cmd.CommandType = CommandType.Text
            Dim dr As SqlDataReader = cmd.ExecuteReader
            Dim dt As New DataTable
            dt.Load(dr)
            DataGridView.DataSource = dt

Appreciate you help..

 

[Clflyer]

FileOpen(1, "Text.txt", OpenMode.Output)
Dim ARecord As String = ""
For Each ARecord In DT
PrintLine(1, ARecord)
Next
FileClose()