?
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
Medium Priority
?
722 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 750 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

WordPress Tutorial 2: Terminology

An important part of learning any new piece of software is understanding the terminology it uses. Thankfully WordPress uses fairly simple names for everything that make it easy to start using the software.

Question has a verified solution.

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

This article discusses how to create an extensible mechanism for linked drop downs.
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
In this tutorial viewers will learn how to style transparent/translucent elements using alpha transparency in CSS Start with a normal styled element, such as a div.: Define its "background-color" property as "rgba (255, 255, 255, .5): The numbers in…
In this tutorial viewers will learn how to embed videos in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <video> tag to insert a video. Define the src as the URL of your video; this is similar to …
Suggested Courses

764 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