Dynamically create grid view on another gridview row index

Question

0.00/5 (No votes)

See more:

Hello Guys !!

Actually My Requirment 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.

What I have tried:

My Code.....

<asp:GridView ID="GridView1" runat="server" /> 
 
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...~~

Posted 15-Nov-17 22:39pm

Vivek VIshwas

Updated 17-Nov-17 13:44pm

Karthik_Mahalingam

v3

Add a Solution

Comments

Karthik_Mahalingam 16-Nov-17 7:38am

not clear, Use Improve question to add more info to the question.

Vivek VIshwas 16-Nov-17 23:38pm

I have to create a grid view dynamically from database and bind the grid view with data. In my above sql table there are multiple cID, i want to create automatically another grid view from from parent grid view row index id row id contains multiple record, means i want to create a nested grid view on generated gridview row index.

Karthik_Mahalingam 17-Nov-17 0:14am

so on click of parent gridview row you need to populate the child gridview with the related items ?

Vivek VIshwas 17-Nov-17 0:21am

of course !

Let me explain once again. I have a table, there is 5 column in that , Srno, Pid, Pname, CId, cName, cQty, and Pdetails. In my table cid is repeated more than once in Pid. I took a gridview to bind the all data from data base table. Now, gridview binding successfully, its fine. Now what i want suppose in gridview of first row id is 15 ( that is pid which is uniique in cId column ) how to generate another grid view to show data where pid=15 from table. and this will be happening again and again if any row id is repeating in Pid column . Now, tell me how to solve

Karthik_Mahalingam 17-Nov-17 1:15am

you need a separate gridview to display the child details?

Vivek VIshwas 17-Nov-17 1:16am

But how to do it?

Karthik_Mahalingam 17-Nov-17 1:34am

check the solution.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2017-11-16T19:34:00

Solution 1

refer this example

<form id="form1" runat="server">
     
        Parent Data
        <asp:GridView ID="GridView1" runat="server" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" autogenerateselectbutton="True"></asp:GridView>
        Child Data
        <asp:GridView ID="GridView2" runat="server"  ></asp:GridView>
    </form>

protected void Page_Load(object sender, EventArgs e)
       {
           if (!Page.IsPostBack) {
               DataTable dt = GetParentData();  // Get the Parent Data
               GridView1.DataSource = dt;
               GridView1.DataBind();

           }
       }



       protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
       {
           GridViewRow row = GridView1.SelectedRow;
           string pid = row.Cells[0].ToString();
           DataTable dtChild = GetChildData(pid);  // // Get the Child Data based on the Parent ID selected
           GridView2.DataSource = dtChild;
           GridView2.DataBind();

       }

Posted 16-Nov-17 19:34pm

Karthik_Mahalingam

Comments

Vivek VIshwas 17-Nov-17 1:47am

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// DataTable dt = GetParentData(); // Get the Parent Data
// GridView1.DataSource = dt;
// GridView1.DataBind();
BindGrid();
}
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
string pid = row.Cells[4].ToString();

string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand("Select * from TopBill where Pid="+pid+""))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}

//DataTable dtChild = GetChildData(pid); // // Get the Child Data based on the Parent ID selected
//GridView2.DataSource = dtChild;
//GridView2.DataBind();

}
private void BindGrid()
{
string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand("Select * from TopBill where Pid=0"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
}

Vivek VIshwas 17-Nov-17 1:48am

check this one and solve the issues

Karthik_Mahalingam 17-Nov-17 1:59am

sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}

it should be gridview2 in child section

Vivek VIshwas 17-Nov-17 2:54am

no it didn't help at all.

Karthik_Mahalingam 17-Nov-17 2:55am

show your code.

Vivek VIshwas 17-Nov-17 2:56am

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// DataTable dt = GetParentData(); // Get the Parent Data
// GridView1.DataSource = dt;
// GridView1.DataBind();
BindGrid();
}
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
string pid = GridView1.Rows[0].Cells[5].Text;

string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand("Select * from TopBill where pid="+pid+""))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}

//DataTable dtChild = GetChildData(pid); // // Get the Child Data based on the Parent ID selected
//GridView2.DataSource = dtChild;
//GridView2.DataBind();

}
private void BindGrid()
{
string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand("Select * from TopBill where Pid=0"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
}

Karthik_Mahalingam 17-Nov-17 2:58am

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
string pid = GridView1.Rows[0].Cells[5].Text;

string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand("Select * from TopBill where pid="+pid+""))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridView2.DataSource = dt;
GridView2.DataBind();
}
}
}
}

Vivek VIshwas 17-Nov-17 3:07am

Did you find my mail Sir?

Karthik_Mahalingam 17-Nov-17 3:09am

what mail?
what is the error message you are getting?

Vivek VIshwas 17-Nov-17 3:27am

string pid = GridView1.Rows[0].Cells[5].Text;

the above code describe that row one ki 5th column ki value jo hogi wo PId hoge. or ye each time ek hi hogi q ki ye to 1st row ko hi check kr rha h hme each ro ko check krna h

Vivek VIshwas 17-Nov-17 2:57am

Sir, Your this line of code gives error

GridViewRow row = GridView1.SelectedRow;
string pid = row.Cells[0].ToString();

Karthik_Mahalingam 17-Nov-17 2:59am

what is the error message, 0 is the index of the column(pid) in my case it is 0, but yours it will be different, count the column position and -1 from that.. that is the index.

Vivek VIshwas 17-Nov-17 2:57am

Can i have your email so that i could have more discussion please

Karthik_Mahalingam 17-Nov-17 2:59am

email is not encouraged for some reasons.

Vivek VIshwas 17-Nov-17 3:14am

ok, sir did you understand my question.
lets explain once again in hindi.

jaise suppose ki ek table h jiske data ko hmne grid view me bind kr diya.
Ab jaise hi grid view bind hua waise hi hme us grid view kr each row ko check krna ki kya jo row id h wo hamare table me 1 se jayda baar repeat ho rha h agr ho rha h to ek aotomatic grid view create ho or wo data is grid view me bind ho ab jaise hi ye grid view bind hua waise hi ab hme isme bhi check krna h kya is grid view ke id i mean PID ek se jayda time repeat ho rhi h table me agr haa to fir se same wahi automatic gridview create ho or usme is wali row ki id ke according data bond ho.

Karthik_Mahalingam 17-Nov-17 4:21am

am not comfortable with hindi,
basically you are trying to get the distinct of pid and ?

Vivek VIshwas 17-Nov-17 4:33am

Suppose i have a table that contains Pid , Cid, Pnamem Cname, Srno.
in my table cid is repeating multiple times in pid column.

Now , i want to show all data in grid view, its showing fine. as my grid view binding process is going on in code behind i have to find pid of reach row to check that is pid has repeating more than once. if yes, at the same time i want to automatically create a grid view to show the data according to each row of pid if pid is more than one time.

let's see.

Srno Id Pname cid Cname Cqty
11 0 15 America
12 15 America 1510 New Jursy 10
13 15 America 1511 New Jersy 5

i write a code to bind the data in to grid view

sql query is like this - select cid, cname from TopBill where Pid=0

you will get the result like -
CId Cname
15 America
Now as the above data is beinding in grid view , we have to check the grid view row and find the Cid, and if CId is in PId Column we have to create grid view to bind the data according to founded ID.

This is what i need

Karthik_Mahalingam 17-Nov-17 4:39am

can you take a screenshot and post me what is the expected result clearly.
one iam sure is, it is a very simple task, but somehow you are failing to explain it easliy.

Vivek VIshwas 18-Nov-17 1:08am

how do i attach screenshot ?

Karthik_Mahalingam 18-Nov-17 1:26am

Imgur

Vivek VIshwas 18-Nov-17 1:43am

i didnot get understand..

Vivek VIshwas 18-Nov-17 1:45am

click here to get all the files
and i have also posted an image as my desired result output

http://www.c-sharpcorner.com/forums/how-to-create-a-report-in-database-table-as-treeview-design

Karthik_Mahalingam 18-Nov-17 2:43am

ok

Vivek VIshwas 18-Nov-17 2:28am

please check and help me urgently sir...
Its going to be very difficult to resolve this issues.
My Project just stooped at this position.

Karthik_Mahalingam 18-Nov-17 8:38am

grouped gridview?

Vivek VIshwas 20-Nov-17 4:44am

i did not get your point?

Karthik_Mahalingam 20-Nov-17 7:24am

as per the screenshot in the link you provided.