Hi,

If you use a SHAPE / APPEND  syntaxes  in your SQL command, then you should remove :

  DS.Tables.Add("Student") 

 DS.Tables.Add("Qualification")

  DS.Tables.Add("Relation")

 

I didn`t use Add() method in my snippet code (take a look on the previous response) Could you please upload your sample, I`ll be glad to research it for you.

Let me know if you have any questions.

Hi

 

I am not getting data in my datagrid view.

 

Here is my code

        FieldsString = "SHAPE {SELECT [id] , [National_Id] from student }  APPEND ( {  SELECT [SETA], [OFO_Code] ,[ProgramName] FROM Qualification } RELATE ID TO ID) as relation "

 Dim DS As DataSet = New DataSet

        adp.Fill(DS)

        DS.Tables.Add("Student")

        DS.Tables.Add("Qualification")

        DS.Tables.Add("Relation") ---> Where do you get the name ???

        Grid_Select_Student_For_Edit.DataSource = DS

No, You could use your connection string.  I just copy this code from one of my samples. The connection string is not related with our scenario and task.

 

Let me know if you have any questions.

Ok, but the following is my connection string: Data Source=192.168.8.15;Initial Catalog=StuentPlacement20131;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False Should I now change my connection string for my entire project?

OK. In this case you should build your SQLCommand using SHAP. For example:

string sqlcommand = "SHAPE { SELECT ID, sText FROM dbItems  WHERE ID =10}   APPEND ({SELECT ID, sDescription FROM dbRows }  RELATE ID TO ID) as Relation";

DataSet ds = new DataSet();

 

System.Data.OleDb.OleDbConnection nwindConn = new System.Data.OleDb.OleDbConnection("Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=IGBGSOFDS22;Integrated Security=SSPI;Initial Catalog=Test");

System.Data.OleDb.OleDbDataAdapter adap = new System.Data.OleDb.OleDbDataAdapter(sqlcommand, nwindConn);

adap.Fill(ds); 

ds.Tables[1].TableName = "BBB";

ds.Tables[0].TableName = "AAA";

ds.Relations[0].RelationName = "HHH";

ultraGrid1.DataSource = ds;

 

Let me know if you have any further questions.