Problem with MSSQL and C# automation Addin

[kkzin]

Hi, there
I created C# automation excel add-in named "MyExcelAddin" like that link.
http://msdn.microsoft.com/en-us/libr...89(VS.80).aspx

"MyExcelAddin.MyClass1" contains one function:

public string GetName()
{     
return  "Employee";
}
 

I can use this function in excel like that.
In Selected Cell , =GetName(). It works well.

So, I try one thing like that
I created a DLL named "MyDBDLL" that connected directly with MSSQL database server.
"MyDBDLL.MyClass2" contains one function:

public string[] GetNames()
{
string[] srtArr;
//....my code are here...
// i assigned strArr names from MSSQL database
return strArr;
}
 

I also created XML file for "MYDBDLL" dll.
And in "MyExcelAddin.MyClass1" , I change my code like that

public string GetName()
{
MyDBDLL.MyClass2 CL2 = new MyDBDLL.MyClass2();
string[] st = CL2.GetNames();
return  st[0];
}
 

At that time, In excel , I cannot use like that .
In Seletced Cell, =GetName(). It gived no result.
But I test "MyExcelAddin" DLL in Console Application. It works well.
How can i solve this problem...? Please help me.
Thanks You Very Much.

[Curtis Rutland]

Welcome to Bytes!

We appreciate it if you wrap your code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. And if it's easier for us to read, it's easier for us to help.

You can type them in or use the # button on the text editor.

MODERATOR