Hi,

I am migrating a code from ADO to ADO.NET. Here i am stuck with the SHAPE statement in sql query that is used in ADO. Please help me out with the equivalent code for ADO.NET



sql= " ((SHAPE { " + sql1+ " } AS SECONDARY APPEND ";
sql= sql+ " ({ " + sql2+ " } AS PROCEDURALSOURCE RELATE 'STASKID' TO 'TASKID') AS PROCEDURALSOURCE, ";
sql= sql+ " ({ " + sql3+ " } AS TASKAREA RELATE 'STASKID' TO 'TASKID') AS TASKAREA, ";
sql= sql+ " ({ " + sql4+ " } AS REPEATS RELATE 'STASKID' TO 'STASKID') AS REPEATS, ";
sql= sql+ " ({ " + sql5+ " } AS SECONDARYUOM RELATE 'STASKID' TO 'TASKID') AS SECONDARYUOM)";
sql= sql+ " AS SECONDARY RELATE 'TASKID' TO 'TASKID') AS SECONDARY";

where sql1, sql2, sql3, sql4, sql5 are complex select statements. It gives an invalid sql statement error in oracle db when i execute this.

It would be great if some one helps me out with equivalent code in ado.net using datasets or some other thing. Thanks.