Solved

i want to create html table using linq query that to in the .aspx page (not in aspx.cs page)

Posted on 2008-11-03
4
720 Views
Last Modified: 2013-11-11
i want to create html table dynamically using linq query but in the .aspx page (not in aspx .cs page)

something like this......
<table>
    <% var menu=from mnu in ever.L_MENU_MASTERs
        where mnu.FK_PARENT_ID == 0
        select new { mnu };
                  %>               
           <%if mnu.count>0%> 
blah blah...
create   <tr > and <td>                
                          
    </table>

Open in new window

0
Comment
Question by:sathyanreddy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:naspinski
ID: 22866659
That will be easy.

First, in grab a LinqDataSource from your toolbox, and drag it on to the page.  Configure it to pull the information you want from the database.

Then pull in a gridview and set that LinqDataSource as the DataSource.

Table made!
0
 

Author Comment

by:sathyanreddy
ID: 22873993
Hi thanks for repling but i want to show data in a html table not in Grid view.
i have already done it for ado.net now i need it for linq
Any suggestion plz......
0
 
LVL 21

Accepted Solution

by:
naspinski earned 250 total points
ID: 22874017
A gridview is a table.

But if you want to write it manually, you could use a repeater:
<table>
    <asp:Repeater ID="rpt" runat="server" 
        DataSourceID="LinqDataSource_You_Made">
        <ItemTemplate>
            <tr>
                <td><%# Eval("a_column") %></td>
                <td><%# Eval("another_one") %></td>
            </tr>
        </ItemTemplate>
    </asp:Repeater>
</table>

Open in new window

0
 

Author Comment

by:sathyanreddy
ID: 22875131
Hi thanks
It almost suits my situation but i need the grid should ot be loaded every time i.e
if (ispostback==false)
{
gridfill()
}
that i am unable to do with ur coding

as am writing urs coding in the following way

<table>
    <asp:Repeater ID="rpt" runat="server"
        DataSourceID="LinqDataSource1">
        <ItemTemplate>
       
            <tr>
                <td style="display:none;"><%# Eval("PK_ID")%></td>
                <td>
                <a href="" onclick='javascript:return redirect(<%# Eval("PK_ID")%>);return false;'><%# Eval("MENU_NAME")%></a></td>



and with java script

function redirect(id){
    alert(id);
    location.href = "Default3.aspx?pkid='" + id;
        alert(location.href);
   
}

            </tr>
        </ItemTemplate>
       
    </asp:Repeater>
   
</table>


which is not redirecting
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In this tutorial viewers will learn how to style elements, such a divs, with a "drop shadow" effect using the CSS box-shadow property Start with a normal styled element, such as a div.: In the element's style, type the box shadow property: "box-shad…
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question