C#

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

#realJSOP wrote:

set up an event handler for the form's size changed event

#realJSOP wrote:

iterate all of the controls you want to resize

Member 13325846 wrote:

textBoxes will go under Buttons (some of them will move).