I want my c # program to take the data from the mysql database and save that data to a variable type double. I was trying but I still can't do it.
`
MySqlDataReader read = null;
string selectCmd = "SELECT Saldo from cuentas where NoCuenta=" + cuenta + ";";
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
MySqlCommand MyCommand2 = new MySqlCommand(selectCmd, MyConn2);
MyConn2.Open();
read = MyCommand2.ExecuteReader();
MessageBox.Show("read: " +read);
bool saldoI = read.Read();
double saldo = Convert.ToDouble(saldoI);
MessageBox.Show("Aqui se muestra el saldo inicial " + read);
double saldoFinal = saldo - monto;
`
I know that as I am transforming it from a bool type variable it returns a 1, but I require that it return the data type double. Example: 300.2
Why not:
if (read.Read())
double saldo = Convert.ToDouble(reader[0]);
The read.Read() return value, returns true if there is indeed a returned row from your query and false if there isn't or you read them all.
To actually get the data you need to access the current row's column in the data reader.
Example in the link above:
private static void CreateCommand(string queryString,
string connectionString)
{
using (SqlConnection connection = new SqlConnection(
connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(String.Format("{0}", reader[0]));
}
}
}
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다