Member Avatar

How can i convert from sql money datatype to double in c#.

  • 2 Contributors
  • forum 1 Reply
  • 109 Views
  • 7 Hours Discussion Span
  • comment Latest Post Latest Post by thines01
Member Avatar

I first cast it to a string, then to a double and it worked:

using(SqlConnection conn = new SqlConnection(CDB_SqlLister.csb.ToString()))
         {
            conn.Open();

            string strSQL = "SELECT * from E.dbo.has_money";
            using (SqlDataReader rdr = (new SqlCommand(strSQL, conn)).ExecuteReader())
            {
               while (rdr.Read())
               {
                  Console.WriteLine(double.Parse(rdr["mnyOne"].ToString()));
               }

               rdr.Close();
            }

            conn.Close();
         }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!