Hi All,
I'm getting following error while executing insert query using
SqlCommand object with parameters
Insert Failed :Disallowed implicit conversion from data type
nvarchar to data type money
I'm adding Parameters using following syntax
SqlCommand cmd= new SqlCommand();
---
---
string myValue = "20"
cmd.Parameters.Add(new SqlParameter("@MyMoneyColName",myValue))
-----
cmd.ExecuteNonQry();
there is a Constructor of SqlParameter available
which takes SqlDbType as parameter, but the problem is that i don't
have parameter info, coz i'm writing these qry at run time.
Can some one please help me on this
Thanks
SunilT