The Namespace "Data" cannot be found.

Add-in Express™ Support Service
That's what is more important than anything else

The Namespace "Data" cannot be found.
 
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi,

I am trying to reproduce the following addin from scratch:
Importing data from SQL databases and other sources to Microsoft Excel
https://www.add-in-express.com/creating-addins-blog/2013/10/30/excel-importing-data-sql-databases/


The ExcelData.AddinModule.cs has the following "using" among others:

using Microsoft.Data.ConnectionUI;
No problem with this!

-----

But when I create a Test addin in a similar way, I get this error:
"The type or namespace "Data" does not exist in the namespace Microsoft.Are you missing an assembly Reference?"

In fact, when I type "using Microsoft.",
IntelliSense displays "Data" in your sample, but in my Test addin, it does not display "Data".


{ } CSharp
red ...... problem with Data... this appears with your sample, but not in my test addin
{ } Office
{ } Runtime
{ } SqlServer
{ } Vbe
{ } VisualBasic
{ } Win32

What has gone wrong?

Thanks
Leon
Posted 09 Jan, 2019 06:28:44 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hello Leon,

That add-in project references DLLs located in folder called 'lib'. Make sure your project references these DLLs.


Andrei Smolin
Add-in Express Team Leader
Posted 09 Jan, 2019 07:06:02 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei
Where is this "lib" folder hidden?

leon
Posted 09 Jan, 2019 07:13:51 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Find a link to the ZIP file right below the title Available Downloads on that page.


Andrei Smolin
Add-in Express Team Leader
Posted 09 Jan, 2019 07:16:25 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

I found the lib folder.

But there are many things that are puzzling me:

------------------------------------------------------------
If these DLL are provided by you, and not available freely from Microsoft, it can only mean that these DLL were written by ADX?

Am I right?

Since I am developing in VB .NET and not C#, maybe I cannot develop my addin if I use your dll?

-------------------------------------------------------------
Suppose someone did not come across your DLL. Then he would not be able to develop an add-in requiring a DLL connection?

He will have to write his own connection program?

------------------------------------------------------------
Your blog is quite old (2013). If the DLL were written by you, I presume it is also quite old.
What will happen if one day Microsoft modifies its programs, and your DLL stops working?
------------------------------------------------------------

Thanks
Leon
Posted 09 Jan, 2019 07:56:35 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Leon,

Indeed, to my surprise, the files are not created by Microsoft. You would need to write your code producing that functionality.


Andrei Smolin
Add-in Express Team Leader
Posted 09 Jan, 2019 10:56:34 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Wow!

Thanks

It's 20:00 in Mauritius, and very hot these days.

Leon
Posted 09 Jan, 2019 11:03:17 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
-5..-15 C :)


Andrei Smolin
Add-in Express Team Leader
Posted 10 Jan, 2019 05:34:01 Top