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
716 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
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:naspinski
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Showing your events from Google Calendar in Google Maps Why? I travel all week and I thought it would be ideal if staff in office knew where I was based on my calendar. (OK real reason: my son wanted to see where I would be working, and I thoug…
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
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 basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now