Create Temlatefield in Dynamic Gridview

Question

Dear Friends I am using dynamic grid it will displays all Datafield's correct and i have some data in database like i want to bind this in my Dynamic Grid.. In Static(Normal) grid i will display that content correctly...please tell me how can i bind that in dynamic grid in a single column(Note: I concatenate 3 columns in DB to single column). please reply me the solution

Periyannan G · Answer

Reply to Abhinav: Actually Its ASP to ASP.Net Migration in this they have already collect and save like that in Database. so they told me to use that format only. so that i ask u.... Please tell me how to place That in Dynamic Grid..

Abhimanyu K Vatsa · Answer

i think this is not a good way for advertising. why you store add image url in db. the url you are using like can't be handled like normal url even you can't bind this data in such a ways that let the to appear the add url (u example ...kmu/nath....htm) so that user can click on add and navigate to other site. i assist you not to store the target and url in db. just display the add before or after the binded data. you may use usercontrol for this. and inside usercontrol you can place any other controls with full freedom. think what will you do when needed to change the adds. because u have stored the url or target in db. that's needs to change all records to change add. hope this helps

Periyannan G · Answer

Reply to Abhinav .. In that code i have enabled one html page and picture(for Advertisment purpose). In that Dynamic grid i use 3 bounce field it will work. and i use static grid(normal grid) in that i use template field in static grid in that i use and in between i bind the data it will work fine. but i need to bind the same thing in dynamic grid. Dynamic grid Code private void BindData(DataTable arr) { for (int i = 0; i { Label lblgrid = new Label(); //Label lblemptyspace = new Label(); //lblemptyspace.Text =  ; lblgrid.ForeColor = Color.Red; lblgrid.Text = arr.Rows[i][0].ToString(); lblgrid.Font.Bold = true; lblgrid.Font.Name = Verdana; lblgrid.Font.Size = 10; Page.Controls.Add(lblgrid); System.Web.UI.WebControls.GridView dgDatas = new System.Web.UI.WebControls.GridView(); //dgDatas.ID = dgDatas + i.ToString(); //dgDatas.SkinID = Grid; dgDatas.CssClass = Grid; dgDatas.Width = 900; dgDatas.BorderColor = System.Drawing.Color.Aqua; //dgDatas.BorderColor = System.Drawing.Color.FromArgb(255 221 187); dgDatas.GridLines = GridLines.Both; //dgDatas.HeaderStyle.CssClass = GridHeader; //dgDatas.RowStyle.CssClass = GridItem; // dgDatas.RowStyle.Width = 320; dgDatas.RowStyle.HorizontalAlign = HorizontalAlign.Left; dgDatas.AutoGenerateColumns = false; BoundField b1 = new BoundField(); BoundField b2 = new BoundField(); BoundField b3 = new BoundField(); //BoundField b4 = new BoundField(); dgDatas.Columns.Add(b1); dgDatas.Columns.Add(b2); dgDatas.Columns.Add(b3); //dgDatas.Columns.Add(b4); //dgDatas.HeaderStyle.Width = 300; dgDatas.ShowHeader = true; //dgDatas.RowStyle.Width = 300; dgDatas.RowStyle.Font.Size = 8; dgDatas.RowStyle.Font.Name = Verdana; b1.DataField = Name; b2.DataField = Address; b3.DataField = Info; //b4.DataField = addv; b1.HeaderText = Name; b2.HeaderText = Address; b3.HeaderText = Info.; //b4.HeaderText = Photo; b1.HeaderStyle.ForeColor = System.Drawing.Color.FromArgb(0 102 0); b2.HeaderStyle.ForeColor = System.Drawing.Color.FromArgb(128 0 0); b3.HeaderStyle.ForeColor = System.Drawing.Color.FromArgb(255 165 0); b1.HeaderStyle.Font.Size = 8; b2.HeaderStyle.Font.Size = 8; b3.HeaderStyle.Font.Size = 8; //b4.HeaderStyle.Font.Size = 8; b1.ItemStyle.Width = 150; b2.ItemStyle.Width = 300; b3.ItemStyle.Width = 100; //b4.ItemStyle.Width = 100; dgDatas.RowStyle.BorderWidth = 1; dgDatas.RowStyle.BorderColor = System.Drawing.Color.Aqua; //dgDatas.RowStyle.BorderColor = System.Drawing.Color.FromArgb(255 221 187); b1.HeaderStyle.Width = 150; b2.HeaderStyle.Width = 300; b3.HeaderStyle.Width = 100; //b4.HeaderStyle.Width = 100; b1.HeaderStyle.BorderColor = System.Drawing.Color.Aqua; b2.HeaderStyle.BorderColor = System.Drawing.Color.Aqua; b3.HeaderStyle.BorderColor = System.Drawing.Color.Aqua; //b4.HeaderStyle.BorderColor = System.Drawing.Color.Aqua; b1.ItemStyle.BorderWidth = 1; b2.ItemStyle.BorderWidth = 1; b3.ItemStyle.BorderWidth = 1; //b4.ItemStyle.BorderWidth = 1; b1.ItemStyle.BorderColor = System.Drawing.Color.Aqua; b2.ItemStyle.BorderColor = System.Drawing.Color.Aqua; b3.ItemStyle.BorderColor = System.Drawing.Color.Aqua; //b4.ItemStyle.BorderColor = System.Drawing.Color.Aqua; b1.HeaderStyle.Font.Name = Verdana; b2.HeaderStyle.Font.Name = Verdana; b3.HeaderStyle.Font.Name = Verdana; //b4.HeaderStyle.Font.Name = Verdana; SqlCommand cmd = new SqlCommand(sp_business conection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(@t_busstype SqlDbType.VarChar).Value = arr.Rows[i][0].ToString(); conection.Open(); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (conection.State == ConnectionState.Open) conection.Close(); dgDatas.DataSource = dt; dgDatas.DataBind(); plGridview.Controls.Add(lblgrid); plGridview.Controls.Add(dgDatas); //plGridview.Controls.Add(lblemptyspace); }

Abhimanyu K Vatsa · Answer

U have stored [[ ]] in database but why? Will you please show us the code?