Click here to Skip to main content
15,888,454 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Exiting application stopped by validation? Pin
TMattC21-Jan-15 21:01
TMattC21-Jan-15 21:01 
GeneralRe: Exiting application stopped by validation? Pin
CHill6021-Jan-15 23:20
mveCHill6021-Jan-15 23:20 
QuestionHow to download the documentation of .NET Framework class libraries Pin
LiTtLe ProGrAMmErS15-Jan-15 7:41
LiTtLe ProGrAMmErS15-Jan-15 7:41 
AnswerRe: How to download the documentation of .NET Framework class libraries Pin
Richard MacCutchan15-Jan-15 8:57
mveRichard MacCutchan15-Jan-15 8:57 
AnswerRe: How to download the documentation of .NET Framework class libraries Pin
Dave Kreskowiak15-Jan-15 10:22
mveDave Kreskowiak15-Jan-15 10:22 
AnswerRe: How to download the documentation of .NET Framework class libraries Pin
deepankarbhatnagar20-Jan-15 20:44
professionaldeepankarbhatnagar20-Jan-15 20:44 
GeneralRe: How to download the documentation of .NET Framework class libraries Pin
Dave Kreskowiak21-Jan-15 2:35
mveDave Kreskowiak21-Jan-15 2:35 
QuestionGet Data From a view in database sql server Pin
eso0o13-Jan-15 23:45
eso0o13-Jan-15 23:45 
hi guys,,,
i want to retrieve data from view that include multiple tables & relations i used sql statment but it show exception telling that (Invalid column name 'DateFile'. )
here's my code :
C#
 public static DataTable GetFlightsByDate(DateTime datefile)
        {
            DataTable GetFlights=new DataTable();
            string query = "SELECT TOP (20) Pax_No, Chd_no,"+                        
				            "Hotel_Id, DateFile, DEST, DEST_D, TypeTransfer, ARR_FLT, AT_Arr, DEP_FLT"+
"FROM  V_Report_Rooming_List_Trsf where DateFile=@DateFile";
            SqlConnection con = new SqlConnection(conn);
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.Parameters.Add(new SqlParameter("@DateFile",datefile));
            SqlDataAdapter sdr = new SqlDataAdapter(cmd);
            sdr.Fill(GetFlights);
            return GetFlights;
        }


V_Report_Rooming_List_Trsf is a view in my database & the exception it shows

Invalid column name 'DateFile'.

Invalid column name 'Pax_No'.

Invalid column name 'Chd_no'.

i was working with mvc first & i thought it was mvc problem so i used asp.net but the i face the same problem

plzzz give me a solution my company wants me to finish this task very soon

modified 16-Jan-15 14:00pm.

SuggestionRe: Get Data From a view in database sql server Pin
Richard MacCutchan14-Jan-15 1:30
mveRichard MacCutchan14-Jan-15 1:30 
AnswerRe: Get Data From a view in database sql server Pin
ZurdoDev15-Jan-15 9:04
professionalZurdoDev15-Jan-15 9:04 
GeneralRe: Get Data From a view in database sql server Pin
eso0o25-Jan-15 21:25
eso0o25-Jan-15 21:25 
GeneralRe: Get Data From a view in database sql server Pin
ZurdoDev26-Jan-15 1:23
professionalZurdoDev26-Jan-15 1:23 
QuestionVisual studio 2010 VB Setup Project - Uninstalls wrong program Pin
QuickBooksDev10-Jan-15 7:25
QuickBooksDev10-Jan-15 7:25 
AnswerRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
Richard Andrew x6411-Jan-15 11:09
professionalRichard Andrew x6411-Jan-15 11:09 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
QuickBooksDev12-Jan-15 0:43
QuickBooksDev12-Jan-15 0:43 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
Dave Kreskowiak12-Jan-15 4:38
mveDave Kreskowiak12-Jan-15 4:38 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
QuickBooksDev13-Jan-15 4:46
QuickBooksDev13-Jan-15 4:46 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
Richard Deeming13-Jan-15 5:28
mveRichard Deeming13-Jan-15 5:28 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
QuickBooksDev13-Jan-15 5:38
QuickBooksDev13-Jan-15 5:38 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
Dave Kreskowiak13-Jan-15 17:27
mveDave Kreskowiak13-Jan-15 17:27 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
QuickBooksDev14-Jan-15 0:25
QuickBooksDev14-Jan-15 0:25 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
Dave Kreskowiak14-Jan-15 2:02
mveDave Kreskowiak14-Jan-15 2:02 
AnswerRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
Richard Andrew x6414-Jan-15 7:31
professionalRichard Andrew x6414-Jan-15 7:31 
GeneralRe: Visual studio 2010 VB Setup Project - Uninstalls wrong program Pin
QuickBooksDev15-Jan-15 0:55
QuickBooksDev15-Jan-15 0:55 
QuestionAero Peek Like Control in .Net Pin
Django_Untaken6-Jan-15 0:24
Django_Untaken6-Jan-15 0:24 

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.