type conversion

-1

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

Contributors

Views

5 Years

Discussion Span

5 Years Ago

Last Post by thines01

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();
         }

Are you able to help answer this sponsored question?

Questions asked by members who have earned a lot of community kudos are featured in order to give back and encourage quality replies.

This topic has been dead for over six months. Start a new discussion instead.

Hello! I am developing a POS System. I have need to print Sales receipt. I have no physical printer to test my printing but i have print on xps document. ...

Hi All,

i need to convert this Python code to C# .Tried Some online converters nothing Worked out so far.Please Help.

import openpyxl
from PIL import Image, ImageTk
import Tkinter ...

I used npm node-persist but I wish to use it in two modules as well, 'set()' and 'get()'

var     storage=require('node-persist'),
            set=require('./set.js'),
            get=require('./get.js');

storage.initSync();

passing as; set(foo, bar, storage);

my problem ...