Save as Text

  • Thread starter Thread starter blackdevil1979
  • Start date Start date
Hi Blackdevil,

When you use a dataset as datasource you can save it as
dataset1.writeXML('Mypath")

In my opinon is saving a table as a textfile until now always been
impossible, while you can read that XML in the newer versions of most office
programs.

I hope this helps?

Cor
 
Well... i can see all the data is there... but...

-how to make it look better with the <.....>?? and.
-to show one record per line....

thanx.. :)
 
Hi Blackdevil,

Did you know that it is easier to reply as follow up messages to the one who
answers you, that has more change that you get answers.

Now you know this, you can try this one that I have made once for somebody.
I hope it helps?

Cor

\\\
Dim Scorpion As New ArrayList
For i As Integer = 0 To ds.Tables("scorpion").Rows.Count - 1
Dim row As New System.Text.StringBuilder
Scorpion.Add(row)
row.append("""")
For y As Integer = 0 To ds.Tables("scorpion").Columns.Count - 1
row.Append(ds.Tables("scorpion").Rows(i)(y).tostring)
If y <> ds.Tables("scorpion").Columns.Count - 1 Then
row.Append(""",""")
' if you want it with a tab
' row.Append("""")
' row.Append(chr(09))
' row.Append("""")
else
row.Append("""")
End If
Next
Next
Dim sw As New IO.StreamWriter("C:\test1\Scorpion.csv")
For i As Integer = 0 To Scorpion.Count - 1
sw.WriteLine(Scorpion(i).ToString)
Next
sw.Flush()
sw.Close()
///
 
my image(screen shot) was in png... So far, that's the only way i can
preview the image. How to make it into a bitmap or jpeg or other
extension.
 
Back
Top