Display (Bind) formatted result returned from database in ASP.Net GridView

nauna

SOLVED CLOSED ACTIVE ANSWERED
User: nauna
Posted: on Jan 21, 2020 02:10 AM
Forum: Data Controls
Answer: 1
Views: 1697

hello,

i have this result set from query check name column

some column values are forward some are backup i want to show the same formating in gridview when it as sql give out put

its give output as formatted when i bind it with gridview it does not retain formatting

WITH DirectReports (ID, PARENT_NAMEID,HLevel,NAME,Displayname, catnames, ctype, atype, acode, isedit, cguid)        
AS        
(        
    -- Anchor member definition        
    SELECT    cm.chart_id,
            cd.parent_chart_id,
            0 as HLevel,			
            cast(cm.chart_name as varchar(max)) as NAME,    
            cast(Right(10000 + (cast('0' as varchar(max)) + cast(cm.chart_id as varchar(max))),4) as varchar(max)) as Displayname   ,
			   cast(cm.chart_name as varchar(max)) as  catnames,
			   cd.charttype,
			   cd.accounttype,
			   cd.code,
			   cd.iseditable, 
			   cd.chartguid
    FROM chart_master cm
        INNER JOIN chart_master cd ON cm.chart_id =  cd.chart_id
    WHERE cm.parent_chart_id =0 and cm.IsPublished=1
   
    UNION ALL        
    
    -- Recursive member definition        
    
    SELECT    cm.chart_id,
            cd.parent_chart_id,
            HLevel+1,
            cast((RIGHT('                                   ',(HLEVEL + 1) * 4) + isnull(cm.chart_name,'')) as varchar(max)) as NAME,
            cast(cast(Displayname as varchar(max)) + cast(cm.chart_id as varchar(max)) as varchar(max)) as Displayname  ,
		  cast(cast(catnames as varchar(max)) + ' ----------> '+ cast(cm.chart_name as varchar(max)) as varchar(max)) as catnames ,
		   cd.charttype,
			   cd.accounttype,
			   cd.code,
			   cd.iseditable, 
			   cd.chartguid 
		
     FROM chart_master cm 
            INNER JOIN chart_master cd on cm.chart_id =  cd.chart_id
            INNER JOIN DirectReports d on cd.parent_chart_id = d.ID      
            
)        
-- Statement that executes the CTE        

SELECT ID, PARENT_NAMEID,HLevel,[NAME],Displayname,catnames, ctype, atype,acode ,isedit, cguid  ,
(select chart_id from [dbo].[f_topcat] (ID)

) as parentid
from DirectReports

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Jan 21, 2020 02:22 AM
Report

Hi nauna,

You need to change the space with   in your query and bind the GridView column with Eval function if TemplateField and set HtmlEncode if BoundField column.

Refer below example.

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" />
        <asp:BoundField DataField="Name" HeaderText="Name" HtmlEncode="false" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Label Text='<%#Eval("Name") %>' runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Code

protected void Page_Load(object sender, EventArgs e)
{
    System.Data.DataTable dt = new System.Data.DataTable();
    dt.Columns.AddRange(new System.Data.DataColumn[] { 
        new System.Data.DataColumn("Id"), new System.Data.DataColumn("Name") });
    dt.Rows.Add(1, "Postage");
    dt.Rows.Add(2, "&nbsp;&nbsp;Maintainance");
    dt.Rows.Add(3, "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MCTP");
    dt.Rows.Add(4, "&nbsp;&nbsp;&nbsp;Travel");
    GridView1.DataSource = dt;
    GridView1.DataBind();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim dt As System.Data.DataTable = New System.Data.DataTable()
    dt.Columns.AddRange(New System.Data.DataColumn() {New System.Data.DataColumn("Id"), New System.Data.DataColumn("Name")})
    dt.Rows.Add(1, "Postage")
    dt.Rows.Add(2, "&nbsp;&nbsp;Maintainance")
    dt.Rows.Add(3, "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MCTP")
    dt.Rows.Add(4, "&nbsp;&nbsp;&nbsp;Travel")
    GridView1.DataSource = dt
    GridView1.DataBind()
End Sub

Output

Id	Name
1	Postage	Postage
2	Maintainance	Maintainance
3	MCTP	MCTP
4	Travel	Travel

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display (Bind) formatted result returned from database in ASP.Net GridView

Company

Explore

Follow us

Contact Us