I need to pull the data from DB and fill the view model, is there any better way to do this? Currently I'm doing something like this.
ViewModel vm = new ViewModel();
var recentBill = context.Money.Take(10);
foreach (var r in recnetBill)
{
vm.lst.Add(r);
}
is there a way to draw a goal line in a chart view w/o having to add a line chart series? i would like to be able to draw this goal line in bar charts as well, but i see that i cannot combine a line chart with a bar chart.
View 2 RepliesWhen adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined.I mean assuming I have a view like this
CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.
var foos = myDB.FilteredFoos.Include("Bar").ToList();
foreach (Foo foo in foos) { ...
I've been used to decorating data model classes with data annotation attributes, but the purist in me baulks slightly at including purely presentational attributes such as display format here. I am, however, quite happy to keep validation centric attributes here. One good reason I have to continue keeping all annotations etc. in the data model is that my view model aggregates data model classes, e.g.
my ViewModelBase.DetailItem<TEntity> property in the view model is just a reference to an entity class in my data model. If I wanted to move presentational annotations to the view model, I would have to quite radically revise my design to one where I duplicate data model properties in my view model and use an object mapping tool to populate view model objects based on data model objects.
[code]....
Which is the best platform to create a gadget that pulls data from a database.
View 8 RepliesI'm rather liking this MVC3 and Razor way of working and I'm learning the ropes. I was wondering, can I create a partial view and pull it into another view in the following scenario:I have a "Person" model and an "Address" model. The Person contains name, phone number etc and each person has an address. I've created my Person "Create" view and that works fine but I now want to pull in my "Address" partial view to it.
View 10 RepliesI have been reading about different model for development
model view control mvc
model view presenter MVP
Model view view model MVVM
i belive MVC has two big Advantage over webform 1) TDD 2) More control on HTML
MVP is bit variation in mvc model. rapid development as well as 1) TDD 2) More control on HTML (correct me if i m wrong) see the below link
[URL]
one thing that has been puzzling me since learning MVC2 is the following case scenario: I have a view which contains two latest news lists, a login form and a signup form. Every example I found on Views and View Models so far has a one-to-one example such as a simple login form etc. But how do I create a model that provides the properties and validation for a login and signup form and manages the data for the news lists. can I pass multiple models in the strongly typed view? When I created one model the form validation would fail as it expects all fields - login and signup to be filled. I am missing some advanced examples or information.
View 2 RepliesI have been banging my head against this problem for a bit and I think I am stuck. I would like to pull data from a Database to populate a list of possible "clients" to select from on one side. Then using what has been clicked load the client specific data into a tab container on the opposite side. I plan on doing lazy tab loading so I am not sure if that matters. I am really stuck and any help or guidance anyone could give would be greatly appreciated! I understand the basics of data loading and of tab containers, but i am unsure of what to do. I am coding this in C#. Example Mock Interface This is where the data list would be and I want to be able to select something here And update the Tab Panel control here based on the selection from the left side via querying the database.
View 3 RepliesI have a ASP.NET Web Forms application and I'm using some dynamic controls in the view which depend on stuff that the presenter exposes. Is it okay for the view in this case to pull on the presenter for that data? Is there anything I should be extra careful about when considering testability and a loosely coupled design.
The page in this case has it's own page-life cycle and the presenter doesn't know about this. However, the page-life cycle dictates that somethings must occur at specific moments in the page-life cycle. This smells like trouble... Any known pit falls?
EDIT
When my concrete view hits the Init event it will pull on the presenter for a collection that will result in a bunch of ASP.NET server controls to be created. I'm wondering if this is a particular bad thing to do... The presenter doesn't know how to respond to the page-life cycle init event but it has to if the view is to be populated with dynamic controls.
i am trying to fill agrid view with its data inside an accordion in asp.net but the data doesn't appear in the grid
View 1 RepliesI am using C# with Entity Framework Model. I want to fill a textbox (tbPrepProbComment.Text ) with a string (S0PrepProbSolveComment) from a table (EightDProject). I'm getting the key for the EightDProject from a textbox (SelectTrackingNumber). I'm not sure my query is working because when I look at the query result ( project ) I see the error" 'mykey' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are referenced correctly." If the query was working I dont know how to pull the field from the distinct row it should return and put it in the textbox. I've tried the line tbPrepProbComment.Text = project.S0PrepProbSolveComment; Here is my code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Objects;
namespace EightD1
{
public partial class Page1 : System.Web.UI.Page
{
public int mykey;
public string comment;
public object obj;
// the entity framework model
EightDdbEntities EightDP = new EightDdbEntities();
protected void Page_Load(object sender, EventArgs e)
{
SelectTrackingNumber.Focus();
}
//When the project id has been selected get projectdata and bind to page data holders
protected void SelectTrackingNumber_TextChanged(object sender, EventArgs e)
{
BindData();
}
private void BindData()
{
try
{
mykey = Convert.ToInt32(SelectTrackingNumber.Text.ToString());
}
catch
{
mykey = 0;
}
ObjectQuery<EightDProject> project = EightDP.CreateQuery<EightDProject>(
"SELECT DISTINCT p FROM EightDProjects AS p WHERE p.EightDID = mykey ");
//tbPrepProbComment.Text = project.S0PrepProbSolveComment;
}
}
}
see a lot about gridview in pop up but in my case i have a grid view in main page with a textbox in its templete and a button when ever button for every row clicked the pop up window open user enter a value and press a button in pop up i want the text user enter in textbox in pop up to place in text box in the row that user click the button
View 2 RepliesSay I got a domain model as follows: (and my repository expect an instance of this object)
[Code]....
And a view model (which my views are based on)
[Code]....
At the moment I got it like this and have my controller action manually create a new Person object from the PersonModel object before passing it on to the repository, which does not feel right.
So I tried to have PersonModel inherit from Person and pass that to the repository (also tried casting the PersonModel to a Person object first), but that don't work out.
What's the right way to have PersonModel automatically cast to Person? I want to keep this logic as my current structure allow me to keep things really loosely coupled, with the repository layer not having a clue how it's being used.
I want to populate data from database and display it to dropdownlist.
View 3 Replieshave been unable to find any explanation of this anywhere.I have an .ascx partial view that's pulling data from a given model.I want to populate a drop-down list in my partial view using data from a table
outside the model (it is in the same database and entity framework).I don't know the syntax (I'm pretty much just learning MVC2 and jquery), and don't even know where to start. I've gotten about as far as <% foreach step in [???] %>, but don't know what to do with it. What do I put in the "[???]"???
I have string taskID[texbox],string projectID[texbox],,string description[texbox],,int totalHrs[texbox],,int billableYN[CheckBox],int activeYN[CheckBox]
outside the grid view .
I have gridview with edit button with bound columns taskID,projectID,description,totalHrs,billableYN,activeYN.
I want when i click on edit button this taskID,projectID,description,totalHrs,billableYN,activeYN should populate outside the grid view on string taskID[texbox],string projectID[texbox],,string description[texbox],,int totalHrs[texbox],,int billableYN[CheckBox],int activeYN[CheckBox]
I want the user to click the link then the window pops up, but I want the data inside the window to be pulled from a database, and I need to repeat this process for 5 links that are also pulled out of a database. Say the most popular items for the month. My question is how would this be best accomplished? Jquery, or AJAX. I am just trying to see which would be the easier way to go about coding this with .net and C#.
View 1 RepliesI have 1 listbox named lbCountry
i have inserted each selected value from listbox into database by following code:
[code]....
now i dont know how to fetch data from database and fill listbox with multiple selected value.
I have menu list like this
and I want to fill it's Items from my SQL database, is that possible ?
Populating CheckBoxList from a column of a table.
View 1 Repliesi have 2 text box, on submit button i want to fill data in database.and another gridview to DBi made 1 table in db name ankpracti.i m using sqlserver2000 and visualstudio2005.want whole code and step by step solution.
View 4 RepliesHow Can I Pass data(not the part of model) to Controller from View? View Code
[Code]....
I'm fairly new to all this, but have slowly been teaching myself C# and ASP.net MVC over the past year or so...I really tried to search for this, but haven't been able to find anything - it may be I'm using the wrong terminology!I'm using ASP.NET MVC2 with EF4 connected to a SQL Express db. Situation: Without getting into too much specifics, I have one table called 'Plan.' Under 'Plan' are several different categories that are related to a single Plan item [say Category A, Category B, Category C and Category D]. Each 'Category X' table has a beginDate, endDate and other details specific to that category.
I'd like to be able to create a summary page that combines all items from Category A, Category B, Category C, and Category D and sorts by beginDate - but only need a few of the columns [eg - begin/end date, name, id].
I've seen/read plenty advocating "unobtrusive" JavaScript contained in separate files. I'm preparing to combine all my JavaScript from three partial views into a single file that I will then reference somewhere in my master.
My question is: is there any type of JavaScript that should remain behind in the html? One example that seems to me may present a problem would be something like:
<script type="text/javascript">
$(document).ready(function () {
$('#newQuoteLink').click(function () {[code]...
Am I correct in assuming this script would not work if loaded from a separate file?I mostly wanted to check if there were any caveats or other considerations prior to combining everything into this lone, separate file.