how to group columns under one column and merge rows ? after writing this code my gridview is not showing properly, please help me

Question

1.00/5 (1 vote)

See more:

here my source code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="WaterDSview_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" media="screen" href="css/style.css">
<link rel="stylesheet" type="text/css" media="screen" href="css/menu/simple_menu.css">
<link href='http://fonts.googleapis.com/css?family=Open+Sans+Condensed:300|Playfair+Display:400italic' rel='stylesheet' type='text/css' />
<link rel="stylesheet" href="css/nivo-slider.css" type="text/css" media="screen">
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.eislideshow.js"></script>
<script type="text/javascript" src="js/custom.js"></script>
<script type="text/javascript">
jQuery.noConflict()(function ($) {
$('#ei-slider').eislideshow({
animation: 'center',
autoplay: true,
slideshow_interval: 3000,
titlesFactor: 0
});
});
</script>
<script type="text/javascript" src="js/slides/slides.min.jquery.js"></script>
<script type="text/javascript" src="js/cycle-slider/cycle.js"></script>
<script type="text/javascript" src="js/nivo-slider/jquery.nivo.slider.js"></script>
<script type="text/javascript" src="js/tabify/jquery.tabify.js"></script>
<script type="text/javascript" src="js/prettyPhoto/jquery.prettyPhoto.js"></script>
<script type="text/javascript" src="js/twitter/jquery.tweet.js"></script>
<script type="text/javascript" src="js/scrolltop/scrolltopcontrol.js"></script>
<script type="text/javascript" src="js/portfolio/filterable.js"></script>
<script type="text/javascript" src="js/modernizr/modernizr-2.0.3.js"></script>
<script type="text/javascript" src="js/easing/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="js/kwicks/jquery.kwicks-1.5.1.pack.js"></script>
<script type="text/javascript" src="js/swfobject/swfobject.js"></script>

<link rel="stylesheet" type="text/css" itemprop="javascript" href="js/fancybox/jquery.fancybox.css" media="all">
<script type="text/javascript" src="js/fancybox/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="js/fancybox/jquery.fancybox-1.2.1.js"></script>
<script>
$('ol#menu').simpleMenu();
</script>
</head>

<body>

<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">

<%-- <asp:Label runat="server" id="lblProjectName" Text="">--%>
<asp:Literal ID="ltlProjectName" runat="server">

<asp:Literal ID="ltlProjectDetails" runat="server">

Risk Assessment Ref:
<asp:Literal ID="ltlRef" runat="server">

Rev No:
<asp:Literal ID="ltlProjectRevNo" runat="server">

MSS No.:
<asp:Literal ID="ltlProjectMssNo" runat="server">

Date:
<asp:Literal ID="ltlProjectDate" runat="server">

<%--BIND DATA Here--%>

<asp:GridView runat="server" ID="gvProjectContent"
AutoGenerateColumns="false" onrowcreated="gvProjectContent_RowCreated"
onrowdatabound="gvProjectContent_RowDataBound" >
<columns> <asp:TemplateField HeaderText="Ref">
<itemtemplate>
<asp:Label ID="lblSlNo" runat="server" Text='<%#Eval("Content_Id") %>'>

<%-- <asp:TemplateField>
<HeaderTemplate>
SL NO</HeaderTemplate>
<itemtemplate>
<asp:Label ID="lblSlNoAuto" runat="server"
Text='<%#Container.DataItemIndex+1 %>'>

--%>

<asp:TemplateField HeaderText="Activity Element">
<itemtemplate>
<asp:Label ID="lblProjectName" runat="server" Text='<%#Eval("Activity_Element") %>'>

<asp:TemplateField HeaderText="Significant Potential Hazards">
<itemtemplate>
<asp:Label ID="lblProjectDetails" runat="server" Text='<%#Eval("Significant_Potential") %>'>

<asp:TemplateField HeaderText="Population at Risk">
<itemtemplate>
<asp:Label ID="lblRisk" runat="server" Text='<%#Eval("Population") %>'>

<asp:TemplateField HeaderText="Likelihood (L)">
<itemtemplate>
<asp:Label ID="lblRevNo" runat="server" Text='<%#Eval("Likelihood") %>'>

<asp:TemplateField HeaderText="Severity (S)">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Severity") %>'>

<asp:TemplateField HeaderText="Risk Rating (R)">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Risk_Rating") %>'>

<asp:TemplateField HeaderText="Risk Level Low/ Medium/ High">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Risk_Level") %>'>

<asp:TemplateField HeaderText="Action to be Taken to Reduce Risk">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Action") %>'>

<asp:TemplateField HeaderText="Responsibility for Implementation">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Responsibility") %>'>

<asp:TemplateField HeaderText="Severity (S)">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Severity2") %>'>

<asp:TemplateField HeaderText="Risk Rating (R)">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Risk_R") %>'>

<asp:TemplateField HeaderText="Risk Level Low/ Medium/ High">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("RiskLevel") %>'>

<asp:TemplateField HeaderText="Residual Risks">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Residual") %>'>

<asp:TemplateField HeaderText="Responsibility for Monitoring">
<itemtemplate>
<asp:Label ID="lblMssNo" runat="server" Text='<%#Eval("Monitoring") %>'>

Design and Developed by BIEOSH

</form>
</body>
</html>

my backend code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class WaterDSview_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

int companyid3 = Convert.ToInt32(Request.QueryString["companyupdate1id"]);

displayDetails(companyid3);
displaycontent(companyid3);
}
public void displayDetails(int companyid)
{
SqlConnection conDisplay = new SqlConnection("Data Source=OMEGA1-PC;Database=bieoshProduct;Integrated Security=True;");
SqlCommand comDisplay = new SqlCommand("SP_PROJECTDISPLAY", conDisplay);
comDisplay.CommandType = CommandType.StoredProcedure;
comDisplay.Parameters.AddWithValue("@companyiddisply", companyid);
conDisplay.Open();
SqlDataAdapter adcompanydisplay = new SqlDataAdapter();
adcompanydisplay.SelectCommand = comDisplay;
DataSet dscompanydisplay = new DataSet();
adcompanydisplay.Fill(dscompanydisplay);
conDisplay.Close();
// lblProjectName.Text = dscompanydisplay.Tables[0].Rows[0]["Project_Name"].ToString();
ltlProjectName.Text = dscompanydisplay.Tables[0].Rows[0]["Project_Name"].ToString();
ltlProjectDetails.Text = dscompanydisplay.Tables[0].Rows[0]["Project_Details"].ToString();
ltlRef.Text = dscompanydisplay.Tables[0].Rows[0]["Risk_Assessment_Ref"].ToString();
ltlProjectRevNo.Text = dscompanydisplay.Tables[0].Rows[0]["Rev_No"].ToString();
ltlProjectMssNo.Text = dscompanydisplay.Tables[0].Rows[0]["MSS_No"].ToString();
ltlProjectDate.Text = dscompanydisplay.Tables[0].Rows[0]["Project_Date"].ToString();
}
public void displaycontent(int companyid)
{
SqlConnection conContentDisplay = new SqlConnection("Data Source=OMEGA1-PC;Database=bieoshProduct;Integrated Security=True;");
SqlCommand comContentDisplay = new SqlCommand("SP_CONTENTDISPLAY", conContentDisplay);
comContentDisplay.CommandType = CommandType.StoredProcedure;
comContentDisplay.Parameters.AddWithValue("@contentdisplay", companyid);
conContentDisplay.Open();
SqlDataAdapter adContentDisplay = new SqlDataAdapter();
adContentDisplay.SelectCommand = comContentDisplay;
DataSet dsContentDisplay = new DataSet();
adContentDisplay.Fill(dsContentDisplay);
conContentDisplay.Close();
if (dsContentDisplay.Tables[0].Rows.Count > 0)
{
gvProjectContent.DataSource = dsContentDisplay.Tables[0];

gvProjectContent.DataBind();
}
else
{
gvProjectContent.EmptyDataText = "No records founds";
gvProjectContent.DataBind();
}
}

protected void gvProjectContent_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header) // If header created
{
GridView ProductGrid = (GridView)sender;

// Creating a Row
GridViewRow HeaderRow = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);

//Adding Year Column
TableCell HeaderCell = new TableCell();
HeaderCell.Text = "Ref";
// HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2; // For merging first, second row cells to one
// HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

//Adding Period Column
HeaderCell = new TableCell();
HeaderCell.Text = "Activity Element";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
// HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

//Adding Audited By Column
HeaderCell = new TableCell();
HeaderCell.Text = "Significant Potential Hazards";
// HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
// HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

//Adding Audited By Column
HeaderCell = new TableCell();
HeaderCell.Text = "Population at Risk";
// HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

//Adding Revenue Column
HeaderCell = new TableCell();
HeaderCell.Text = "Risk Classification";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.ColumnSpan = 3; // For merging three columns (Direct, Referral, Total)
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

HeaderCell = new TableCell();
HeaderCell.Text = "Risk Level Low/ Medium/ High";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

HeaderCell = new TableCell();
HeaderCell.Text = "Action to be Taken to Reduce Risk";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

HeaderCell = new TableCell();
HeaderCell.Text = "Responsibility for Implementation";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

HeaderCell = new TableCell();
HeaderCell.Text = "Revised Risk Classification";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.ColumnSpan = 2; // For merging three columns (Direct, Referral, Total)
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

HeaderCell = new TableCell();
HeaderCell.Text = "Risk Level Low/ Medium/ High";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

HeaderCell = new TableCell();
HeaderCell.Text = "Residual Risks";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

HeaderCell = new TableCell();
HeaderCell.Text = "Responsibility for Monitoring";
//HeaderCell.HorizontalAlign = HorizontalAlign.Center;
HeaderCell.RowSpan = 2;
//HeaderCell.CssClass = "HeaderStyle";
HeaderRow.Cells.Add(HeaderCell);

//Adding the Row at the 0th position (first row) in the Grid
ProductGrid.Controls[0].Controls.AddAt(0, HeaderRow);
}
}

protected void gvProjectContent_RowDataBound(object sender, GridViewRowEventArgs e)
{

}
}
the output which i am getting, gridview is soo long so i am showing in multiple screenshots

Posted 13-May-14 19:17pm

Uday Kumar Chary

Add a Solution

Comments

Thanks7872 14-May-14 1:46am

Look at your code dump and other questions here. Do you find any difference? No one will go through this code. There is no chance that you get your issue resolved. Edit the question and remove this unnecessary code dump. Post relevant code only.

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)

how to group columns under one column and merge rows ? after writing this code my gridview is not showing properly, please help me

Water Distribution Project for OMEGA INTERNATIONAL INSTITUTE OF FIRE AND SAFETY

<%-- <asp:Label runat="server" id="lblProjectName" Text="">--%> <asp:Literal ID="ltlProjectName" runat="server">

<asp:Literal ID="ltlProjectDetails" runat="server">

Risk Assessment Ref: <asp:Literal ID="ltlRef" runat="server">

Rev No: <asp:Literal ID="ltlProjectRevNo" runat="server">

MSS No.: <asp:Literal ID="ltlProjectMssNo" runat="server">

Date: <asp:Literal ID="ltlProjectDate" runat="server">