protected void Page_Load(object sender, EventArgs e) { //DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ConnectionString; SqlCommand cmd = new SqlCommand("select divhtml_content from content_managment where page_id = '3'", con); DataTable dt = new DataTable(); SqlDataAdapter ad = new SqlDataAdapter(); ad.SelectCommand = cmd; ad.Fill(dt); table1.Rows.Clear(); HtmlTableRow tr = new HtmlTableRow(); foreach (DataRow dr in dt.Rows) { HtmlTableCell tc = new HtmlTableCell(); // tc.Width = "100px"; tc.InnerHtml = dr["divhtml_content"].ToString(); tr.Cells.Add(tc); table1.Rows.Add(tr); } // do something with each row in the results... }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)