Regarding Gridview displaying information

EDN Admin · Oct 23, 2012

Hi,
Can anyone let me know where in the below code for grid view i am going wrong?
using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using MySql.Data.MySqlClient; 
using System.Diagnostics; 
using System.Net; 
using System.Net.Mail; 
using System.IO; 
using System.Text; 
using GridViewClassLibrary; 
 
 
namespace TOR_Tool 
{ 
public partial class _Default : System.Web.UI.Page 
{ 
protected void Page_Load(object sender, EventArgs e) 
{ 
GridViewHelper helper = new GridViewHelper(GridView1); 
helper.RegisterGroup("Subject", true, true); 
helper.RegisterGroup("id", true, true); 
helper.RegisterGroup("Created", true, true); 
helper.RegisterGroup("Content", true, true); 
helper.RegisterGroup("Status", true, true); 
 
helper.GroupHeader += new GroupEvent(helper_GroupHeader); 
 
 
helper.ApplyGroupSort(); 
DataUtiliities dt = new DataUtiliities(); 
 
GridView1.DataSource = dt.ExecuteDataSet("select distinct t.id,t.Subject,t.Status,max(t.created),replace(cast(Content as char), ,) as Content,max(a.created)
as Created,u.name from rt.Tickets t inner join rt.Transactions tr on tr.objecttype =RT::Ticket and tr.ObjectId = t.id inner join rt.Attachments a on a.transactionId = tr.id inner join rt.Users u on u.id = a.creator where status in (pending) and t.queue
= 4 and name != RT_System and Content not like %WordDocument% and Content not like %word% and Content not like %div% and Content not like %H001% and Content not like %&nbsp% group by t.Subject"); 
 
GridView1.DataBind(); 
 
} 
private void helper_GroupHeader(string groupName, object[] values, GridViewRow row) 
{ 
//row.BackColor = Color.AliceBlue; 
row.Cells[0].Font.Bold = true; 
row.Cells[0].Text = "        " + groupName + "    -   " + row.Cells[0].Text; 
 
} 
protected void Button1_Click(object sender, EventArgs e) 
{ 
MailMessage mail = new MailMessage(); 
mail.Body= GridViewToHtml(GridView1);
 
mail.IsBodyHtml = true; 
mail.Subject = ""; 
mail.To.Add("abc@xyz.com"); 
mail.From =new MailAddress ("ghi.corp@xyz.com"); 
SmtpClient smptp = new SmtpClient(); 
smptp.Host= "ghi.corp@xyz.com"; 
smptp.DeliveryMethod = SmtpDeliveryMethod.Network; 
smptp.Send(mail); 
 
 
} 
private string GridViewToHtml(GridView gv) 
{ 
 
StringBuilder sb = new StringBuilder(); 
StringWriter sw = new StringWriter(sb); 
HtmlTextWriter hw = new HtmlTextWriter(sw); 
gv.RenderControl(hw); 
return sb.ToString(); 
} 
public override void VerifyRenderingInServerForm(Control control) 
{ 
// 
} 
 
 
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) 
{ 
GridView1.PageIndex = e.NewPageIndex; 
GridView1.DataBind(); 
} 
 
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) 
{ 
 
} 
} 
} 
 
 
 
 
 
aspx: 
 
 
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" 
CodeBehind="Default.aspx.cs" Inherits="Tool._Default" EnableEventValidation="false" %> 
 
<%--<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="HeadContent 
</asp:Content>--%> 
<asp:Content ID="Content2" runat="server" ContentPlaceHolderID="MainContent 
<asp

anel ID="pnlControls" runat="server 
<table> 
<tr> 
<td> 
<asp:Label ID="lblShift" runat="server" Text="Shift:" Width="100px"
 
Height="16px </asp:Label> 
</td> 
<td> 
<asp

ropDownList ID="ddlShift" runat="server 
<asp:ListItem Text="1st Shift" Value="1 </asp:ListItem> 
<asp:ListItem Text="2nd Shift" Value="2 </asp:ListItem> 
<asp:ListItem Text="3rd Shift" Value="3 </asp:ListItem> 
</asp

ropDownList> 
</td> 
</tr> 
<tr> 
<td colspan="2 
<asp:GridView ID="GridView1" runat="server" Height="50px" Width="800px" AutoGenerateColumns="false" 
AllowPaging="true" OnPageIndexChanging="GridView1_PageIndexChanging" PageSize="50" 
OnSorting="GridView1_Sorting 
<Columns> 
<asp:BoundField DataField="id" HeaderText="id " /> 
<asp:BoundField DataField="Subject" HeaderText="Problem: " /> 
<asp:BoundField DataField="Status" HeaderText="Status" />
 
<asp:BoundField DataField="created" HeaderText="Reported:" /> 
<asp:BoundField DataField="Content" HeaderText="Actions Performed: " /> 
</Columns> 
<RowStyle Height="40px" Width="250px" /> 
</asp:GridView> 
</td> 
</tr> 
<tr> 
<td> 
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" /> 
</td> 
</tr> 
</table> 
</asp

anel> 
</asp:Content> 
<asp:Content ID="Content3" runat="server" contentplaceholderid="HeadContent 
<style type="text/css 
.style1 
{ 
width: 25px; 
} 
</style> 
</asp:Content> 

when i exceute the above code i get:
 
Subject - CCL Freedom - RAU 1-3-4, 2-3-7, 2-4-7 RF path loss
 
id - 4796
 
Created - 10/14/2012 12:03:41 PM
 
Content - Paul is making visit this week end. Send initial troubleshooting email to vessel. 
Status - pending
 
 
 
Subject - CEL Infinity - RAU 2-2-1 disconnected
 
id - 5150
 
Created - 8/29/2012 1:56:32 PM
 
Content - The RAU 2-2-1 is disconnected. Sent initial troubleshooting email to the vessel. 
 
 
Subject - CEL Summit - RAU 2-1-6 disconnected
 
id - 5354
 
Created - 10/18/2012 8:50:46 PM
 
Content - Sent an initial troubleshooting email to the vessel.
 

but i want to get the status for each and every grid like:
 
Subject - CCL Freedom - RAU 1-3-4, 2-3-7, 2-4-7 RF path loss
 
id - 4796
 
Created - 10/14/2012 12:03:41 PM
 
Content - Paul is making visit this week end. Send initial troubleshooting email to vessel. 
Status - pending
 
 
 
Subject - CEL Infinity - RAU 2-2-1 disconnected
 
id - 5150
 
Created - 8/29/2012 1:56:32 PM
 
Content - The RAU 2-2-1 is disconnected. Sent initial troubleshooting email to the vessel. 
Status - pending 
 
Subject - CEL Summit - RAU 2-1-6 disconnected
 
id - 5354
 
Created - 10/18/2012 8:50:46 PM
 
Content - Sent an initial troubleshooting email to the vessel.
 
Status - pending

Thanks!!
<hr class="sig rr

View the full article

Regarding Gridview displaying information

EDN Admin

Well-known member

Similar threads