The following code would fail, with the error:
"The '' string cannot be converted to the double type."
when trainTable contains rows with DBNull in some of the columns.
How can I pass NULL to MSAS?
using (AdomdCommand comm = connAS.CreateCommand())
{
comm.CommandText = "INSERT INTO MINING MODEL [MyModel]
([statbbrev],[lpop],[ldem],[lemp]) @TrainTable";
comm.Parameters.Add("TrainTable", trainTable);
comm.ExecuteNonQuery();
}
Cor Ligthert[MVP] - 28 Feb 2008 04:39 GMT
One time is enough, this is really no second reply service.
Cor
Nestor - 28 Feb 2008 14:59 GMT
Sorry, it was a mistake.
> One time is enough, this is really no second reply service.
>
> Cor