I hope this sample can help u.
Code:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">
void Page_Load( Object s, EventArgs e )
{
SqlConnection myConnection;
SqlCommand myCommand;
myConnection = new SqlConnection( "Server=Localhost;uid=sa;Database=Northwind" );
myCommand = new SqlCommand( "Select CategoryName from Categories", myConnection );
myConnection.Open();
myDataList.DataSource = myCommand.ExecuteReader();
myDataList.DataBind();
myConnection.Close();
}
</Script>
<html>
<head><title>Categories</title></head>
<body>
<form Runat="Server">
<asp:DataList id="myDataList" RepeatLayout="Flow" Runat="Server">
<ItemTemplate>
<a href=mailto:<%# DataBinder.Eval( Container.DataItem, "CategoryName" ) %>><%# DataBinder.Eval( Container.DataItem, "CategoryName" ) %></a>
</ItemTemplate>
</asp:DataList>
</form>
</body>
</html>
Always:),
Hovik Melkomian.
DataList - NOT WORKING FOR ME
