Click here to Skip to main content
16,003,382 members
Home / Discussions / C#
   

C#

 
GeneralRe: Could not evaluate expression Pin
MichCl6-Feb-13 7:41
MichCl6-Feb-13 7:41 
GeneralRe: Could not evaluate expression Pin
MichCl6-Feb-13 8:03
MichCl6-Feb-13 8:03 
GeneralRe: Could not evaluate expression Pin
Gerry Schmitz6-Feb-13 18:51
mveGerry Schmitz6-Feb-13 18:51 
GeneralRe: Could not evaluate expression Pin
MichCl7-Feb-13 2:24
MichCl7-Feb-13 2:24 
GeneralRe: Could not evaluate expression Pin
MichCl7-Feb-13 2:40
MichCl7-Feb-13 2:40 
QuestionA C# code to start a webcam Pin
Stanee Wa Faith5-Feb-13 22:59
Stanee Wa Faith5-Feb-13 22:59 
AnswerRe: A C# code to start a webcam Pin
Wayne Gaylard5-Feb-13 23:17
professionalWayne Gaylard5-Feb-13 23:17 
AnswerRe: A C# code to start a webcam Pin
GuyThiebaut6-Feb-13 2:03
professionalGuyThiebaut6-Feb-13 2:03 
QuestionDynamic Width Height Winform Pin
ASPnoob5-Feb-13 10:16
ASPnoob5-Feb-13 10:16 
AnswerRe: Dynamic Width Height Winform Pin
Dave Kreskowiak5-Feb-13 14:04
mveDave Kreskowiak5-Feb-13 14:04 
AnswerRe: Dynamic Width Height Winform Pin
Mycroft Holmes5-Feb-13 22:17
professionalMycroft Holmes5-Feb-13 22:17 
QuestionMake Design Appear as it Would in a Browser Pin
ASPnoob5-Feb-13 5:24
ASPnoob5-Feb-13 5:24 
AnswerRe: Make Design Appear as it Would in a Browser Pin
Keith Barrow5-Feb-13 5:57
professionalKeith Barrow5-Feb-13 5:57 
GeneralRe: Make Design Appear as it Would in a Browser Pin
ASPnoob5-Feb-13 6:22
ASPnoob5-Feb-13 6:22 
QuestionMySql is not listed in data source part! Pin
sina rafati nia4-Feb-13 22:28
sina rafati nia4-Feb-13 22:28 
AnswerRe: MySql is not listed in data source part! Pin
Eddy Vluggen5-Feb-13 0:47
professionalEddy Vluggen5-Feb-13 0:47 
GeneralRe: MySql is not listed in data source part! Pin
sina rafati nia5-Feb-13 22:49
sina rafati nia5-Feb-13 22:49 
GeneralRe: MySql is not listed in data source part! Pin
Dave Kreskowiak6-Feb-13 1:48
mveDave Kreskowiak6-Feb-13 1:48 
AnswerRe: MySql is not listed in data source part! Pin
sina rafati nia6-Feb-13 19:14
sina rafati nia6-Feb-13 19:14 
QuestionPropagating a MySQL Database Transaction Rollback through WCF using MSMQ Pin
Ger Hayden4-Feb-13 21:44
Ger Hayden4-Feb-13 21:44 
AnswerRe: Propagating a MySQL Database Transaction Rollback through WCF using MSMQ Pin
Pete O'Hanlon4-Feb-13 22:18
mvePete O'Hanlon4-Feb-13 22:18 
GeneralRe: Propagating a MySQL Database Transaction Rollback through WCF using MSMQ Pin
Ger Hayden4-Feb-13 22:47
Ger Hayden4-Feb-13 22:47 
QuestionTo get the info for how to validate an embedded object in office files Pin
Learning_to_code4-Feb-13 19:54
Learning_to_code4-Feb-13 19:54 
QuestionC# linq to sql error Pin
dcof4-Feb-13 12:32
dcof4-Feb-13 12:32 
In a C# 2008 desktop application, I have the following statement that give when an error when the code points to a different database:
 eRPTDataContext rptDataaddRVW = new eRPTDataContext();
 var eRPTaddRVW = (from a in rptDataaddRVW.eRPT_Transaction_Trackings
                   where a.Package_ID == packageId
                   select a).FirstOrDefault();

Here is the error message I get:
2013-02-04 16:13:15.3731|ERROR|erptsampleclient.eRPTSample|Error Processing --> Specified cast is not valid.
2013-02-04 16:13:15.3731|ERROR|erptsampleclient.eRPTSample|************* Stack Trace *******************
2013-02-04 16:13:15.3887|ERROR|erptsampleclient.eRPTSample|   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)
   at erptsampleclient.eRPTSample.addNewReviewPackage() in C:\_svn\Cas_client\erptsampleclient\eRPTSample.cs:line 1308
2013-02-04 16:13:15.3887|ERROR|erptsampleclient.eRPTSample|Error Processing --> Specified cast is not valid.
2013-02-04 16:13:15.3887|ERROR|erptsampleclient.eRPTSample|************* Stack Trace *******************
2013-02-04 16:13:15.4043|ERROR|erptsampleclient.eRPTSample|   at erptsampleclient.eRPTSample.addNewReviewPackage() in C:\_svn\Cas_client\erptsampleclient\eRPTSample.cs:line 1369
   at erptsampleclient.eRPTSample.Main(String[] args) in C:\_svn\Cas_client\erptsampleclient\eRPTSample.cs:line 154
2013-02-04 16:13:23.3135|INFO|erptsampleclient.eRPTSample|******************ADD (CREATE) REVIEW (RVW) (METHOD 2 CALL)**********************
2013-02-04 16:13:28.8359|INFO|erptsample.ERPTProxy|The number of attachments in the list are ->1
2013-02-04 16:13:54.2171|INFO|erptsample.ERPTProxy|add review package successfully for rvw pkg id: RVW0204201300524 return code = 0
2013-02-04 16:13:58.5227|INFO|erptsampleclient.eRPTSample|Review Package was created successfully for Package id: RVW0204201300524
2013-02-04 16:13:58.5695|ERROR|erptsampleclient.eRPTSample|Error Processing --> Specified cast is not valid.
2013-02-04 16:13:58.5695|ERROR|erptsampleclient.eRPTSample|************* Stack Trace *******************
2013-02-04 16:13:58.5851|ERROR|erptsampleclient.eRPTSample|   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)

When I change the code to the following:
var eRPTaddRVW = (from a in rptDataaddRVW.eRPT_Transaction_Trackings
                   where a.Package_ID == packageId
                   select new { erptPackageID = a.Package_ID, erptFileLocation = a.File_Location }).FirstOrDefault();
M

I do not get an error.
The problem is I want to be able to update the database row I just accessed and the linq will not compile clean to let me do that.

I am getting the follwowing error message when I try to access a specific field:
Error 10 'object' does not contain a definition for 'erptFileLocation' and no extension method 'erptFileLocation' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?) C:\_svn\Cas_client\erptsampleclient\eRPTSample.cs 1320 56 ERPTsampleclient
Here is the code I am trying to add:
    if (eRPTaddRVW != null)
       {
         eRPTaddRVW.erptFileLocation = RVWFile; // save location of original spreadshgeet
         rptDataaddRVW.SubmitChanges();
} 

Can you tell me what I can do to solve my problem?
AnswerRe: C# linq to sql error Pin
Simon_Whale4-Feb-13 12:59
Simon_Whale4-Feb-13 12:59 

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.