protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { Banner oBanner = new Banner(); DataSet dsBanner = oBanner.getAllBanners(); StringBuilder strBuild = new StringBuilder(); strBuild.Append("<table widtd='100%' border='0' cellpadding='5' cellspacing='3' id='data_sortable'>"); strBuild.Append("<tr><td>Banner Image</td><td>Ad Name</td><td>Category</td><td>Active</td><td>Weightage</td><td>Click Count</td><td colspan='2' ></td></tr>"); if (dsBanner.Tables.Count > 0 && dsBanner.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsBanner.Tables[0].Rows) { strBuild.Append("<tr>"); int adId = Convert.ToInt32(dr["adId"].ToString()); string imageName = dr["imageName"].ToString(); string imgPath = "/admin/banners/" + imageName; imgPath = "<img src='" + imgPath + "' border='0' widtd='45' height='45'>"; strBuild.Append("<td>"+imgPath+"</td>"); strBuild.Append("<td>"+dr["advName"].ToString()+"</td>"); strBuild.Append("<td>"+dr["category"].ToString()+" </td>"); strBuild.Append("<td>" + dr["Active"].ToString()+ "</td>"); strBuild.Append("<td>" + dr["Weightage"]+ "</td>"); strBuild.Append("<td>" + dr["hitCount"] + "</td>"); strBuild.Append("<td><a href=ManageBanners.aspx?type=update&adid=" + adId+ ">Edit</a></td>"); strBuild.Append("<td><a href=javascript:fnDelBannerAd(" + adId + ",'"+imageName+"')>Delete</a></td></tr>"); } strBuild.Append("</table>"); divBanners.InnerHtml = strBuild.ToString(); } } } catch (Exception ex) { throw ex; } }