SqlDataTable.Open Exceptoin

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Microsoft SQL Server
Post Reply
tharollas
Posts: 2
Joined: Wed 15 May 2013 10:49

SqlDataTable.Open Exceptoin

Post by tharollas » Wed 15 May 2013 11:05

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:

tharollas
Posts: 2
Joined: Wed 15 May 2013 10:49

Re: SqlDataTable.Open Exceptoin

Post by tharollas » Wed 15 May 2013 12:37

Resolved.

Connection was pointing to the wrong database that did not have changes.

Regards

Post Reply