I can select IQueryable<object-type> data fine from a data repository class and push it into a list type MVC view, but how do I do this and group that data - I don't seem to be able to find any examples on this.
View 9 RepliesIf I have a View for 'People' and a View for 'Company' and each has an associated list of 'Orders', should there be a separate view for each? Such as /People/Orders and Company/Orders, or should I simply have a single /Orders views and pass in some parameters?
View 9 Repliesi have a movie object and the movie have comments collection inside it
public class Movie
{
public List<Comment> Comments{ get; set; }
}
so i have a strongly type view like this :
public ActionResult Details(int id)
I am working on an application that has two tables (amongst others) that are related by a Guid Foreign key. The parent table for this guid key is the aspnet_users table and the child table happens to be my employees table which has amongst other columns EmployeeID, FirstName, LastName, EmployeeType, NationalID etc. ant the referenced UserId column from the parent table. I have managed to get the dropdownlists (for UserId and Employee Type) displaying in my create view but have failed to have it create an employee since the guid value from the Dropdown list for UserId cannot bind when posting the form data. I am using Entity Framework 4 , VS 2010 and .Net 4
View 6 Replieshere is my code:
return from c in db.TBLcharacters
join o in db.TBLjobs on c.char_job equals o.job_title
orderby c.char_lastname descending
select c;
The goal is to print out the job title from the seperate table when I list the names of the Employees. So in the final formatting on the view it would be John Doe [Janitor] (or something similiar)
But when I make the build I get the following error:
The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'.
What I find wierd is cjar_job and job_title are both varchars so the type is the same.
i just started to get this error.
View 1 RepliesHow would i create a details view that also contains a list?
My aim is to have a details view that displays information about a person and then have a list on the same page that displays facts about that person.
Currently, my details view is working fine. I just need to add the list part. The details view inherits Models.MyViewModel which is a custom class as the details come from multiple tables.
I am using an adapter to get a list with IN where clause as:
[Code]....
I passed the parameter, CatIDList, with string value 1, 2, 3, 4, 5
However, it returns error of Error converting nvarchar value.
When I try to bind code that calls a stored proceure as a List to a view I get :-
The model item passed into the dictionary is of type 'System.Collections.Generic.List` but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`
How do I create the view if I want to bind a List<stored_procedure_name>?
I have an Employee model that has a Name and Company
I want to be able to build multiple Employees in one CREATE view. I figured I need to create an IList<Employee> and do something like:
<%= Html.TextBoxFor(m => m[0].Name) %>
<%= Html.TextBoxFor(m => m[0].Company) %>
<%= Html.TextBoxFor(m => m[1].Name) %>
<%= Html.TextBoxFor(m => m[1].Company) %>
If a user clicks on "Add another employee", I want the view to make another form for the new employee:
<%= Html.TextBoxFor(m => m[3].Name) %>
<%= Html.TextBoxFor(m => m[3].Company) %>
And continue to add form items (and increment the array index if they click on it again).
Keep in mind that I need to build the form and the list dynamically in the create view. I don't already have a populated list of Employees.
i need to create a list view that displays items circularly. (that is when the top most item is hiding a new item should appear at the bottom)
View 2 RepliesI'm trying to create a list (customized grid) with data pulled from the database and display it to the user in a format that looks very much like a forum thread and replies or posts.Which each of these "posts" I require to have buttons specific to that particular column to edit, delete etc.
View 2 RepliesI am an ASP newbie and I am trying to create a listview with rows and columns that are the same height on every page, rather than shifting when you click the Next button. Is there a style or something you use when you create the listview?
View 5 RepliesI am trying to create a list view to provide functionality similiar to the pages in this article(will end up being much simpler in my case)
[URL]
Basically I need three columns. Column 1 will be populated on page load with a list of user names and some data. Clicking on a user from column 1 will query for data regarding that user and bring back multiple rows to be displayed in Column 2. Clicking on data from a row in column 2 will return rows to be displayed in column 3. I am just curious as to how some of you guys would approach this. Ive looked at grouping templates and some articles regarding listviews with multiple rows but. Would it be easier to use 3 seperate listviews? Any ideas or articles to point me in the right direction?
I put a server side button on the header page. The website is running fine. I use the same source and put it on IIS, it's also working fine but the problem is, i couldn't compile it anymore using my VS studio. It's showing no error so when I go and check the output (after scrolling down a bit and found one line says error). it says
C:InetpubwwwrootAmFraserIntranetheader.master.vb(31,0): error BC30506: Handles clause requires a WithEvents variable defined in the containing type or one of its base types.
C:InetpubwwwrootAmFraserIntranetheader.master.vb(32,0): error BC30451: Name 'keyword' is not declared.
keyword is the textbox on the header page. I also played around with AutoEventWireUp (true/false) and defining onclick event on the server tag but it is still not solving the problem.
I have some duplication that I need to clean up. I wrote a SQL query that is supposed to return duplicate customers who are located in the same city and zipcode.
I have 2 questions regarding it:
1. Is the query syntax correct to find duplicate records by same city and zipcode, data is being returned but it just returns the same customer a few times?
2. I only need to do the GROUP BY clause for Fullname and City however it gives an error when the other columns are left out. The error is Address, State and Zip not being in the aggregate function or in the group by clause.
Adding all the remaining columns to the GROUP BY clause works.
Query is as below:
[code].....
I'm having troubles remembering how to grab the list view's state, or page, so that when you leave the list, you can return to the list view page you left on. I have a data pager, and I have hyplerlinks for items in the list view that take you to a file upload or file delete page, and then returns to the list view. It returns to the list view's initial state (first page).
View 1 RepliesI'm trying to create a validation layer that will contain methods to validate all my objects (in my Business Objects layer) .. but when I try to reference both the validation and business objects to each other I get a circular dependency error .. so I've decided to create a new layer (BLL) to validate the objects for me and I'll be able to reference both the validation and the object layers.
so I want to build some kind of class/interface -I don't know what fits more- to be like a generic type or a parent type that my method could accept it as a parameter and check for it's Name/ID property. Instead of defining a new method overload for each object type I have
Simplification
How would I create an instance of a type if all I have is the type in string form?
[Code]....
Now if I wanted to create and instance of myType how would I do that ?
I am struggling to find relevant documentation on this, what I basically want to do is to create a 'hyperlink' type and a 'pdf' type that I can put into my XML file and use to link to a webpage or a PDF, with the relevant icon.
Here is my JQuery :
[Code]....
And my XML :
[Code]....
I am executing a Stored procedure from Nhibernate.Below is the sample of my code.
public IList ReportDetails()
{
session.Flush();
ISQLQuery query1 = session.CreateSQLQuery("EXEC dbo.Reports");
System.Collections.IList list = query1.List();
return list;
}
This returns me an Ilist. I want ot convert this to List of Type List<Reports>.Reports class contains all the properties which i will get from Stored Procedure.
I am looking for a way to groupby a listbox. I get some of my listitems from the database with this linq query:
[Code]....
But i tried to make it here groupby but cant seem to get it work. It must groupby for : product.Vendor
Here is the listbox code:
[Code]....
If anyone know the answer for this i would be very happy. Also here is screenshot for what i want to do:
The "Wrong" part is what i get now, but i want it like the "Good" part.
After a few hours of searching I couldn't find a solution to this issue so I figured I'd try a post. I have stored procedure that queries 3 tables and retuns 1 set of results. When I execute the sproc using the following code db.GET_TRAININGS(userID).GroupBy(s=>s.COURSE_TITLE); I get back an IGrouping container where the course title is the key and contains 2 GET_TRAINING_RESULT elements. Then I bind using rptCourses.DataSource=trainings; then databind(),etc.What I'm trying to do is have the parent repeater show the course titles and the nested repeater show the modules for that course for the particular logged in user. Basically trying to turn a flat piece of data into heirchical data.The stored procedure returns the following SQL Columns Course_Title, Module_Path, Module_Name,Sequence. The sproc code is below:
[Code]....
The repeaters look like this of course:
[Code]....
I have a requirement in my application that, while saving the application, need to get all the value from drop down list and pass it to the view model. But application should not allow the user to select more than one item from drop down list manually, ie, only one value at a time. My view model is like ...
public class ListManagement
{
public IEnumerable<selectListItem> InactiveProduct { get; set; }
public string[] InactiveProductSelected { get; set; }
public IEnumerable<selectListItem> ActiveProduct { get; set; }
}
[code]...
I am using a strongly-typed view to display a list of products, where every li-element gets a unique id:
<ul id="product-list">
<% foreach (var item in Model.Products)
{ %>
<li <%= "id="product_" + item.Id + """ %> >
<div class="item">
<%= item.Name %>
</div>
</li>
<% } %>
</ul>
Now I want to attach to the click-event of every single li-element, so that if the user clicks on a div-element, detailed product-informationen should be loaded asynchronously into a details-pane. I know how I can use jQuery to invoke an action-method ajax-style and also how to display the json-result which contains the product-details, BUT I have no idea, how I could attach the onclick-event to every single div, so that I can use the productId to load the details.