Dear All:

I wanted to get some help about DBNULL issue, and I got some code from RayV, he

showed me his code:

open System

open System.Data

open System.Data.SqlClient

let cstr = "server=(local);Integrated

Security=True;Database=AdventureWorks"

let conn = new SqlConnection(cstr)

let read cmdText =

use cmd = new

SqlCommand(cmdText, conn)

conn.Open()

let reader =

cmd.ExecuteReader()

seq { while reader.Read()

do

yield

reader.GetSqlValue(0)

reader.Close()

conn.Close() }

read "SELECT TOP 10 * FROM Production.Product"

|> Seq.iter (printfn "%A")

Now, I want to know how I can save the results in an array,

so I can use it later on.

I want to use something like:

Read “SELETCT TOP 10 * FROM Production.Product”
|> let arrRecords = Array.zeroCreate Seq.length
for j = 0 to arrRecords.Length - 1 do
arrRecords.[j] <- Seq.iter (fun (x) -> x)

But I got compiler error:

Unexpected keyword 'for' in expression. Expected 'in' or

other token.

Please let me know how I can do it?

Thanks and Happy New Year to all!