Click here to Skip to main content
15,884,099 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: The steps of hosting a website? Pin
Jitendra Parida - Jeetu15-Dec-11 21:12
Jitendra Parida - Jeetu15-Dec-11 21:12 
AnswerRe: The steps of hosting a website Pin
Nitish Arora - Web Developer(Learner)15-Dec-11 8:26
Nitish Arora - Web Developer(Learner)15-Dec-11 8:26 
Questioncreate keep me logged in Pin
Jitendra Parida - Jeetu14-Dec-11 23:54
Jitendra Parida - Jeetu14-Dec-11 23:54 
AnswerRe: create keep me logged in Pin
R. Giskard Reventlov15-Dec-11 21:34
R. Giskard Reventlov15-Dec-11 21:34 
GeneralRe: create keep me logged in Pin
Jitendra Parida - Jeetu16-Dec-11 1:45
Jitendra Parida - Jeetu16-Dec-11 1:45 
AnswerRe: create keep me logged in Pin
thatraja16-Dec-11 2:12
professionalthatraja16-Dec-11 2:12 
Questionevent not firing from user control Pin
V.14-Dec-11 23:06
professionalV.14-Dec-11 23:06 
QuestionCannot retrive a single record from Anonymous Type Pin
awedaonline14-Dec-11 21:22
awedaonline14-Dec-11 21:22 
I am getting error when I tried retriving a single row from my LINQ query. This is my code:


VB
Dim query = From mm In dataContext.Mail_Message
                        Group Join mmr In dataContext.Mail_MessageRecipient On mm.MailMessageId Equals mmr.MailMessageId Into mmrm = Group From mrm In mmrm.DefaultIfEmpty
                        Group Join u In dataContext.Application_User On mm.SenderId Equals u.UserId Into us = Group From ums In us.DefaultIfEmpty
                        Group Join sr In dataContext.Personnel_StaffRecord On ums.StaffRecordId Equals sr.StaffRecordId Into srm = Group From smrm In srm.DefaultIfEmpty
                        Group Join ma In dataContext.Mail_MessageAttachment On mm.MailMessageId Equals ma.MailMessageId Into mam = Group From mamm In mam.DefaultIfEmpty
                        Where mm.MailMessageId = messageId
                        Select mrm.MailMessageRecipientId, smrm.Surname, smrm.Firstname, smrm.Othername, mm.Date, mm.Subject, mm.MailContent

            If query IsNot Nothing Then
                Dim row = query(1)
                With result
                    .MailMessageId = row.MailMessageRecipientId
                    .Sender = CStr(IIf(row.Surname Is Nothing, "BISM Limited", String.Format("{0} {1} {2}", row.Surname, row.Firstname, row.Othername)))
                    .Subject = row.Subject
                    .Body = row.MailContent
                    .Dates = row.Date
                    .RecipientNames = GetMailRecipients(messageId)
                    .Attachments = GetMailAttachments(messageId)
                End With
                ReadMessage(row.MailMessageRecipientId)
            End If



This is the error I get:

LINQ to Entities does not recognize the method 'VB$AnonymousType_48`7[System.Int64,System.String,System.String,System.String,System.DateTime,System.String,System.String] ElementAtOrDefault[VB$AnonymousType_48`7](System.Linq.IQueryable`1[VB$AnonymousType_48`7[System.Int64,System.String,System.String,System.String,System.DateTime,System.String,System.String]], Int32)' method, and this method cannot be translated into a store expression.

What am I getting wrong here?

QuestionMVC3: How to get the text box value as parameter? Pin
Tesic Goran14-Dec-11 18:42
professionalTesic Goran14-Dec-11 18:42 
QuestionMembership & Role Pin
sk_ko14-Dec-11 17:06
sk_ko14-Dec-11 17:06 
QuestionHow to achieve this in GridView? Pin
bot66614-Dec-11 16:57
bot66614-Dec-11 16:57 
AnswerRe: How to achieve this in GridView? Pin
Ramkumar_S14-Dec-11 18:54
Ramkumar_S14-Dec-11 18:54 
GeneralRe: How to achieve this in GridView? Pin
bot66614-Dec-11 19:47
bot66614-Dec-11 19:47 
AnswerRe: How to achieve this in GridView? Pin
www.Developerof.NET19-Dec-11 3:18
www.Developerof.NET19-Dec-11 3:18 
QuestionProblem to access Generic handler in asp.net 4.0 Pin
cocoonwls14-Dec-11 16:26
cocoonwls14-Dec-11 16:26 
AnswerRe: Problem to access Generic handler in asp.net 4.0 Pin
cocoonwls14-Dec-11 21:00
cocoonwls14-Dec-11 21:00 
GeneralRe: Problem to access Generic handler in asp.net 4.0 Pin
Not Active15-Dec-11 0:28
mentorNot Active15-Dec-11 0:28 
GeneralRe: Problem to access Generic handler in asp.net 4.0 Pin
cocoonwls18-Dec-11 14:00
cocoonwls18-Dec-11 14:00 
Questionhow to get the dynamically created radiobutton checked values Pin
MalarGayu14-Dec-11 12:33
MalarGayu14-Dec-11 12:33 
AnswerRe: how to get the dynamically created radiobutton checked values Pin
Nitish Arora - Web Developer(Learner)15-Dec-11 8:33
Nitish Arora - Web Developer(Learner)15-Dec-11 8:33 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
MalarGayu15-Dec-11 9:21
MalarGayu15-Dec-11 9:21 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
MalarGayu15-Dec-11 15:01
MalarGayu15-Dec-11 15:01 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
MalarGayu15-Dec-11 17:35
MalarGayu15-Dec-11 17:35 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
Ibrahim Hebish11-Jan-12 0:59
Ibrahim Hebish11-Jan-12 0:59 
Questionhow to pass selected value to subreport(crystal report) Pin
Ramkumar_S14-Dec-11 0:18
Ramkumar_S14-Dec-11 0:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.