Dear All:
I want to write some code to change a data row collection into a string array.
Here is the data table design:
CREATE TABLE [dbo].[Table1](
[Data] [nvarchar](1) NOT NULL
) ON [PRIMARY]

I also insert 3 values into the data table:
INSERT INTO Table1 VALUES('A')
INSERT INTO Table1 VALUES('B')
INSERT INTO Table1 VALUES('C')
GO

My code to get the data and trying to convert into string array:
#light
open System
open System.Data
open System.Data.SqlClient
open System.IO

let sql_ConnDB = "server=(local); Integrated Security=True; Database=LocalDB"
let connDB = new SqlConnection(sql_ConnDB)

let da = new SqlDataAdapter("SELECT Data FROM Table1", connDB)
let ds = new DataSet()
da.Fill(ds) |> ignore
let strArray = ds.Tables.Item(0).Rows :?> string array

I got the compiler error:
The type 'DataRowCollection' does not have any proper subtypes and cannot be used as the source of a type test or runtime coercion.

The issue now is how I can convert DataRowCollection into a string array.
Any idea is welcome!
Please show me your code.
Thanks,