MVC :: How To Get Access To The Fields In Table B In The View
Feb 9, 2011
I do not know if this can be done but lets say have a model like the one below:
I am trying to do this:
<%= Html.RadioButtonFor(model => model.B.height)%> -----> Does not work. Height is not a property
But B is a collection. How do I get access to the fields in table B in the View?
***********************************************************
Table A
Qid
name
age
Table B
Wid
Qid
gender
height
View 14 Replies
Similar Messages:
May 8, 2010
Working in Access, I need to create a view which takes values from two different records in another table and puts them on one row in the view. I'm having a hard time doing this since both row items come from the same field in the original table (actually in this case, using views instead of tables).
I have two queries I try to join together, but come up with the wrong results:
vwComp1:
SELECT q.CompStatus, q.EQID, c.CompsID, q.LastName, q.FirstNameFROM _EQ AS q, Comps AS cWHERE q.CompStatus=1 AND c.CompsID=q.CompID
vwComp2:
SELECT q.CompStatus, q.EQID, c.CompsID, q.LastName, q.FirstName
FROM _EQAS q, CompsAS c
WHERE q.CompStatus=2 AND c.CompsID=q.CompID
vwAssignment:
SELECT vwComp1.*, vwComp2.*
FROM vwComp1, vwComp2
This does fine in the vwComp2 part of vwAssignment, in the sense that it displays the correct name information, etc.; but for vwComp1, it just takes the name and other fields from the first row of vwComp1 and repeats it on every row of vwAssignment. This is really strange because vwComp1 and vwComp2, when displayed individually, each correctly puts the names in each row; something like this:
Bob White Rhonda Red
Bob White Freda Freschetta
Bob White Linda Lime
Bob White Jean Green
--when it should read something like this:
Bob White Rhonda Red
Fred Redd Freda Freschetta
Jim Brown Linda Lime
Rob Black Jean Green
View 1 Replies
Mar 1, 2010
i have project using sql2005 as database. i want to convert the 1 View (or some of my table) to Access that admin can download it.
what is the easiest way to do that?
View 4 Replies
Mar 30, 2010
I have a strongly typed view for Contacts table In my index page , i am accessing the tables as --- "foreach (var item in Model)"
This table has an association with Groups Table
How can i access Groups table data from view.
intellisense gives me possibility to write like "item.Groups.GroupTitle"
But it returns null(object not initiated) How to solve this?
View 3 Replies
Sep 7, 2010
Here's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
View 5 Replies
Apr 14, 2010
If I am going to use the asp.net membership and roles, the asp.net database includes an aspnet_Users table that has the userid and email address. If I have custom fields is it best practice to maintain a separate usert table and link on user id or to add fields to the aspnet_Users table?
View 1 Replies
Sep 23, 2010
Dim ds As New AccessDataSource
ds.DataFile = "c:InputTest.mdb"
ds.DataSourceMode = SqlDataSourceMode.DataSet [code]....
View 5 Replies
Dec 10, 2010
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replies
Mar 31, 2011
MVC generates the following code in my edit view for me but I don't want the user to see it, let alone try and change it. If I delete the code I get an error because a required value is missing. What is best practice when dealing with this?
<div
class="editor-label">
@Html.LabelFor(model => model.AthleteID)
</div>
<div
class="editor-field">
@Html.EditorFor(model => model.AthleteID)
@Html.ValidationMessageFor(model => model.AthleteID)
</div>
View 5 Replies
Aug 23, 2010
ASP.Net Html.TextBoxFor (and the other XxxxxFor editor helper methods) default to rendering a field prefix. How do I disable field prefixes so it simply renders the property name as the Name/ID?
Here's an example:
<%= Html.EditorFor(m => chart.Title) %>
is rendered as:
<input id="Chart_Title" name="Chart.Title" type="text" value="">
I would prefer it to be rendered as:
<input id="Title" name="Title" type="text" value="">
View 2 Replies
Nov 22, 2010
I have asp.net Forms View.
I have three textboxes to lookup three different product codes from a product lookup table.
When you enter search criteria in a Textbox it would popup listbox control with Products and
when user selects the product it populates product-id back in to textbox.
I have lookup table and listbox working. However, My problem is I can't figure out how to pupulate TextBox2 if search Criteria was typed into TextBox2and to populate TextBox 3 if the search criteria was typed into textbox 3 etc.
View 5 Replies
Aug 21, 2010
I want to Check Gr #(PK) of student wheter exist in table or not id exist show Msg in Label after lost focus from text box .. I tried AutoNumber in Access but it showing error while insertion
Note : im using form View control for insertion...
View 1 Replies
Jun 7, 2010
i am using the following code for a retrieving a image stored in access database
View 12 Replies
Sep 20, 2010
I currently have a submit page that captures data and submits to a SQL Table (see code). What I need to do is amend so that certain fields submit to a PDF file which the user can then view, download or print and for all the fields to populate the SQL table as normal.
[Code]....
[Code]....
View 1 Replies
Jun 7, 2010
I am tryin to get records where certain fields are empty, but the following sql does not give me correct result.
SELECT [specimen Type], [Year], [Lab Number]
From [PET Fish] where
ltrim(rtrim([Diagnosis])) = '' or
ltrim(rtrim([Results])) = '' or
ltrim(rtrim([Sign out Date])) = ''
It should return all records, but it returns none.
View 2 Replies
Mar 3, 2010
i want to know how to access the template fields in a detailsview....i am not able to access them by their ID's
View 5 Replies
Jul 8, 2010
How I can get the generated view code below to place the editor-field to the right of the editor-label, on the same row? I don't want to mess with the generated defaults, e.g. remove the divs, as I am still in very early dev and regenerate views quite often.
<div class="editor-label">
<%: Html.LabelFor(model => model.Suburb) %>
</div>
<div class="editor-field">
<%: Html.TextBoxFor(model => model.Suburb) %>
<%: Html.ValidationMessageFor(model => model.Suburb) %>
</div>
View 1 Replies
Jan 17, 2010
By picking MVC for developing our new site, I find myself in the midst of "best practices" being developed around me in apparent real time. Two weeks ago, NerdDinner was my guide but with the development of MVC 2, even it seems outdated. It's an thrilling experience and I feel privileged to be in close contact with intelligent programmers daily. Right now I've stumbled upon an issue I can't seem to get a straight answer on - from all the blogs anyway - and I'd like to get some insight from the community. It's about Editing (read: Edit action). The bulk of material out there, tutorials and blogs, deal with creating and view the model.
So while this question may not spell out a question, I hope to get some discussion going, contributing to my decision about the path of development I'm to take. My model represents a user with several fields like name, address and email. All the names, in fact, on field each for first name, last name and middle name. The Details view displays all these fields but you can change only one set of fields at a time, for instance, your names. The user expands a form while the other fields are still visible above and below. So the form that is posted back contains a subset of the fields representing the model. While this is appealing to us and our layout concerns, for various reasons, it is to be shunned by serious MVC-developers.
I've been reading about some patterns and best practices and it seems that this is not in key with the paradigm of viewmodel == view. Or have I got it wrong? Anyway, NerdDinner dictates using FormCollection och UpdateModel. All the null fields are happily ignored. Since then, the MVC-community has abandoned this approach to such a degree that a bug in MVC 2 was not discovered. UpdateModel does not work without a complete model in your formcollection. The view model pattern receiving most praise seems to be Dedicated view model that contains a custom view model entity and is the only one that my design issue could be made compatible with.
It entails a tedious amount of mapping, albeit lightened by the use of AutoMapper and the ideas of Jimmy Bogard, that may or may not be worthwhile. He also proposes a 1:1 relationship between view and view model. In keeping with these design paradigms, I am to create a view and associated view for each of my expanding sets of fields. The view models would each be nearly identical, differing only in the fields which are read-only, the views also containing much repeated markup. This seems absurd to me. In future I may want to be able to display two, more or all sets of fields open simultaneously.
View 5 Replies
Feb 10, 2011
How do I go about having a new razor editortemplate for a datepicker, preferabbly jqueryUi in MVC 3?
View 22 Replies
Feb 15, 2010
i just noticed that if my controller has a parameter with a name that matches the name of a field in my view model, and the view emits the value of the model's field, the value emitted is that passed in the query string, not the one set by the controller. is this by design?
here is what i mean:
my view model:
public class MyViewModel
{
int id;
string name; [code]....
sending a request to "create?id=1234" emits "1234" in the hidden field instead of "1".
View 5 Replies
Dec 31, 2010
I am trying to add new fields in membership table by using createuserwizrad control. is it possible to do that?
View 3 Replies
Nov 19, 2010
using vb.net 2005 and crystal reports I added a server and db to my crystal report and I can see the table and fields in the server explorer. Also in "database expert" I added the table that I want to display data from. The question I have now is how to I display fields from this table on my report? I thought I remembered simply dragging and dropping a field onto the report from the table but not able to do that now
View 1 Replies
Mar 24, 2011
i will write one quire in this i will update two dates some fields like first table two colums and second table three columns , how to wirte quire
View 1 Replies
Dec 5, 2010
If I am going to use the AdRotator with Database and set the properties from the table fields, how can I set the impression?
View 5 Replies
Nov 18, 2010
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
View 1 Replies