Click here to Skip to main content
15,896,444 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionMVC and Dataset Pin
future383925-Oct-10 14:08
future383925-Oct-10 14:08 
AnswerRe: MVC and Dataset Pin
kadaoui el mehdi27-Oct-10 3:33
kadaoui el mehdi27-Oct-10 3:33 
QuestionWebpage template Pin
yakshasa25-Oct-10 11:56
yakshasa25-Oct-10 11:56 
QuestionLinq to SQL Pin
Satish_S25-Oct-10 2:39
Satish_S25-Oct-10 2:39 
AnswerRe: Linq to SQL Pin
dan!sh 25-Oct-10 11:03
professional dan!sh 25-Oct-10 11:03 
GeneralRe: Linq to SQL Pin
Satish_S25-Oct-10 18:04
Satish_S25-Oct-10 18:04 
GeneralRe: Linq to SQL Pin
dan!sh 25-Oct-10 19:51
professional dan!sh 25-Oct-10 19:51 
GeneralRe: Linq to SQL Pin
Satish_S25-Oct-10 20:41
Satish_S25-Oct-10 20:41 
Thanks again for your reply ..

finally i got a solution and i have done it as below.


using (apReportDataContext context = new apReportDataContext())           
{                
var appointments = (                            
from app in context.t_msts                            
join li in  context.Lead_In on app.apm_LeadID equals li.iLeadID into app_li 
from li in app_li.DefaultIfEmpty()                            
join cs in context.custContactInfos on li.iLeadID equals cs.id into li_cs                    
from cs in li_cs.DefaultIfEmpty()                            
join apm in context.atm_appointment_type_masts on app.apm_type_id equals apm.atm_id into cs_apm  
from apm in cs_apm.DefaultIfEmpty()                            
select new
{    
app.apm_id,                              
app.apm_name,                              
app.apm_desc,                             
app.apm_start_time,                              
cs.CustomerName,                              
apm.atm_type_name
}
); 


if (dropdown.SelectedIndex != 0) appointments=
                  apps.Where(ap => ap.apm_ID.Equals(dropdown.SelectedValue));

grv.DataSource = appointments.Distinct();
grv.DataBind();
QuestionQuestions about ASPNETDB.MDF Pin
ibmkahm24-Oct-10 22:14
ibmkahm24-Oct-10 22:14 
AnswerRe: Questions about ASPNETDB.MDF Pin
kadaoui el mehdi27-Oct-10 3:41
kadaoui el mehdi27-Oct-10 3:41 
QuestionCan't figure out how to covnert this XML to XSL for a gridview Pin
Albert8324-Oct-10 19:01
Albert8324-Oct-10 19:01 
QuestionObjectDisposedException when using Response.Filter Pin
95ulisse24-Oct-10 5:06
95ulisse24-Oct-10 5:06 
QuestionWeb Service Complex Type returning Pin
Dirso23-Oct-10 13:06
Dirso23-Oct-10 13:06 
AnswerRe: Web Service Complex Type returning [modified] Pin
Karthik. A23-Oct-10 15:37
Karthik. A23-Oct-10 15:37 
GeneralRe: Web Service Complex Type returning Pin
Dirso26-Oct-10 9:16
Dirso26-Oct-10 9:16 
AnswerRe: Web Service Complex Type returning Pin
Keith Barrow23-Oct-10 21:56
professionalKeith Barrow23-Oct-10 21:56 
GeneralRe: Web Service Complex Type returning Pin
Dirso26-Oct-10 9:17
Dirso26-Oct-10 9:17 
Questionweb service Pin
Any_India23-Oct-10 7:48
Any_India23-Oct-10 7:48 
AnswerRe: web service Pin
Keith Barrow23-Oct-10 8:02
professionalKeith Barrow23-Oct-10 8:02 
GeneralRe: web service Pin
Any_India23-Oct-10 8:23
Any_India23-Oct-10 8:23 
GeneralRe: web service Pin
Keith Barrow23-Oct-10 8:34
professionalKeith Barrow23-Oct-10 8:34 
Questionmulti language website Pin
Jassim Rahma23-Oct-10 3:34
Jassim Rahma23-Oct-10 3:34 
AnswerRe: multi language website PinPopular
Pete O'Hanlon23-Oct-10 4:36
mvePete O'Hanlon23-Oct-10 4:36 
AnswerRe: multi language website Pin
Keith Barrow23-Oct-10 6:36
professionalKeith Barrow23-Oct-10 6:36 
QuestionTab Order Pin
Dushan12323-Oct-10 3:29
Dushan12323-Oct-10 3:29 

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.