PDA

View Full Version : New Problem.... email address from database


xbabigyrlx
06-29-2006, 10:12 PM
I have set up and used a stored procedure to return a list of email addresses into a gridview... how do I get these email address out of the Gridview or reference them to set my newMail.To .....

Here is the code I am using

<!-- emails populated from stored procedure -->
<asp:GridView ID="GridView3" runat="server"
DataSourceID="SqlDataSource4">
<Columns>
<asp:BoundField DataField="EmailAddress" HeaderText="Email" />
</Columns>
</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="storedProcedureEmails" SelectCommandType="StoredProcedure" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>">
<SelectParameters>
<asp:QueryStringParameter Name="Request_ID" QueryStringField="Request_ID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

xbabigyrlx
06-30-2006, 07:24 PM
Never mind... I got it figured out... I just had to use a datareader and read the values in from there....

thanks anyways... :)