C#

0x01AA wrote:

I think ten years ago I would also have come up with the idea to compare the results binary

double x = 0.01d;
double y = 0.01d;

x = x * 1.0d

double x = 0.01d;
double y = 0.01d;
bool equal = x == y;  // true
x = x * 1.0d;
equal= x== y;         // true again

var regex = new RegEx(@"D(?:H){0,1}[0-9]{1,2}");

var match = regex.Match(x);

if(match.Success){
   // do something 
}

using (var connection = new SqlConnection("..."))
using (var command = new SqlCommand("SELECT TOP 1 Balance FROM [Interest Posting] WHERE [Member ID] = @MemberID ORDER BY [Input Date] DESC", connection))
{
    command.Parameters.AddWithValue("@MemberID", cb_MemberID.SelectedValue);
    
    connection.Open();
    object result = command.ExecuteScalar();
    if (Convert.IsDBNull(result))
    {
        // There is no balance for the member...
    }
    else
    {
        decimal balance = Convert.ToDecimal(result);
        // Display the balance...
    }
}

cb_MemberID.selectedValue

form_load event

value not supplied

string query2 = "select * from [Member Registration]";
con.ConnectionString = global::#connectionstring;
SqlCommand com1 = new SqlCommand(query2, con);
con.Open();
SqlDataAdapter adp1 = new SqlDataAdapter(com1);
DataTable dt1 = new DataTable();
adp1.Fill(dt1);
cb_MemberID.ValueMember = "ID";
cb_MemberID.DisplayMember = "MemberName";
cb_MemberID.DataSource = dt1;
con.Close();