How To Create Category And List In One Query With Linq
Jun 20, 2010
I want to create something like this using a DataList and Flow markup:
|-----------------------|
| Title |
|-----------------------|
| [x] Title |
| [x] Title |
| ... |
-------------------------
I have a table (modeled in Linq2Sql) Foo that has these fields
int id;
int? parentId;
string title;
Foo Parent;
EntitySet<Foo> Children;
Now, when there is a null parent, it means it's a top level category, and if the parent has a value, it's part of the category list.
I have created a DataList, and used a LinqDataSource with a query that looks like this:
[Code].....
This obviously doesn't work. How can I utilize the Children collection in a repeater of a DataList item?
View 1 Replies
Similar Messages:
Oct 17, 2010
I am writing a linq query to select a blogpost,
[code]....
The blogpost i am testing got 3 tags attached to it. The table structure is:
(table)BlogPost -> (table)BlogPostTags <- (table)Tags
So the BlogPostTags table only contains 2 fields, BlogPostID and TagID.
When i run the query above i get 3 results back. Same blogpost 3 times but with 1 tag in each. It should return 1 post with 3 tags. The problem lies in the Tags query above.
View 1 Replies
Aug 11, 2010
[Code]....
say i have the code above which adds a single row to a list how would i add all the information in a linq query or a var to the list?
View 2 Replies
Mar 5, 2010
I have list of words. I type in a word misspelled. Can I query the list using linq to get words that sounds like (soundex) the misspelled word?
View 2 Replies
Jun 13, 2010
how to extract DataTable or DataSet from Linq Query or List. e.g I have linq query like this
MyDBpDataContext dcSp = new MyDBpDataContext();
dcSp.myProgrammSP().ToList();
I wrote an Sp which sends a Table as result and I have code which is already using DataTable So I want to convert this result in DataTable.
View 1 Replies
Mar 8, 2011
i"ve build a small (verry small) test app with a UI and a domain model and i'm able to show all the data from one table but now i wanna create a query so i only get the data i want but i have no idea how to do this. i've created a domain model with a entity class, an abstract and a concrete repository (see code)
[Code]....
namespace winkelketen.domain.Abstract{ public interface IwinkelketenRepository { IQueryable<Winkelketen> Winkelketen { get; } }}
namespace winkelketen.domain.Concrete{ public class SqlWinkelketenRepository : IwinkelketenRepository { private Table<Winkelketen> productsTable; public SqlWinkelketenRepository(string connectionString) { productsTable = (new DataContext(connectionString)).GetTable<Winkelketen>(); } public IQueryable<Winkelketen> Winkelketen { get { return productsTable; } } }}
and then i created a UI with a controller
[Code]....
and a view
[Code]....
could something give me some tips how to do this or how to get started?
View 2 Replies
Dec 9, 2010
<a href='<%# VirtualPathUtility.ToAbsolute("~/ProductsList.aspx?CategoryId=" + Eval("CategoryID")) %>'><%# Eval("CategoryName") %></a>
it bring me this error Conversion from string "~/Products.aspx?CategoryId=" to type 'Double' is not valid.
View 1 Replies
Sep 27, 2010
Is there a straightforward way to create a dataset after querying a dataview? The query itself returns DataRowView objects, which I cannot get to work with CopyToDataTable().
The query looks like:
Dim dvQueryView As DataViewdvQueryView = (dataview object of large dataset)
detailTableQuery = From rowView
As DataRowView
In dvQueryView _
Order
By sSortOrder _
Select rowView _
Skip nQuerySkipRow _
Take nQueryCountRows
I only want a small selection of records from the large dataview and use those to create a smaller dataset. The large dataset stays in place while multiple views are created from it, and then from those views I want to create the smaller datasets.
View 7 Replies
Dec 26, 2010
I have a basic Linq query and what I need to do is query the DB then display the data in HTML.Typically I would bind this to a control but in this instance I need to actually generate the HTML in the code behind page.The Linq query is very basic something like this with Northwind:[Code]....
Instead of binding that to a gridview how can I write out the html... I'm sure I can use stringbuilder or smilar to create the html but I'm not sure how to get he data in the tables... foreach datarow in?
View 5 Replies
May 28, 2010
I'm looking to translate an SQL query into linq
INNER JOIN Usrs ON
SAQ.UserId =
Usrs.UserId AND Scan.UserId =
Users.UserId
I'm not sure how to include the "AND" in the LINQ statement.
View 3 Replies
May 8, 2010
I am trying to create linq from A list:
[Code]....
But I always get this error:
[Code]....
I'm using this class to do search:[URL]
View 8 Replies
Jan 26, 2010
How do you create a databound checkbox list using linq-sql and asp.net mvc
View 1 Replies
Sep 30, 2010
I am wonder how I can generate a result table from linq to sql as below
Car sales table
Toyota small
Toyota passenger
Toyota small
Honda small
Honda small
Honda passenger
Honda small
result table
Brand small passenger total
Toyata 2 1 3
Honda 3 1 4
GridView1.DataSource = (from dtCarSales.AsEnumerable() .....
View 3 Replies
Oct 26, 2010
I have a function in sitefinity that returns a list of categories.
//return list of categories
private IList<ICategory> GetCategoryDataSource() {
var cntManager = new ContentManager(CaseStudyManager.DefaultContentProvider);
IList allCategories = cntManager.GetCategories();
List<ICategory> filteredList = new List<ICategory>();
foreach (ICategory category in allCategories) {
filteredList.Add(category);
}
return filteredList;
}
What I want to know is how to sort this list.
Categories in Sitefinity are as far as i can tell just a string, there are no other fields associated with a category. Therefore I have nothing to sort the categories on, other than appending each category with a number, like:
1 - Legal
2 - Financial
3 - Property
When these categories are displayed on the website I can then at least trim the parts i need.
View 2 Replies
Nov 5, 2010
i create example using Northwind database so i create a new website and add new ADO.Net Entity Data Model (.edmx) called Northwind.edmx and i add Categories and Products table inside this (.edmx) file
and add new ADO.Net Data Servuce called "ADODataService" and add it as WebReferences called NorthwindService
so i add new web page and drag DropdownList and Gridview as i want to bind Dropdownlist to all categories and when i select category from Dropdownlist bind Gridview to all Products related to this category
so my code
[Code]....
and my code
[Code]....
so when i select category from Dropdownlist nothing happen :(
also you will find commented code in method BindCategory whuch is not work also.
View 1 Replies
Feb 7, 2010
I'll try to explain as simple as I can in text what my problem is. I don't see any other way to make my issue clear.
I have a GridView that uses an ObjectDataSource.
The ObjectDataSource has an DataObjectTypeName defined, so I pass/get complete objects or list of objects to/from the data access methods.
The objects I'm working with, let's say we work with Book objects, contain a Title and a Category, BUT the Category is an object itself. When the Select method is called, we get a List of Book objects, which is perfectly displayed, overridden ToString method in the Category objects within the Book objects.
The problem I face is that I can't find a way to update the category in my GridView. What I did already accomplish is:I used a template field in the GridView for the Category so I could use a DropDownList for that field in Edit mode.
I bound the DropDownList to another ObjectDataSource that gives me a list of CategoryObjects.
So when I enter Edit mode... the row shows a nice ddl with the available categories. It even selects the right original category.
So far so good... but when I want to save my new selection, I get an error that a string (the selected category in the ddl) cannot be converted to a Category object (that's what the Book object, that is going to be used for the update, expects).
View 5 Replies
Mar 30, 2011
I am working in a project that is a musical website. I want to display the web page with all categories I have. In my database , named Category_Master, I have two fields like Category_Id (which is a primary key ) and Category_Name. I have generated category_Id with NEWID() function. The category_Id is not supposed to display on the web page. But, i have to select Category_Name and according to that , I have to get the category_Id. If I am using Static connection with SqlDataSource, i am able to make visible=false property so that the category_id won't be visible. But , at that time, I can't write code to Select the category_id of the selected index.
If i am using disconnected approach, I filled the dataset with the Category_Master, and binded it to GridView. But, at that time, I can't hide the category_id from the user. I want to select category_id by clicking on the category_name with out displaying category_id ..?
View 4 Replies
Jul 27, 2010
i have a product page that can potentially take in the following optional query string params:
Category, OrderBy, Page
How do I create my route so the urls show up like this:
Products/Category/Electronics
Products/Category/Electronics/OrderBy/Price
Products/Category/Electronics/OrderBy/Price/Page/1
basically, im trying to not use the ? for my query string params.
View 1 Replies
Feb 11, 2011
Nested Repeater Issue: Each category list gets populated with the same set of date values rather then being populated with the data associated with that category. Trying to Do: Trying to group FAQ's by category and then list them using the repeaters.
The data is queryed though a business logic layer object that makes a call to the data access layer object. The data access layer object uses linq to sql to return data. There are 3 parameters that are passed into the innerDataSource's ObjectDataSource control to populate the nested repeater control (propID, CatID, isVisible).
With the debugger, the correct data is being returned and written to the nested repeater firing from the nested repeater's ItemDataBound event. Once this event is finished, another event fires and runs the FAQRule object again on the business logic layer which re-populates the nested repeater with the same data for each category. I have 2 repeaters, outerRepater (parent) and innerRepeater(child) with 2 ObjectDataSource controls innerDataSource and outerDataSource. See code below : ASP Page:
<asp:Repeater DataSourceID="outterDataSource" EnableViewState="false" runat="server">
<ItemTemplate>
<%# Eval("Description") + " " + this.Property.PropertyName %>
<asp:Repeater EnableViewState="false" runat="server" DataSourceID="innerDataSource">
<HeaderTemplate>
<ul style="width: 500px">
</HeaderTemplate>
<ItemTemplate>
<div><%# Eval("Question") %></div>
<div><p><%# Eval("Answer") %></p></div>
</ItemTemplate>
<FooterTemplate>
</ul>
</FooterTemplate>
</asp:Repeater>
<asp:ObjectDataSource ID="innerDataSource"
runat="server"
SelectMethod="FetchFAQSByPrpAndCatID"
TypeName="PropertySite.BusinessRules.FAQRules">
<SelectParameters>......................................
View 3 Replies
Feb 11, 2011
I want to use "if statement" in Linq query. How can I do this situation?
For example:
if txtAge.Text=="", I will not use that in Linq Query.
else txtAge.Text!="", I will use that in Linq Query.
View 8 Replies
Mar 26, 2010
Create a report to show the number of downloads per category. Order it by the number of downloads. Group it by category. The group header should contain total no. of downloads, which should be expandable to show actual no. of downloads sub category wise. The sub categories should also show the total no. of downloads for that subcategory. Each subcategory should be expandable and show the download numbers per product..
i have imlemented matrix for it so no need to insert group additionaly.i am facing problem in 'Order it by the number of downloads' when ever i use aggregate funtion for sorting it gives error like sort expression out of matrix
View 1 Replies
Mar 25, 2011
've created a simple gridView which lists all products based on category within a dropDownMenu (select * where CatID = dropDownMenu).This works just fine, but is there a simple way to add 'Show All' in the dropDownMenu -
View 5 Replies
Sep 14, 2010
I've build a linq query.But i want a random selection so its not always ID : 1,2,3,4,5,6 How can i randomize this var? I like to bind it to a repeater.//TagCloud:
Random rand = new Random();
var tc1 = from i in JumpTide.cms.menu.GetMenuItems(32)
select new
[code]...
View 1 Replies
Mar 10, 2010
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 Replies
Mar 19, 2011
I am facing a big problem with simple linq query.. I am using EF 4.0..
I am trying to take all the records from a table using a linq query:
var result = context.tablename.select(x=>x);
This results in less rows than the normal sql query which is select * from tablename;
This table has more than 5 tables as child objects (foreign key relations: one to one and one to many etc)..
This result variable after executing that linq statement returns records with all child object values without doing a include statement.. I don't know is it a default behavior of EF 4.0 . I tried this statement in linqpad also..but there is no use... But interesting thing is if I do a join on the same table with another one table is working same is sql inner join and count is same..but I don't know why is it acting differently with that table only.. Is it doing inner joins with all child tables before returning the all records of that parent table?
View 2 Replies
