help with mySQL please... updated

[aridoasis]

how can i set a hyperlink to auto-email text inputted in a text box (for example, a comment) to an email/s stored in my database? i'm using visual web developer 2005... please help...

[gezeala]

dude i-post imong script. you don't want us to write the whole script for you dba..?

[aridoasis]

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CommentID"
DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True" Width="558px">
<Columns>
<asp:BoundField DataField="DateSubmitted" HeaderText="DateSubmitted" SortExpression="DateSubmitted" />
<asp:BoundField DataField="Comment" HeaderText="Comment" SortExpression="Comment" />
<asp:BoundField DataField="SubmittedBy" HeaderText="SubmittedBy" SortExpression="SubmittedBy" />
<asp:BoundField DataField="CommentStatus" HeaderText="CommentStatus" SortExpression="CommentStatus" />


<asp:HyperLinkField DataNavigateUrlFields="CommentID" DataNavigateUrlFormatString="ReplyComment.aspx?Com mentID={0}"
Text="Reply" />
** here unta na hyperlink... how to i code it na it will also send the content of the "Comment" datafield to an email address stored in my database (sql)?

<asp:HyperLinkField DataNavigateUrlFields="CommentID" DataNavigateUrlFormatString="ViewHistory.aspx?Comm entID={0}"
Text="View History" />
</Columns>
</asp:GridView>

[aridoasis]

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CommentID"
DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True" Width="558px">
<Columns>
<asp:BoundField DataField="DateSubmitted" HeaderText="DateSubmitted" SortExpression="DateSubmitted" />
<asp:BoundField DataField="Comment" HeaderText="Comment" SortExpression="Comment" />
<asp:BoundField DataField="SubmittedBy" HeaderText="SubmittedBy" SortExpression="SubmittedBy" />
<asp:BoundField DataField="CommentStatus" HeaderText="CommentStatus" SortExpression="CommentStatus" />


<asp:HyperLinkField DataNavigateUrlFields="CommentID" DataNavigateUrlFormatString="ReplyComment.aspx?Com mentID={0}"
Text="Reply" />
** here unta na hyperlink... how do i code it na it will also send the content of the "Comment" datafield to an email address stored in my database (sql)?

<asp:HyperLinkField DataNavigateUrlFields="CommentID" DataNavigateUrlFormatString="ViewHistory.aspx?Comm entID={0}"
Text="View History" />
</Columns>
</asp:GridView>