SqlConnection connection = new SqlConnection("Data Source=redacted.database.windows.net,1433;Initial Catalog=hmsproject;User ID=xxxx;Password=xxxx");

SqlDataAdapter sqladp = new SqlDataAdapter();

string query = "INSERT INTO reservations(username,mobile) VALUES('" + TextBox1.Text+"','"+TextBox2.Text+"')";

try
{
    connection.Open();

    SqlCommand command = new SqlCommand(query, connection);
    sqladp.SelectCommand = command;
}
catch (Exception ex)
{
}

Dim conn As New Data.SqlClient.SqlConnection("Data Source=redacted.database.windows.net,1433;Network Library=DBMSSOCN;Initial Catalog=hmsproject;User ID=xxxx;Password=xxxx")

Dim SDA As New SqlDataAdapter

Try
    conn.Open()
    Dim Query As String
    Query = "INSERT INTO reservations (username, number) values ('" & TextBox1.Text & "','" & TextBox2.Text & "')"
    Command = New SqlCommand(Query, conn)
    SDA.SelectCommand = Command

    Label2.Text = "Awdawd"
    conn.Close()
Catch ex As SqlException
    MsgBox(ex.Message)
Finally
    conn.Dispose()
    End Try
End Sub