In view im trying to do following code:
[Code]....
Trought controller I am trying to send:
[Code]....
Is this Possible? I cannot send it trought model becouse I am sending a list of Products which have a Type field. I don't know how to show in the List view Instead of Type id a Type name instead
I am using LINQ and sending a linq object to the view and trying to show it in a textbox like this
<%=Html.TextBox("petname",Model.PetName) %>
But I am getting error, how can I show (PetRecord.PetName) which is my linq entity
I currently have this as my controller:
public ActionResult Index()
{
MembershipUser currentUser = Membership.GetUser();
Guid UserId = (Guid)currentUser.ProviderUserKey;
using (var db = new MatchGamingEntities())
{............
Currently my table "BankTransactions" could have multiple records in there with the same Account Id, so when I run this querry I get a more than one bank transaction related to a given accountid. I want to be able to print this into a view, but I am not sure how my var MyAccount is returning given that there are multiple BankTransactions. How would I transfer this model into the view and be able to iterate through all the bank transactions associated with an AccountId
i have a new question: i read all the tutorials that i found but i cannot understand how to pass a result of a linq to entities result to the view so that i can display the results. My query is actually in the controller function ot the view, i would now loop the results and display them in the page. How?
View 23 RepliesI'm trying to find an easy way to view the query that has been generated as part of the LINQ to DataSet syntax in my application. I found Scott Gu's blog and his creation of the Linq to SQL Debug Visualizer but it doesn't appear to work for my application. I am using OracleClient if that is important.
My next step is to simply configure the Oracle Manager for the database to see the query but I can't believe there's not an easy way to view this generated query.
I have this code in my controller:
public ActionResult Index()
{
MembershipUser currentUser = Membership.GetUser();
Guid UserId = (Guid)currentUser.ProviderUserKey;
using (var db = new MatchGamingEntities())
{
var MyAccount = from m in db.Accounts..........
I want to be able to do a join query between my two tables Accounts and BankTransactions. This is a one to many relationship, there can be multiple BankTransactions per Account. I want to query this and display the account information including all the bank statements that are associated with it. I did a join in order to get it, but I am having trouble handling the model. I keep getting this error:
LINQ to Entities does not recognize the method 'System.Collections.Generic.List1[MatchGaming.Models.BankTransaction] ToList[BankTransaction](System.Collections.Generic.IEnumerable1[MatchGaming.Models.BankTransaction])' method, and this method cannot be translated into a store expression.
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.
I have used the example below in another functioning form. The first form is working fine; however in the second form (using the same code), it indicates that "Name "UsersEmail" is not declared. I been working at this for the last 4 days.
'!!! UPDATE THIS VALUE TO YOUR EMAIL ADDRESS
Const ToAddress As String = "Glenn_Ertel@OnslowCountyNC.gov"
'(1) Create the MailMessage instance
Dim mm As New MailMessage(UsersEmail.Text, ToAddress)
'(2) Assign the MailMessage's properties
Dim CCAddress = UsersEmail.Text
mm.Subject = "REQUEST FORM FOR BID - BidNumber = " + BidNumber.Text + ""
mm.Body += "Bid Number: " + BidNumber.Text
've created a Search partial view and it works, except for my view model. What i mean is, the partial view sends a string to my ActionResult Method, but only a string, that is not related to the view model that the partial view is built in. If i tell my ActionResult method to receive the view model in which the partial view is built in, it always tells me that i have null values. Here's my code This is my partial view:
[Code]....
Now here is my Model in my MoviesSearch view model:
[Code]....
Now the actual MoviesSearchViewModel
[Code]....
Inside my Search controller i have this
[Code]....
And then i have this:
I have a thread running in the background that will sleep and pull data from the database when something wakes it up. I am sending the emails using google apps using SmtpClient (code below).
I wanted to know if there is anything i be aware of? I plan to send only one email at a time (a registration or forgot password email). I am a little worried something can happen like an invalid email locking up the thread because i didnt set a timeout or maybe google apps happen to be done and causing the app to blow up. What should i be aware off? I should ask how i should test as well?
[code]....
I have created a page for filling information, when anyone fills out the form, the information gets e-mailed to all the recipient's e-mail addresses that are mentioned in the code of the page.
I have written the code which is working fine but when i fill out the information in the form, the information is sent to all the 3 e-mail addresses i mentioned in the code, but all 3 recipients of this information can see other recipient's name and address in the "TO " field of their mailbox.
Is it possible to hide other recipients and only show the e-mail address which will be specific to that recipient ?
Here's my code:
[Code]....
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.
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]...
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 RepliesI 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?
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.
I am creating a web site in .Net 3.5 , I am converting the string into Base64String to send it through querystring.The Response.Redirect works fine for smaller string. But if the original string size is 1670,the response.redirect results in error "Page can not be found".item is the string in below code snippet.
byte[] data = Encoding.Default.GetBytes(item);
return Convert.ToBase64String(data)
I have a web app for our golf club. When I compute handicap index for each golfer, I have to select the most recent scores and then a subset of those scores depending on how many rounds of golf the golfer has played. All the scores are entered into a single SQL Express table called "Rounds". Verbally, this is what I'm trying to do:
1) select the twenty most recent golf scores (sort on date descending, "take(20)") [if less than 20 records, then select all available];
2) for this set of records, select the 10 lowest scores (or smaller number if golfer has less than 20 rounds);
3) compute the average round differential for the subset of records, etc. to calculate handicap index (this step is working ok...)
My current VB code has this LINQ query (which is flawed -- it selects the lowest handicap differential scores of ALL records for the filtered user):
[Code]....
How do I modify this query to accomplish items 1) & 2) above? It seems this should be simple, but my experience with queries is still limited.
I have a view that has to render information from 3-4 tables. I therefore chose to create a viewModel for this. I am using EF as DAL.The information to be displayed is SiteId, SiteName, SiteDetails from one table.Associated to Site, other table Event_type has information about Events in the system with fileds like EventId, EventName, Event ScopeId.EventScope is another table with ScopeID and ScopeDesc Also, there is Site_Event_Implemnetation table that stores all the events associated to a site. It has SiteId, EventId, EventUnitIdEventUnit is another table that stores all the unit types.Now my Details ViewModel has to display the info SiteName, SiteDetails. And associated to that a grid of events with info on EventName, Scope Desc, Unit Desc1. How do I formulate my query to retrieve this info in my repository layer using Linq to EF?
View 13 RepliesHi to All,
I would like to ask for advice how can i load the data and the columns from MSSQL View to my app by View name.
Let say i have one methode/class that gets the view name and returns back the data (List<Object>).
And in the xml mapping i can set the relation between the object and the columns in the view.
Any advice will be appriciated.
Thank you
Ori
First I will say I googled (Binged to make Bill happy) for this but could not find anything, perhaps I am not stating what I need correctly;
I have a website that a customer creates orders (for a printing company) and after the order, I would like to email the customer a link to view the status of their order;
I need to send the CustomerID in the link so on the returning page if a CustomerID is detected in the querystring, I "auto login" the client and open the "Dashboard" for the order page for that customer.
Can anyone point me in the right direction as to how to send the link and how to parse the querystring to get the values from the link.
I am attempting to implement a custom locale service in an MVC 2 webpage. I have an interface IResourceDictionary that provides a couple of methods for accessing resources by culture. This is because I want to avoid the static classes of .Net resources.The problem is accessing the chosen IResourceDictionary from the views. I have contemplated using the ViewDataDictionary given, creating a base controller from which all my controllers inherits that adds my IResourceDictionary to the ViewData before each action executes.
(ViewData["Resources"] as IResourceDictionary).GetEntry(params);
mvc-ers in the Model i have a collection of Employees (EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
MOBILE)
and i want to send particular fields from it to the view so in the Controller i write this code
[Code]....
how can i retrieve the collection in the view, should i create a class contains (e.EMPLOYEE_ID, Employee_Name)
and cast ViewData["Employees"] to it, or there is a trick?
if i have database contain table:
1-student
2-accounts
and i make tthe page for login , if the student is record login successfully, how can make page to display information for this student who is logged on the rest of the data without viewing the other students who are in the database. Note:I used the session in the login page .
I need to load the database values into the grid view by checking the attribute "id".
If the id value which I entered is equal to database, then it'll load in the grid view.