ASP.NET

"SELECT * FROM [Table] WHERE [FromDate] >= '" + FromDate.Value  + "' AND [ToDate] <= '" + ToDate.Value + "';"

   var myTableData = dataContextInstance.MyTable.Where( e => e.FromDate >= DateTime.Parse( FromDate.Value ) && e.ToDate <= DateTime.Parse( ToDate.Value ) ).ToList();

//This will simply return a list or data matching your linq-query and there are many ways you can loop through a list e.g. for-loop, each loop

Member 7980675 wrote:

binding database values with img tag instead of image control

<asp:Image ID="img1" runat="server" ImageUrl='<%# Eval("path") %>'></asp:Image>

<img id="image1" src='<%# Eval("path") %>' />

<asp:DataList ID="DataList1" runat="server"
  RepeatDirection="Horizontal"
  RepeatColumns="4"
  CellPadding="5"
  CellSpacing="10"
>
    <ItemTemplate>
        <div>
        <p><img id="image1" runat="server" border="0" src='<%#Eval("image_name") %>' style="border-color:#FFCC01;border-style:outset;border-width:8px;" height="200" width="120" /><p>
        <br />
        </div>
    </ItemTemplate>
</asp:DataList>

<script type="text/javascript">
$(document).ready( function() {
  $("#<%= DataList1.ClientID %> img").animate();
});
</script>

<table id="DataList1.ClientID">
<tr><td>
<img id="DataList1.ClientID_ctr100_Image1" ... />
</td> ... </tr>
...

</table>

<asp:LoginView ID="LoginView1" runat="server">
    <RoleGroups>
        <asp:RoleGroup Roles="admin,fileadmin,contentadmin">
            <ContentTemplate>
                hello group 1 !
            </ContentTemplate>
        </asp:RoleGroup>
        <asp:RoleGroup Roles="admin">
            <ContentTemplate>
                hello admin !
            </ContentTemplate>
        </asp:RoleGroup>
    </RoleGroups>
</asp:LoginView>

Professional manpreet wrote:

how to kill user session in asp.net