Connect & retrieve from SQL DB in aspx page.

Good day,

Need to connect & retrieve from SQL DB in aspx page.

I don't know aspx & only want to edit the page to sow additional information.

Can you please help by providing some code?

I have an aspx page which I want to edit by adding information from a SQL database & display results on and in the html page (code below).

I need to show information on this page which lies on the SQL db.

Any code would be great that works in the aspx page where i can just insert the DB connection details & sql statement & display the result on page.


aspx page code

Code:

---

<%@ Control Language="c#" AutoEventWireup="True" Codebehind="Header.ascx.cs" Inherits="FlowCentric.Net.Navigator.Header" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>
<table>
<tr> <td><asp:Label id="lblLogin" runat="server">Welc</asp:Label></td></tr>
</table>

---

Please Assist!