SQLNS in C#

[Guest]

Greetings!

I want to try to use SQLNS (SQL NameSpace - not Notification Services) since I am going to make a winform with a TreeView of an SQL server tree.

The samples from MS are in either VB och C++:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlns/ns_samp_2rhv.asp

So I'm asking has anyone done anything with using SQLNS from C#? Or can someone please see if they can make the samples work in C# I can't get it right.

Cheers,
/Magnus

 

[Mohamoss]

Hi Magnus
check out the sample on this link

http://www.codeproject.com/database/ShrinkingSQLServerTransLo.asp?df=100&for
umid=38739&exp=0&select=805016
hope it helps
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

 

[Guest]

Well it worked, thanks! But I'm not exactly sure how I did it yet! ;~)

Here's the code to, in C#, open the properties window for Northwind db
***************************
SQLNamespace oSQLNS = new SQLNamespace();
string s = "Server=localhost;UID=sa;PWD=<insert sa password here>;Trusted_Connection=Yes;Database=;";
object con = s;
oSQLNS.Initialize("Squelsh", SQLNS.SQLNSRootType.SQLNSRootType_Server, ref con, (Int32) 1);
Int32 i = 0;
i = oSQLNS.GetRootItem();
i = oSQLNS.GetFirstChildItem(i, SQLNS.SQLNSObjectType.SQLNSOBJECTTYPE_DATABASES, null);
i = oSQLNS.GetFirstChildItem(i, SQLNS.SQLNSObjectType.SQLNSOBJECTTYPE_DATABASE, "Northwind");
SQLNS.SQLNamespaceObject SQLnso = oSQLNS.GetSQLNamespaceObject(i);
SQLnso.ExecuteCommandByID(SQLNS.SQLNSCommandID.SQLNS_CmdID_PROPERTIES, (Int32) 0, SQLNS.SQLNSModality.SQLNamespace_PreferModal);
***************************

Cheers,
/Magnus - NoopMan ;~)

 

[Guest]

Well it worked, thanks! But I'm not exactly sure how I did it yet! ;~)

Here's the code to, in C#, open the properties window for Northwind db
***************************
SQLNamespace oSQLNS = new SQLNamespace();
string s = "Server=localhost;UID=sa;PWD=<insert sa password here>;Trusted_Connection=Yes;Database=;";
object con = s;
oSQLNS.Initialize("Squelsh", SQLNS.SQLNSRootType.SQLNSRootType_Server, ref con, (Int32) 1);
Int32 i = 0;
i = oSQLNS.GetRootItem();
i = oSQLNS.GetFirstChildItem(i, SQLNS.SQLNSObjectType.SQLNSOBJECTTYPE_DATABASES, null);
i = oSQLNS.GetFirstChildItem(i, SQLNS.SQLNSObjectType.SQLNSOBJECTTYPE_DATABASE, "Northwind");
SQLNS.SQLNamespaceObject SQLnso = oSQLNS.GetSQLNamespaceObject(i);
SQLnso.ExecuteCommandByID(SQLNS.SQLNSCommandID.SQLNS_CmdID_PROPERTIES, (Int32) 0, SQLNS.SQLNSModality.SQLNamespace_PreferModal);
***************************

Cheers,
/Magnus - NoopMan ;~)

 

[Guest]

Anyone feel like explaining the following:

1) The fourth parameter to SQLNamespace.Initialize?
2) Which premissions is it that give the sa right to access SQLNS.SQLNSRootType.SQLNSRootType_Server?
3) The second parameter to SQLNS.SQLNamespaceObject.ExecuteCommandByID?

Cheers,

 

[Guest]

Anyone feel like explaining the following:

1) The fourth parameter to SQLNamespace.Initialize?
2) Which premissions is it that give the sa right to access SQLNS.SQLNSRootType.SQLNSRootType_Server?
3) The second parameter to SQLNS.SQLNamespaceObject.ExecuteCommandByID?

Cheers,