Creation of Dynamic Gridview in ADO.Net

Question

I want to create a Gridview that works dynamically. How can I do the same. Thanks.

Satyapriya Nayak · Answer

Hi Stephen Try this... Untitled Page using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Sql].ConnectionString); con.Open(); SqlCommand com = new SqlCommand(GetArticles con); com.CommandType = CommandType.StoredProcedure; SqlDataAdapter ada = new SqlDataAdapter(com); DataSet ds = new DataSet(); ada.Fill(ds); for (int i = 0; i { if (ds.Tables[i].Rows.Count > 0) { GridView gvDynamicArticle = new GridView(); gvDynamicArticle.Width = Unit.Pixel(700); gvDynamicArticle.BorderWidth = Unit.Pixel(0); gvDynamicArticle.Caption =   + ds.Tables[i].Rows[0][Category].ToString() +  Articles ; gvDynamicArticle.AutoGenerateColumns = false; gvDynamicArticle.ShowFooter = true; TemplateField tf = null; tf = new TemplateField(); tf.HeaderTemplate = new DynamicGridViewTextTemplate(ArticleID DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewTextTemplate(ArticleID DataControlRowType.DataRow); tf.FooterTemplate = new DynamicGridViewTextTemplate(DataControlRowType.Footer ds.Tables[i].Rows.Count); gvDynamicArticle.Columns.Add(tf); tf = new TemplateField(); tf.HeaderTemplate = new DynamicGridViewTextTemplate(Title DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewTextTemplate(Title DataControlRowType.DataRow); gvDynamicArticle.Columns.Add(tf); tf = new TemplateField(); tf.HeaderTemplate = new DynamicGridViewTextTemplate(Description DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewTextTemplate(Description DataControlRowType.DataRow); gvDynamicArticle.Columns.Add(tf); tf = new TemplateField(); tf.HeaderTemplate = new DynamicGridViewURLTemplate(Title URL DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewURLTemplate(Title URL DataControlRowType.DataRow); gvDynamicArticle.Columns.Add(tf); tf = new TemplateField(); tf.HeaderTemplate = new DynamicGridViewTextTemplate(Author DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewTextTemplate(CreatedBy DataControlRowType.DataRow); gvDynamicArticle.Columns.Add(tf); //gvDynamicArticle.RowDataBound += new GridViewRowEventHandler(this.DynamicGrid_RowDataBound); gvDynamicArticle.DataSource = ds.Tables[i]; gvDynamicArticle.DataBind(); phDynamicGridHolder.Controls.Add(gvDynamicArticle); } } } protected void DynamicGrid_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Footer) { // } } } public class DynamicGridViewTextTemplate : ITemplate { string _ColName; DataControlRowType _rowType; int _Count; public DynamicGridViewTextTemplate(string ColName DataControlRowType RowType) { _ColName = ColName; _rowType = RowType; } public DynamicGridViewTextTemplate(DataControlRowType RowType int ArticleCount) { _rowType = RowType; _Count = ArticleCount; } public void InstantiateIn(System.Web.UI.Control container) { switch (_rowType) { case DataControlRowType.Header: Literal lc = new Literal(); lc.Text =   + _ColName +  ; container.Controls.Add(lc); break; case DataControlRowType.DataRow: Label lbl = new Label(); lbl.DataBinding += new EventHandler(this.lbl_DataBind); container.Controls.Add(lbl); break; case DataControlRowType.Footer: Literal flc = new Literal(); flc.Text =  Total No of Articles: + _Count +  ; container.Controls.Add(flc); break; default: break; } } private void lbl_DataBind(Object sender EventArgs e) { Label lbl = (Label)sender; GridViewRow row = (GridViewRow)lbl.NamingContainer; lbl.Text =DataBinder.Eval(row.DataItem _ColName).ToString(); } } public class DynamicGridViewURLTemplate : ITemplate { string _ColNameText; string _ColNameURL; DataControlRowType _rowType; public DynamicGridViewURLTemplate(string ColNameText string ColNameURL DataControlRowType RowType) { _ColNameText = ColNameText; _rowType = RowType; _ColNameURL = ColNameURL; } public void InstantiateIn(System.Web.UI.Control container) { switch (_rowType) { case DataControlRowType.Header: Literal lc = new Literal(); lc.Text =   + _ColNameURL +  ; container.Controls.Add(lc); break; case DataControlRowType.DataRow: HyperLink hpl = new HyperLink(); hpl.Target = _blank; hpl.DataBinding += new EventHandler(this.hpl_DataBind); container.Controls.Add(hpl); break; default: break; } } private void hpl_DataBind(Object sender EventArgs e) { HyperLink hpl = (HyperLink)sender; GridViewRow row = (GridViewRow)hpl.NamingContainer; hpl.NavigateUrl = DataBinder.Eval(row.DataItem _ColNameURL).ToString(); hpl.Text =   + DataBinder.Eval(row.DataItem _ColNameText).ToString() +  ; } } Thanks