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

[ismailc]

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

<%@ 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.

[PRR]

Take a look at How To Use A Database In Your Program and Part 2