hi,

i'm using SMO instance objects to create a table, but i got the error:

Error 1 'Table' is an ambiguous reference between 'System.Web.UI.WebControls.Table' and 'Microsoft.SqlServer.Management.Smo.Table' C:\smo\Default2.aspx.cs 24 9 C:\smo\

how can i resolve this ambiguity

thanks.

Use complete Namespace with the declaration of your table object.

for example;

//vb code

dim mytable as new Microsoft.SqlServer.Management.Smo.Table()

// c# code

Microsoft.SqlServer.Management.Smo.Table mytable=new Microsoft.SqlServer.Management.Smo.Table();

In case it don't help then please post your code.

you probably have code that starts like this:

Table table = new Table(); //..........etc

a simple way to help the compiler know which table you're actually working with (between the two) would be to fully qualify it:

Microsoft.SqlServer.Management.Smo.Table table = new Microsoft.SqlServer.Management.Smo.Table();

you can also form your own alias for the namespace, something like:

using MySMO = Microsoft.SqlServer.Management.Smo;

and then in code:

MySMO.Table table = new MySMO.Table();

some references: http://en.csharp-online.net/CSharp_FAQ:_How_use_an_alias_for_a_class_or_namespace

http://www.devx.com/tips/Tip/34419

* for VB.NET convert here: http://www.developerfusion.com/tools/convert/csharp-to-vb/