public void ShowNewConnections() { try { objDistributor.UserId = Convert.ToInt32(Session["DistributorId"]); DataSet ds = objDistributor.GetConsumerConnectionRequests(); if (ds.Tables[0].Rows.Count > 0) { ViewState["ds"] = ds; gvConsumerRequests.DataSource = ds.Tables[0]; gvConsumerRequests.DataBind(); } else { gvConsumerRequests.EmptyDataText = "NO Requests Found"; gvConsumerRequests.DataBind(); } } catch (Exception ex) { } }