Dynamically Create Grid View on another Gridview row Index

Hello Guys !!

Actually my requirement is to creating Gridview dynamically and bind data in grid view and generating another gridview same time on the previous grid view row again and again...

Binding Gridview Dynamically from code Behind In asp.net from database table
Generating another Gridview on from above gridview row index if data find.

My Code.....

Cs..........

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString.ToString());
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GetData();
}
}
private void GetData()
{
String query = "Select * from TopBill where Pid=0";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dtMasterBill = new DataTable();
sda.Fill(dtMasterBill);
if (dtMasterBill.Rows.Count > 0)
{
GridView1.DataSource = dtMasterBill;
GridView1.DataBind();
}
else
{
// fieldReptr.Visible = false;
}
}

Table ----------

CREATE TABLE [dbo].[TopBill](
[srNo] [int] IDENTITY(1,1) NOT NULL,
[Pid] [int] NULL,
[PName] [nvarchar](max) NULL,
[PDetails] [nvarchar](max) NULL,
[cId] [int] NULL,
[Cname] [nvarchar](max) NULL,
[Cqty] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[TopBill] ON
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (1, 0, N'', N'optional', 10, N'India', N'')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (2, 10, N'India', N'optional', 1010, N'Delhi', N'1')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (4, 0, N'', N'optional', 11, N'Uk', N'')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (6, 0, N'', N'optional', 12, N'USA', N'')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (7, 0, N'', N'optional', 13, N'Canada', N'')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (8, 13, N'Canada', N'optional', 1310, N'Canada-A', N'10')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (12, 15, N'America', N'', 1510, N'New Jursy', N'10')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (15, 0, N'', N'', 16, N'bihar', N'')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (16, 1010, N'Delhi', N'optional', 101010, N'Preet Vihar', N'320')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (9, 13, N'Canada', N'optional', 1311, N'Canada-B', N'12')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (10, 0, N'', N'', 14, N'Itley', N'')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (11, 0, N'', N'', 15, N'America', N'')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (13, 15, N'America', N'', 1511, N'New Jersy', N'10')
INSERT [dbo].[TopBill] ([srNo], [Pid], [PName], [PDetails], [cId], [Cname], [Cqty]) VALUES (14, 1510, N'New Jursy', N'', 151010, N'Cat', N'12121')
SET IDENTITY_INSERT [dbo].[TopBill] OFF

Please solve this urgently...

private void CreateGridView()
{
GridView gv = new GridView();
gv.ID = "EmployeeGridView";
gv.AutoGenerateColumns = false;
gv.AllowPaging = true;
gv.EnableViewState = true;
gv.PageSize = 10; // Default page Size
//Create EventHanfler for Paging.
gv.PageIndexChanging += new GridViewPageEventHandler(this.gv_PageIndexChanging);
helper = new DataHelper();
emplist = helper.GetEmployeeData();
DataTable dt = new DataTable();
if (emplist != null)
{
if (emplist.Count > 0)
{
dt = ListToDataTable(emplist);
//We convert List view to DataTable because we use the
DataTable Column Name as a GridView Column Header.
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
BoundField boundField = new BoundField();
boundField.DataField = dt.Columns[i].ColumnName.ToString();
boundField.HeaderText = dt.Columns[i].ColumnName.ToString();
gv.Columns.Add(boundField);
}
}
}
}
}
PlaceHolder1.Controls.Add(gv);
BindGridView(gv, dt);
}
private void BindGridView(GridView gv, DataTable dt)
{
gv.DataSource = dt;
gv.DataBind();
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Gautam Parmar8y ago
1. private void CreateGridView()
2. {
3. GridView gv = new GridView();
4. gv.ID = "EmployeeGridView";
5. gv.AutoGenerateColumns = false;
6. gv.AllowPaging = true;
7. gv.EnableViewState = true;
8. gv.PageSize = 10; // Default page Size
10. //Create EventHanfler for Paging.
12. gv.PageIndexChanging += new GridViewPageEventHandler(this.gv_PageIndexChanging);
13. helper = new DataHelper();
14. emplist = helper.GetEmployeeData();
15. DataTable dt = new DataTable();
16. if (emplist != null)
17. {
18. if (emplist.Count > 0)
19. {
20. dt = ListToDataTable(emplist);
21. //We convert List view to DataTable because we use the
22. DataTable Column Name as a GridView Column Header.
23. if (dt != null)
24. {
25. if (dt.Rows.Count > 0)
26. {
27. for (int i = 0; i < dt.Columns.Count; i++)
28. {
29. BoundField boundField = new BoundField();
30. boundField.DataField = dt.Columns[i].ColumnName.ToString();
31. boundField.HeaderText = dt.Columns[i].ColumnName.ToString();
32. gv.Columns.Add(boundField);
33. }
34. }
35. }
36. }
37. }
38. PlaceHolder1.Controls.Add(gv);
39. BindGridView(gv, dt);
40. }
41. private void BindGridView(GridView gv, DataTable dt)
42. {
43. gv.DataSource = dt;
44. gv.DataBind();
45. }