Add database data to html table cell using console app c#

Question

how to Add database data to html table cell. my table consist 3 columns and nth rows(dynamically creates based on database data)

Umesh Kumar · Answer

Hi Good day Use below code for this public void Build ( DataSet ds ) { StringWriter sw = new StringWriter (); HtmlTextWriter w = new HtmlTextWriter ( sw ); foreach ( DataTable dt in ds . Tables ) { //Create a table Table tbl = new Table (); //Create column header row TableHeaderRow thr = new TableHeaderRow (); foreach ( DataColumn col in dt . Columns ) { TableHeaderCell th = new TableHeaderCell (); th . Text = col . Caption ; thr . Controls . Add ( th ); } tbl . Controls . Add ( thr ); //Create table rows foreach ( DataRow row in dt . Rows ) { TableRow tr = new TableRow (); foreach ( var value in row . ItemArray ) { TableCell td = new TableCell (); td . Text = value . ToString (); tr . Controls . Add ( td ); } tbl . Controls . Add ( tr ); } tbl . RenderControl ( w ); } Response . Write ( sw . ToString ()); }