How to populate a GridView in a pop-up that is inside an UpdatePanel after a button click inside an UpdatePanel

Question

I have a GridView which has an ImageButton. When clicked it runs a query and populate a GridView from the result (or it should:

Object and FK are from the original query which populates the above GridView.

Code behind:

protected void yourTasksGV_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "TaskDepend")
    {
        string[] id = e.CommandArgument.ToString().Split(',');
        connString = @"";
        string objectid = id[0];
        string fkobjectid = id[1];
        string queryStringParent =
                           string.Format(@"SELECT
                                 CT.OBJECTID 'Object ID'
                                 ,LTRIM(RTRIM(CT.ATTR2739)) 'Task Name'
                                 ,UA.USERNAME 'Manager'
                                 ,CT.ATTR2941 'Task Start Date'
                                 ,LTRIM(RTRIM(CT.ATTR2812)) 'Status'
                                 ,CT.ATTR2752 'Due Date'
                                 ,CT.ATTR2757 'Completed Date'
                                 ,CT.ATTR2849 'Checked Date'
                                 ,LTRIM(RTRIM(CT.ATTR2847)) 'Checked Status'
                                 ,LTRIM(RTRIM(CT.ATTR2848)) 'Checked User'
                                 ,CT.FK2744 'Dependent Task'
                   FROM HSI.RMOBJECTINSTANCE1224 CT
                                 LEFT JOIN HSI.RMOBJECTINSTANCE1232 S ON S.OBJECTID = CT.FK2940
                                 LEFT JOIN HSI.USERACCOUNT UA ON UA.USERNUM = (S.FK2852 * -1)
                   WHERE CT.ACTIVESTATUS = 0 AND CT.OBJECTID = '{0}'", fkobjectid);
        string queryStringChildren =
           string.Format(@"SELECT
                                 CT.OBJECTID 'Object ID'
                                 ,LTRIM(RTRIM(CT.ATTR2739)) 'Task Name'
                                 ,UA.USERNAME 'Manager'
                                 ,CT.ATTR2941 'Task Start Date'
                                 ,LTRIM(RTRIM(CT.ATTR2812)) 'Status'
                                 ,CT.ATTR2752 'Due Date'
                                 ,CT.ATTR2757 'Completed Date'
                                 ,CT.ATTR2849 'Checked Date'
                                 ,LTRIM(RTRIM(CT.ATTR2847)) 'Checked Status'
                                 ,LTRIM(RTRIM(CT.ATTR2848)) 'Checked User'
                                 ,CT.FK2744 'Dependent Task'
                   FROM HSI.RMOBJECTINSTANCE1224 CT
                                 LEFT JOIN HSI.RMOBJECTINSTANCE1232 S ON S.OBJECTID = CT.FK2940
                                 LEFT JOIN HSI.USERACCOUNT UA ON UA.USERNUM = (S.FK2852 * -1)
                   WHERE CT.ACTIVESTATUS = 0 AND CT.FK2744 = '{0}'", objectid);

        using (SqlConnection connection = new SqlConnection(connString))
        {
            //Get Parent Task
            SqlCommand command = new SqlCommand(queryStringParent, connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();
            gvParentTasks.DataSource = reader; //not working
            gvParentTasks.DataBind(); //not working
            upParentTasks.Update(); //not working
            if (!string.IsNullOrEmpty(fkobjectid) && fkobjectid != " ")
            {
                // Call Read before accessing data. 
                while (reader.Read())
                {
                    //ddlCli.Items.Add(new System.Web.UI.WebControls.ListItem(reader[0].ToString().TrimEnd(), reader[0].ToString().TrimEnd()));

                }
            }
            // Call Close when done reading.
            reader.Close();

            //Get Child Tasks
            command = new SqlCommand(queryStringChildren, connection);

            reader = command.ExecuteReader();

            // Call Read before accessing data. 
            while (reader.Read())
            {
                //ddlCli.Items.Add(new System.Web.UI.WebControls.ListItem(reader[0].ToString().TrimEnd(), reader[0].ToString().TrimEnd()));

            }

            // Call Close when done reading.
            reader.Close();
        }
    }
}

I have a popup which has a GridView:


    x
    Parent Dependencies
    
        
            
                
                    
                        
                        
                        
                        
                    
                
            
        
    
    Children Dependencies

JQuery which displays the pop-up:

$(document).ready(function () {
    $("#btnShowDepend").click(function (e) {
        e.preventDefault();
        centerPopupDep();
        loadPopupDep();
    });
});

When I click on btnShowDepend image, the pop-up is displayed but nothing is displayed in the GridView. Also, because I am using an ID, if there are multiple rows only the first button triggers the pop-up.

How can I modify the code so that the pop-up is displayed with the GridView populated and for each button that represents individual row handles its own click?

PieterSchool · Accepted Answer

Use a class for the binding in sted of an id

ASP:

jquery:

$(document).ready(function () {
    $(".btnShowDepend").click(function (e) {
        e.preventDefault();
        centerPopupDep();
        loadPopupDep();
    });
});

Added the class btnShowDepend to the button, this enables the binding to Jquery. If you want to transfer an id you can add it as alt an get it by getting the .attr('alt')

How to populate a GridView in a pop-up that is inside an UpdatePanel after a button click inside an UpdatePanel

Answers (1)

Related Questions