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>
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>