Dynamically Create Grid View on another Gridview row Index

Question

Hello Guys !! Actually, My Requirement is to create a Gridview dynamically and bind data in grid view and generating another gridview same time on the previous grid view row again and again... 1.Binding Gridview Dynamically from code Behind In asp.net from database table 2.Generating another Gridview on from above gridview row index if data find. My Code

vikas_jk · Accepted Answer

You can do something like this for

1.Binding Gridview Dynamically from code Behind In asp.net from database table

-> Use the code below it will work(tested)

Default.aspx code

Code behind code (.cs)

 protected void Page_Load(object sender, EventArgs e)         {             if (!IsPostBack)             {                 BindGridviewData();             }         }   private void BindGridviewData()         {                         //Create a datatable             DataTable dt = new DataTable();            //Add columns to it which you want here i have added only one             dt.Columns.Add("BlogName", typeof(string));           //create a row class to add rows dynamically             DataRow dtrow = dt.NewRow();            //create database connection             using (var connection = new SqlConnection("Your Connection String"))             {                 using (var command = connection.CreateCommand())                 {                    //query to select rows from database table Name Blogs                     command.CommandText = "Select * from Blogs";                     connection.Open();                     using (var reader = command.ExecuteReader())                     {                         var indexOfColumn1 = reader.GetOrdinal("Name");                                               //loop through each rows from datatabe and it in DataTable                         while (reader.Read())                         {                             dtrow = dt.NewRow();                             dtrow["BlogName"] = reader.GetValue(indexOfColumn1); ;               //Bind Data to Columns                                                        dt.Rows.Add(dtrow);                                                                                 }                     }                     connection.Close();                 }             }                //bind your data to GridView             GridView1.DataSource = dt;             GridView1.DataBind();                    }

I have tried the above code and it works.

2. For "Generating another Gridview on from above gridview row index if data find."

-> Repeat above process by taking row id and fetch grid view data again as described(You may have to change query, GridView id, etc, which you need to bind )

Hope this helps

Dynamically Create Grid View on another Gridview row Index

Related Articles

Subscribe Now

Related Questions