Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!this.IsPostBack)
- {
- //Populating a DataTable from database.
- DataTable dt = this.GetData();
- //Building an HTML string.
- StringBuilder html = new StringBuilder();
- //Table start.
- html.Append("<table border = '1'>");
- //Building the Header row.
- html.Append("<tr>");
- foreach (DataColumn column in dt.Columns)
- {
- html.Append("<th>");
- html.Append(column.ColumnName);
- html.Append("</th>");
- }
- html.Append("</tr>");
- //Building the Data rows.
- foreach (DataRow row in dt.Rows)
- {
- html.Append("<tr>");
- foreach (DataColumn column in dt.Columns)
- {
- html.Append("<td>");
- html.Append(row[column.ColumnName]);
- html.Append("</td>");
- }
- html.Append("</tr>");
- }
- //Table end.
- html.Append("</table>");
- //Append the HTML string to Placeholder.
- PlaceHolder1.Controls.Add(new Literal { Text = html.ToString() });
- }
- }
- private DataTable GetData()
- {
- string webAppConnString = ConfigurationManager.ConnectionStrings["webAppConnString"].ConnectionString;
- using (SqlConnection con = new SqlConnection(webAppConnString))
- {
- con.Open();
- using (SqlCommand cmd = new SqlCommand("SELECT project_ID, user, date_time, projectAction, Comments FROM history;"))
- {
- using (SqlDataAdapter sda = new SqlDataAdapter())
- {
- cmd.Connection = con;
- sda.SelectCommand = cmd;
- using (DataTable dt = new DataTable())
- {
- sda.Fill(dt);
- return dt;
- }
- }
- }
- }
- }
Add Comment
Please, Sign In to add comment