MoW's blog: "working with csv files part one" works with RC2?

Copied the helper functions exactly as is:
http://mow001.blogspot.com/2006/03/w...-part-one.html

I get an error seemingly from "fill" below:

PS C:\> gc mow-getdata.ps1
function get-DataTable {
Param ($name )
$cmd = new-object System.Data.OleDb.OleDbCommand("Select * from
[$name]",$Conn)
$da = new-object System.Data.OleDb.OleDbDataAdapter($cmd)
$dt = new-object System.Data.dataTable
[void]$da.fill($dt)
$dt.TableName = $name.split("#")[0]
return $dt
}

PS C:\> connect-csv c:\

TABLE_NAME
----------
test#csv

PS C:\> get-datatable test#csv
Exception calling "Fill" with "1" argument(s): "Fill:
SelectCommand.Connection property has not been initialized."
At C:\mow-getdata.ps1:6 char:17
+ [void]$da.fill( <<<< $dt)

> Copied the helper functions exactly as is:
> http://mow001.blogspot.com/2006/03/w...-part-one.html
>
> I get an error seemingly from "fill" below:

I did something wrong, likely when loading the scripts/functions. I'm still
having problems though. get-datatable doesn't retrun any human readable
information at all:

PS C:\> . get-datatable test#csv

ÿ_n NoName
--- ------








PS C:\> gc test.csv
name,logon
marco,111
shaw,222
PS C:\> import-csv test.csv

name logon
---- -----
marco 111
shaw 222

> PS C:\> . get-datatable test#csv
>
> ÿ_n NoName
> --- ------

I probably need to take more care how I write my .csv files. I think I've
gotten a small test working OK now.

Marco

Glad you got it going, (I think you mixed unicode / ascii )

I also have some issues with RC2 and returning a DataSet or DataTable,
it gets converted to an Array of objects when returned from a function in RC2

it was not like this before, workaround :
change :

return $dt

to:

return ,$dt

(Note the comma that wraps it in another array ($null,$dt) ,
that second array gets "stripped off" and the dataset will remain.

for the rest I think all works.
if you got more problem please let me know

Greetings /\/\o\/\/
www.ThePowerShellGuy.com


"Marco Shaw" wrote:

>
> > PS C:\> . get-datatable test#csv
> >
> > ÿ_n NoName
> > --- ------
>
> I probably need to take more care how I write my .csv files. I think I've
> gotten a small test working OK now.
>
> Marco
>
>
>