C#

Kevin Marois wrote:

It seems to me that the ConnectionString belongs in the Repository project.

Richard Deeming wrote:

The connection string shouldn't be hard-coded anywhere. It belongs in the configuration settings of the application - in this case, the web site.

private void FormMeasurement_Load(object sender, EventArgs e)
{
    listBoxMeasurement.Enabled = false;
    _ = LoadFormAsync();
}

private async Task LoadFormAsync()
{
    try
    {
        using (var connection = new MySqlConnection(connString))
        {
            await connection.OpenAsync();
            
            const string query = "select * from weather";
            using (var command = new MySqlCommand(query, connection))
            using (var reader = await command.ExecuteReaderAsync())
            {
                while (await reader.ReadAsync())
                {
                    listBoxMeasurement.Items.Add(string.Format("Temperature: {0}   Humidity: {1}   Date: {2}", 
                        reader.GetString("temp"), reader.GetString("hum"), reader.GetString("datecreated")));
                }
            }
        }
        
        listBoxMeasurement.Enabled = true;
    }
    catch (Exception ex)
    {
        MessageBox.Show("Database is not available for moment!\n" + ex.Message);
    }
}

int foo = 1;

int foo = new Student();

int x = 666;

string userName = " vineeth s";

<Variable Type> <Variable Name> <Optional initialization value>;

BillWoodruff wrote:

var mystudent = new Student();

Student student = new();

var students = new List<Student>
{
    new Student { ... },
    new Student { ... },
};

List<Student> students = new()
{
    new() { ... },
    new() { ... },
};