Using MVC2 and Linq to SQL, I have a table of Topics related to a table of statements about that topic. You select a topic and click on a link to create another statement about that topic. The statement requires a topic id to maintain the relation.
How do you pass the id of the topic to the statement form that needs it?
If i create all of the foreign keys in my sql database and I create a linq to sql item in my project the linqs show on the diagram.
Does this mean that i dont need to create joins in my linq query in my c# code? so i mean my quesry would look something like this
[Code]....
instead of
[Code]....
I am using Entity Frameowrk as the ORM. I am new to MVC and trying to develop a samll module as a learning project.
Now I am stuck with an issue for which I can't seem to find out answer on web. The issue is :
I have two tables mapped as entities - Tenant_Definition and Contact
Tenant_Definition { Tenant_ID , Desc, Contact_ID}
Contact {Contact_ID, Company_Name,Company_Address,Person_Name, Person_Phone_Mobile}
My View has to present a form that shows Tenant Desc and Contact related fields. The index view works fine and shows the desired values.
But, the create view isn't working out. In the create view, i am planning to do -
1. creating a new contact entity instance and saving it in db
2. Then creating a new tenant entity instance using the new contact_id and save it to the DB.
However, the code doesn't seem to be inserting any value inside Contacts table. It inserts null value.Below is the code snippet of my Create Controller -
[HttpPost]
public ActionResult Create(FormCollection collection)
{
var newContact = new Contact();[code]....
1 - Is it necessary to have foreign key to obtain a Relation in Entity Framework between each entity.?
2 - I have a Language Table and many many table with a foreign key related to the language table. Is it right to add this foreign key or I should do something else ?
Ex:
Language
LangID
LangName
TableTextA
TblAID
TextInfo
LangID
TableTextB
TblBID
TextInfo
LangID
TableTextC
TblCID
TextInfo
LangID
etc ...
I have two tables - Advert and Student
adID is the primary key (Advert) and acts as the foreign key for Student
I have two pages, both of which each have a detailsview in insert mode
what I want to achieve is to create a new record in advert.aspx (e.g. adID = 4), then when item is inserted, redirect to page student.aspx (which a student record is created) where the foreign key is the ID from the advert just created (e.g. student.aspx?adID=4).
I need to get a certain web page, process the data a bit and do a db search or two.I hope my subjectline is clear enough. I load some data from an database with wep GUI. But there are character set problems with the data, and I have to fix those, before the data gets mangled by the IE. And I cant fix the source database or web page.
View 4 RepliesI just started at a new job as a asp.net developer. The place I am working, a small college, has several web pages made with old school html, vbscript, php, and asp (not asp.net). My boss wants their websites to have a menu system to navigate through the pages. I started a asp.net master page with a header, footer, and menu on the left. However, now, I am trying to get the school's websites to appear in the contentplaceholder. Is there someway to insert a pages content (example www.google.com) into the contentplaceholder? I was thinking of using a combination of frames and asp master pages but all I get are errors so far.
View 3 RepliesI'm trying to build a Create view in which some fields for the model have been set in the controller and are non-editable. Take for example a post in these forums where the subforum in which you post depends on which forum you're in currently.
I tried to do this by passing an id parameter to the Create action like this:
[Code]....
[Code]....
But somehow the subforum property gets "lost" along the way, but the submitted prop. stays there. I should note here that the subforum property is an entity key.
So in other words: how can I set a few properties before returning the view, and keep these read-only until postback??
(1) SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.CO FROM V_HIERARCHY1 a
(2) and Data is
HR HR Rec Records Leave Leave Records HRL.0001 Policy and Process for leave record. 27.06.2010 30.06.2010 WIP Edlink
HR HR Rec Records Leave Leave Records HRL.0002 Quarterly Review 01.07.2010 04.07.2010 Planned Edlink
HR HR DB Database SAL Salary DDS.0001 Calculation of Monthly salary 08.08.2010 09.08.2010 WIP Edlink
HR HR Rec Records Ind Induction Records HRI.0001 Completion of dossiers. 08.07.2010 10.07.2010 WIP Edlink
HR HR DB Database Emp Employee HDE.0001 Offer letter 06.07.2010 09.07.2010 WIP Edlink
IT Info Tech SW Software ERP.Web Web based ERP ISE.0001 Version 1 10.07.2010 12.07.2010 Overdue Edlink
I have something like this
[code]....
it works fine, but I need to create a user object by passing Guid like this
MembershipUser user = Membership.GetUser(new Guid(userId));
what may be the cause. it woks fine from C# code behind.
I want to pass create date in Membership CreateUser(..., ..., ...) method. As It's only providing no such method of passing custom create date of an user(s). Is there a way to pass it? I'm using .NET Framework 2.0. If there is no such way then have any idea my Microsoft is not providing this functionality for passing custom value(s) as store procedure is implemented all the table parameter(s).
View 1 RepliesI have a somewhat complex model that I need to pass to a MVC 2 Create view so its properties can be filled out. I'm not sure how to actually create this model as it has some relationship data that must also be filled out during the creation process.My main model is a Game. Most of its properties are scalar. It contains a foreign key to Content, for the game reviews, and there's a many-to-many relationship between Games and Platforms - games can be on a variety of platforms (PS3, XBox 360, etc.), and each platform has a library of games.When I pass data to my Edit view, it's as simple as:
[Code]....
I'm unsure what to do in the case of Create as I'm not sure how to link the associated parts - Content and Platforms - to a Game object.
I need to force SSL when going to the final checkout page (for example from default.aspx to checkout.aspx).
I need to pass variables to this check out page and tried to use server.transfer(https://www.mydomain.com/checkout.aspx). I then use previous page .Fincontrol to read text box and label name to this check out page. If I only do the server.transfer("~/checkout.aspx") then my I can read all vakues of my controls from the passing default.aspx page.
But when I force https:// then I cannot read the control values from default.aspx page.
Please give me some tips on how to get control values to the https:// destination page or if you have another tips on how to do it the right way, please let me know.
I have a FileUpload control in the Source page. On the Upload button handler, I read the file into memory (after doing some validations) and since it's always going to be a TXT file, I create a string that I need to pass to the Destination page. I thought of using Cross Page postback and set the PostBackUrl property of the upload button. But it appears that the breakpoint in the Upload button handler is never hit. It directly goes to the Page_Load in the Destination page. If I can't use Cross Page postback and don't want to use Session or the database, how do I pass this string from Source page to the Destination page?
View 2 RepliesI would like to take a value from a text box and pass it as a search parameter to my database. I get the value from my code behind page as follows: protected void btn_click(Object sender, ImageClickEventArgs e)
View 2 RepliesI need to access a variable that is declared in a master page to a child page. I'm using asp.net 2.0 (vb). I'm sure this should be easy and is down to my inexperience with asp.net! A rough guide to my code is below;
MASTER PAGE
<%@ Master Language="VB" CodeFile="MasterPage.master.vb" Inherits="MasterPage" %>
<script runat="server">
Public UserNumber As Integer = 3
End Sub
</script>
CHILD PAGE
<%@ Master Language="VB" CodeFile="MasterPage.master.vb" Inherits="MasterPage" %>
I'd like to pass data from one asp.net page to another. I've seen that using System.Web.Caching.Cache is a good way to accomplish this. I'm wondering if it's a good way to do it and also is there any cleanup or other things I need to keep in mind when you the Cache?
I'm not passing very much, at most two integers.
I am using query string to pass values from page 1(log in page) to page 2 and then page 3. I have an .ascx file also, so how can I import the user name from Page1(login.aspx) to menu.ascx file. So that when I click the menu Home the value of the variable remains at the website. I am not aware of session handling thats why I am using this method to pass the valus among the various pages in website.
View 4 Replieshave a question about passing a gridview to a second page. I'm filling the gridview in the first page and by clicking a button,it's directed to second page and I want to see this gridview on second page.Must I have to convert grid to datatable or is there any possible solution? I tried converting from grid to datatable
DataTable dt = new DataTable();
dt.Columns.Add("urunAdi");
for (int i = 0; i < grdSepet.Rows.Count; i++)
[code]...
I have a listbox containing a list of the datas In the child page. Now, if a user selects a multiple number of the items of the listbox, i have to pass all of them through the session.
So, i want to create an array in the child page and pass the values in the session and in the form of an array to the parent page.
In the parent page i'm displaying all the user details and one of the detail is the list of accessible clients in a list box. the clients can be removed or added using the add or remove images next to the list box.
Clicking on the Add image will show you the list of available clients in a new page(child) and also showing currently available clients to the user with checked status.
Let me explain how the available clients for the user is displayed in the child page. In the parent page load on the 'Add' image 'OnClientClick' i'm passing the ClientId of a hidden field in which all the selected clients for a user is stored.
The problem i'm facing here is when i altered the selected clients in the child page and clicking on the OK button will change the value of the listbox in parent page using the clientID of the listbox which i'm passing, but if i once again click the 'Add' button it shows the original values which is stored at the time of parent page load. The problem is i'm not doing any postback here so that the original values registered during 'OnClientClick'of 'Add' button is not altered.
I have built a blog that sees the index on the master page and the blog pages within in the ContentPlaceHolder of the master page. The Blog pages use SQLDatasource control with the QueryStringParameter to pull the selection from the address bar.
My question is there any other way to communicate between master and content page, rather than query string (with out using cookies, or sessions)?
I have a need to put a search field (text box) on the master page to search the contents of the blog pages, I would like to use the controlparameter of the sqldatasource on the blog page, but I have not idea how to do this ? What can be done to allow a textbox on master page and SQLDatasource talk to each other in this manner ?
is the query string passing my only option btw master and content?
When passing variable from one page to another
To avoid the user messing around with the URL parameter Values
Is it best to ...
1) pass the variable via session
2) pass the variable in the URL along with a signature
Looking for advice on passing variables from page to page without using QueryString. The web crawlers such as google get caught up on the querystrings found in a URL. I'm trying to get away from using it. Is there another suggested method for passing the variables? I've thought about using session variables, but this is just for simply passing the variable from page to page and they won't always be the same.
On another note, I can't do it using forms. I'm using a master page with a form embedded in the master page and also the content pages. Unless microsoft updated it so you can multiple forms on one page.
I have a web page that contains a GridView which the user is allowed to "Edit", "Delete" and "Select" rows. What I'm trying to accomplish is when a user clicks on "Edit", they are redirected to another web page that contains a DetailsView of the record they selected from the GridView (previous page). How do I make the association?
View 7 Replies