Retrieve data from Navision 3.70 C-Side with .NET

Comments

• Options

  Henry@columbus Member Posts: 24

  2004-04-09

  Hello Johan,
  
  C/ODBC does not support .NET datasets. If you want to use a data set, you’ll have to create your own.
  
  Example:
  

  [WebMethod]
  public ClientData[] GetClientData()
  	{
  	OdbcConnection myConnection = new OdbcConnection("dsn=navision;UID=xxx;PWD=xxx;");
  	OdbcCommand myCommand = new OdbcCommand("SELECT No_, Name, City FROM Contact",myConnection);
  	myConnection.Open();
  	OdbcDataReader myReader = myCommand.ExecuteReader();
  	ClientData [] Clients = null;
  	int i = 0;
  	Clients = new ClientData[600];
  	while (myReader.Read()) 
  	{
  		Clients[i].ID = myReader.GetString(0);
  		Clients[i].Name = myReader.GetString(1);
  		Clients[i].City = myReader.GetString(2);
  		i++;
  	}
  	myConnection.Close();
  	return Clients;
  	}
  

  Or create a structure.

  public struct ClientData
  		{
  			public String ID;
  			public String Name;
  			public String City;
  		}
  
  [WebMethod]
  public ClientData[] GetClientData()
  {
  	OdbcConnection myConnection = new OdbcConnection("dsn=navision;UID=xxx;PWD=xxx;");
  	OdbcCommand myCommand = new OdbcCommand("SELECT No_, Name, City FROM Contact",myConnection);
  	myConnection.Open();
  	OdbcDataReader myReader = myCommand.ExecuteReader();
  	ClientData [] Clients = null;
  	int i = 0;
  	Clients = new ClientData[600];
  	while (myReader.Read()) 
  		{
  		Clients[i].ID = myReader.GetString(0);
  		Clients[i].Name = myReader.GetString(1);
  		Clients[i].City = myReader.GetString(2);
  		i++;
  		}
  	myConnection.Close();
  	return Clients;
  	}
  

  A better solution is to run the Navision native database on a SQL server. But than you’ll have to keep in mind that the data should only be read. If you’ll write in a Navision SQL database with ODBC, the Navision data will get corrupt.

  [WebMethod]
  public DataSet DataSetTest()
  {
  	mySelectQuery = "SELECT No_, Name FROM  [CRONUS Nederland BV$Contact]"
  	string connectionString = "dsn=navisionSQL;UID=xx;PWD=xx;";
  	OdbcConnection conn= new OdbcConnection(connectionString);
  	conn.Open();
  	OdbcDataAdapter da = new OdbcDataAdapter (mySelectQuery, conn); 
  	DataSet ds = new DataSet();     
  	da.Fill(ds, "Customer");
  	conn.Close();
  	return ds;
  	}
  

  I hope it helps…
  If you’ll find anything else, please let me know.
  
  Henry

  0
• Options

  Johan_van_Bragt Member Posts: 7

  2004-04-09

  Thanks, that was the solution. Now it works

  0
• Options

  oberlach Member Posts: 5

  2005-05-10

  Does c/front support .NET datasets?

  0
• Options

  Henry@columbus Member Posts: 24

  2005-05-10

  Hello Oberlach,
  
  I haven’t tried it yet, but I don’t think so.

  0
• Options

  maurits Member Posts: 1

  2010-07-22

  Just for everyone's information, I've had the same problem trying to populate a DataSet using the Fill method of the OdbcDataAdapter object. It turns out that it does work when you try to populate a DataTable instead of a DataSet. Took me a while to figure out so I thought I'd share, even though this thread dates back to the analog modem age.
  
  Rgds/M
  
  EDIT: damn, I just noticed that that was exactly what the original poster was trying to do, but it failed for him. OK, never mind, I'll shut up now...

  0