I have a small method that pulls the largest number out of a Column that is in a table. It then displays it in a couple of text boxes.
The code works good, but in testing I want a decimal number (xx.x) but only getting an integer right now.
Here is the complete Method:
using (MySqlCommand cmd = new MySqlCommand("SELECT MAX(TDNumber) FROM bbb.traveldocuments", con1))
object result = cmd.ExecuteScalar();
result = (result == DBNull.Value) ? null : result;
decimal blah = Convert.ToDecimal(result);
MessageBox.Show(blah.ToString()); // something to show me what the value of blah is at this point
txtBox_TD_MAX_NUMBER.Text = blah.ToString();
decimal newtd = blah + 1;
txtBox_TD_nextTDNumber.Text = newtd.ToString();
It's a little complex since my original code was crashing if the value was null (empty database). Now I get a zero, which isn't bad, just wondering if it's because my Database is empty and the 0 is actually a null?
The format of the Column is 10.1 decimal unsigned.