Post
Ask Question

Bind Data from DataBase to HTML Table in ASP.NET

ShowRecordsUsingHtmlTable.aspx

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ShowRecordsUsingHtmlTable.aspx.cs" Inherits="JtableExample.ShowRecordsUsingHtmlTable" %>  
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  3. <html  
  4.     xmlns="http://www.w3.org/1999/xhtml">  
  5.     <head runat="server">  
  6.         <title></title>  
  7.     </head>  
  8.     <body>  
  9.         <form id="form1" runat="server">  
  10.             <div>  
  11.                 <table id="studentTable" width="100%" align="center" cellpadding="2" cellspacing="2" border="0" bgcolor="#EAEAEA" >  
  12.                     <tr align="left" style="background-color:#004080;color:White;" >  
  13.                         <td>StudentId</td>  
  14.                         <td>Name </td>  
  15.                         <td>EmailAddress</td>  
  16.                         <td>Gender</td>  
  17.                     </tr><%=getStudentData()%>  
  18.                 </table>  
  19.             </div>  
  20.         </form>  
  21.     </body>  
  22. </html> 
ShowRecordsUsingHtmlTable.aspx.cs
  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Linq;  
  4. using System.Web;  
  5. using System.Web.UI;  
  6. using System.Web.UI.WebControls;  
  7. using System.Configuration;  
  8. using System.Data.SqlClient;  
  9. using System.Data;  
  10. namespace JtableExample  
  11. {  
  12.     public partial class ShowRecordsUsingHtmlTable: System.Web.UI.Page {  
  13.         string connectionString = ConfigurationManager.ConnectionStrings["Scon"].ConnectionString;  
  14.         protected void Page_Load(object sender, EventArgs e)  
  15.         {   }  
  16.         public string getStudentData()  
  17.         {  
  18.             string data = "";  
  19.             using(SqlConnection conn = new SqlConnection(connectionString))   
  20.             {  
  21.                 using(SqlCommand cmd = new SqlCommand())  
  22.                 {  
  23.                     cmd.Connection = conn;  
  24.                     cmd.CommandType = CommandType.StoredProcedure;  
  25.                     cmd.CommandText = "UspGetStudents";  
  26.                     cmd.Connection.Open();  
  27.                     using(SqlDataReader sqlRdr = cmd.ExecuteReader())   
  28.                     {  
  29.                         // table = new DataTable();  
  30.                         // table.Load(reader);  
  31.                         if (sqlRdr.HasRows)   
  32.                         {  
  33.                             while (sqlRdr.Read())   
  34.                             {  
  35.                                 int studentId = sqlRdr.GetInt32(0);  
  36.                                 string Name = sqlRdr.GetString(1);  
  37.                                 string EmailAddress = sqlRdr.GetString(2);  
  38.                                 string Gender = sqlRdr.GetString(3);  
  39.                                 data += "<tr><td>" + studentId + "</td><td>" + Name + "</td><td>" + EmailAddress + "</td><td>" + Gender + "</td></tr>";  
  40.                             }  
  41.                         }  
  42.                     }  
  43.                 }  
  44.                 return data;  
  45.             }  
  46.         }  
  47.     }  
  48. }  
Web.config
  1. <configuration>  
  2.     <connectionStrings>  
  3.         <add name="Scon" connectionString="Data Source=machineName; Initial Catalog=databaseName;Integrated Security=SSPI"/>  
  4.     </connectionStrings>  
  5.     <system.web>  
  6.         <compilation debug="true" targetFramework="4.0" />  
  7.     </system.web>  
  8. </configuration>