<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <div id='content'> <% cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True;"); da = new SqlDataAdapter("SELECT * FROM realLyrics",cn); ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; foreach(DataRow dr in dt.Rows) { Response.Write("<div class='newProject'>"); Response.Write("<h1>"+dr["songName"]+"</h1>"); Response.Write("<h2>" + dr["songName"] + "</h2>"); Response.Write("<div class='projectContent'>"); Response.Write(dr["lyrics"]); Response.Write("</div>"); Response.Write("</div>"); } %>