i have a sql server DB that uses the type "smallmoney"
how can i convert this to a c# type, i have tried
SqlMoney balanceDue = (SqlMoney)accountSet1.Tables["Account"].Rows[0]["Balance_Due"];
and
double balanceDue = (double)accountSet1.Tables["Account"].Rows[0]["Balance_Due"];
but both of these give me invalid cast type errors, anyone know whats going on?
how can i convert this to a c# type, i have tried
SqlMoney balanceDue = (SqlMoney)accountSet1.Tables["Account"].Rows[0]["Balance_Due"];
and
double balanceDue = (double)accountSet1.Tables["Account"].Rows[0]["Balance_Due"];
but both of these give me invalid cast type errors, anyone know whats going on?