Avoid Repeat In Gridview Row [Answered]RSS

• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Avoid Repeat In Gridview Row

  Apr 02, 2017 11:56 AM|asp.ambur|LINK

  Hello

  This is my gridivew look like it has some 10 column for example i have taken two columns first and second

  

  but i want like this below

  

• • Reply
  kaushalparik...

  All-Star

  31342 Points

  7050 Posts

  Re: Avoid Repeat In Gridview Row

  Apr 02, 2017 01:28 PM|kaushalparik27|LINK

  Modify your data source for GridView before assigning to it, and use ColumnSpan in RowCreated or RowDataBound event if underlying DataItem is blank. To modify DataSource, just loop through the data source and check current data row with previous value and if both Date and Dc No matches then modify that data source row with blank value.

  And further as I said, use ColumnSpan in RowCreated or RowDataBound event if underlying DataItem is blank.

  hope that helps./.

  नमस्ते,
  [KaushaL] Blog Twitter [MS MVP 2008 & 2009] [MCC 2011] [MVP Reconnect 2017]
  Don't forget to click "Mark as Answer" on the post that helped you
• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Avoid Repeat In Gridview Row

  Apr 02, 2017 01:38 PM|asp.ambur|LINK

  Can you give me sample code pls
• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Avoid Repeat In Gridview Row

  Apr 02, 2017 01:50 PM|asp.ambur|LINK

  kaushalparik27

  Modify your data source for GridView before assigning to it, and use ColumnSpan in RowCreated or RowDataBound event if underlying DataItem is blank. To modify DataSource, just loop through the data source and check current data row with previous value and if both Date and Dc No matches then modify that data source row with blank value.

  And further as I said, use ColumnSpan in RowCreated or RowDataBound event if underlying DataItem is blank.

  hope that helps./.

  okay i will try

• • Reply
  kaushalparik...

  All-Star

  31342 Points

  7050 Posts

  Re: Avoid Repeat In Gridview Row

  Apr 02, 2017 01:52 PM|kaushalparik27|LINK

      public partial class WebForm77 : System.Web.UI.Page
      {
          protected void Page_Load(object sender, EventArgs e)
          {
              if (!IsPostBack)
              {
                  DataTable dtSource = GetSampleData();
                  FilterData(dtSource);
                  GridView1.DataSource = dtSource;
                  GridView1.DataBind();
              }
          }
  
          private void FilterData(DataTable dtSource)
          {
              List<Int32> indexListToBlack = new List<Int32>();
              for (int i = 0; i < dtSource.Rows.Count; i++)
              {
                  string previousDate = string.Empty;
                  string previousNo = string.Empty;
                  string currentDate = string.Empty;
                  string currentNo = string.Empty;
                  if (i == 0)
                      continue;
                  else
                  {
                      previousDate = dtSource.Rows[i - 1]["IssueDate"] as string;
                      previousNo = dtSource.Rows[i - 1]["DcNo"] as string;
  
                      currentDate = dtSource.Rows[i]["IssueDate"] as string;
                      currentNo = dtSource.Rows[i]["DcNo"] as string;
  
                      if (currentDate.Equals(previousDate) && currentNo.Equals(previousNo))
                          indexListToBlack.Add(i);
                  }
              }
              for (int i = 0; i < indexListToBlack.Count; i++)
              {
                  dtSource.Rows[indexListToBlack[i]]["IssueDate"] = string.Empty;
                  dtSource.Rows[indexListToBlack[i]]["DcNo"] = string.Empty;
              }
          }
  
          private DataTable GetSampleData()
          {
              DataTable dtResult = new DataTable();
              dtResult.Columns.AddRange(new DataColumn[] { new DataColumn("IssueDate"), new DataColumn("DcNo") });
  
              DataRow dr = dtResult.NewRow();
              dr["IssueDate"] = "01-March-2017";
              dr["DcNo"] = "1058";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "01-March-2017";
              dr["DcNo"] = "1058";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "01-March-2017";
              dr["DcNo"] = "1058";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "01-March-2017";
              dr["DcNo"] = "1058";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "02-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "02-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "02-March-2017";
              dr["DcNo"] = "KLSA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "02-March-2017";
              dr["DcNo"] = "KLSA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "NA";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "YES";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "YES";
              dtResult.Rows.Add(dr);
  
              dr = dtResult.NewRow();
              dr["IssueDate"] = "03-March-2017";
              dr["DcNo"] = "YES";
              dtResult.Rows.Add(dr);
  
              return dtResult;
          }
  
          protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
          {
              if (e.Row.RowType == DataControlRowType.DataRow)
              {
                  if (Convert.ToString((e.Row.DataItem as DataRowView)["IssueDate"]).Equals(string.Empty))
                  {
                      e.Row.Cells[0].ColumnSpan = 2;
                      e.Row.Cells.RemoveAt(1);
                  }
              }
          }
      }

  <asp:GridView 
      runat="server" 
      ID="GridView1" 
      AutoGenerateColumns="false" 
      OnRowCreated="GridView1_RowCreated">
      <Columns>
          <asp:BoundField DataField="IssueDate" HeaderText="Date of Issue" />
          <asp:BoundField DataField="DcNo" HeaderText="No" />
      </Columns>
  </asp:GridView>

  
  
  

  नमस्ते,
  [KaushaL] Blog Twitter [MS MVP 2008 & 2009] [MCC 2011] [MVP Reconnect 2017]
  Don't forget to click "Mark as Answer" on the post that helped you