Sending Emails With System.Net.Mail To Addresses From A SQL Query

I have the following code on a form:

<asp:SqlDataSource ID="building_a" runat="server" ConnectionString="<%$ ConnectionStrings:vol1ConnectionString4 %>"

SelectCommand="SELECT [E_MAIL] FROM [Sheet4$] WHERE ([BUILDING] LIKE '%' + @BUILDING+ '%')" OnSelecting="building_a_Selecting">

  <SelectParameters>

    <asp:Parameter DefaultValue="a" Name="BUILDING" Type="String" />

  </SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="building_b" runat="server" ConnectionString="<%$ ConnectionStrings:vol1ConnectionString4 %>"

SelectCommand="SELECT [E_MAIL] FROM [Sheet4$] WHERE ([BUILDING] LIKE '%' + @BUILDING+ '%')" OnSelecting="building_b_Selecting">

  <SelectParameters>

    <asp:Parameter DefaultValue="b" Name="BUILDING" Type="String" />

  </SelectParameters></asp:SqlDataSource>

<asp:TextBox ID="subj" runat="server" Width="500px">Subject</asp:TextBox><br /><br />

<asp:TextBox ID="messg" runat="server" Rows="20" TextMode="MultiLine" Width="500px">Message</asp:TextBox><br /><br />

<asp:Button ID="bldga" runat="server" Text="Building A" OnClick="Button1_Click" /><br /><br /><asp:Button ID="bldgb" runat="server" Text="Building B" OnClick="Button2_Click" /><br /><br />

<asp:Label ID="resultLabel1" runat="server" ForeColor="red"></asp:Label>

 And I have the following code behind:protected void Button1_Click(object sender, EventArgs e)

{SmtpClient smtpClient = new SmtpClient();

MailMessage message = new MailMessage();

try

{MailAddress fromAddress = new MailAddress("me@mydomain.com", "My Name");MailAddress toAddress = new MailAddress("them@theirdomain.com");

message.From = fromAddress;

message.To.Add(toAddress);

message.Subject = subj.Text;message.IsBodyHtml = false;

message.Body = messg.Text;smtpClient.Host = "myhost";

smtpClient.Send(message);resultLabel1.Text = "Email sent!";

}catch

{resultLabel1.Text = "Send failure";

}

}

The queries get e-mail addresses from a SQL database for all people who work in a particular building.

The buttons will send an email if I give a To address.

How do I write the code so that clicking on the "Building A" button will send the e-mail to the addresses from the query results individually?

Any ideas?