Hi,
I have below code that does select statement which works in Management Studio,
but when I try to call SqlDataTable.Open method I get an exception.
I'm using VS2012 Update 2, with dcsqlserver260pro build 719
//cmdSelectQAGenFims_Detail is SqlCommand
cmdSelectQAGenFims_Detail.CommandText = "select a.* from erms.vwqa_genfilm_eval a where ((a.chiefclassifier_personid in(" + _personID + ")) or (a.qa_evaluator_personid in(" + _personID + ")) or (a.classifier1_personid in(" + _personID + ")) or (a.classifier2_personid in(" + _personID + ")))";
tblQAAdultFilms_Detail.SelectCommand = cmdSelectQAGenFims_Detail;
tblQAGenFims_Detail.Open();//SqlDataTable
SQL PRODUCED Works in SQL Server Management Studio
select a.* from erms.vwqa_genfilm_eval a where ((a.chiefclassifier_personid in(1)) or (a.qa_evaluator_personid in(1)) or (a.classifier1_personid in(1)) or (a.classifier2_personid in(1)))
EXCETION is after tblQAGenFims_Detail.Open();
System.ArgumentNullException was caught
Message=Value cannot be null.
Parameter name: schemaTable
Source=Devart.Data
ParamName=schemaTable
StackTrace:
at Devart.Common.DbDataTable.CreateColumnsInternal(Boolean throwOnEmptySchemaTable)
at Devart.Data.SqlServer.SqlDataTable.CreateColumnsInternal(Boolean throwOnEmptySchemaTable)
at Devart.Common.DbDataTable.CheckColumnsCreated(Boolean throwOnEmptySchemaTable)
at Devart.Common.DbDataTable.Open()
at ERMS.frmERMMain.frmERMMain_Load(Object sender, EventArgs e) in c:\t\VS2012\Films\VS_Source\ERMS12.1\ERMS\frmERM.cs:line 482
InnerException:
SqlDataTable.Open Exceptoin
Re: SqlDataTable.Open Exceptoin
Resolved.
Connection was pointing to the wrong database that did not have changes.
Regards
Connection was pointing to the wrong database that did not have changes.
Regards