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 GPosted May 23, 2011, 4:03 AM
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
Abhimanyu K VatsaPosted May 20, 2011, 4:43 AM
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 GPosted May 20, 2011, 3:36 AM
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
Dynamic grid Code
private void BindData(DataTable arr)
{
for (int i = 0; i < arr.Rows.Count; 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 VatsaPosted May 18, 2011, 8:49 AM
[[
in database, but why?
Will you please show us the code?