there was a time that I need to use the SQL Management Objects.
Good thing about these collection is that we can manage our MS SQL Server with ease.


I recommend using SMO in huge backup projects or batch updates/inserts/delete's or maybe managing stored procedures, views, triggers et al against databases. Just thought that smo objects was used in SQL Compare and related products from red-gates. I used their products for a while. You can find more info here. 

I'll show you a good example that might help you get started.

First, you need to have the following assemblies:

    Microsoft.SqlServer.ConnectionInfo.dll
    Microsoft.SqlServer.Smo.dll
    Microsoft.SqlServer.SmoEnum.dll

probably, if you leave the default installation directory of your MS SQL Server 2005 standard edition installation then you can find the assemblies in this directory

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

These assemblies are available when installing Microsoft SQL Server 2005. If you don't have SQL Server 2005 standard edition installed, you can download the object collection from the "Feature Pack for Microsoft SQL Server 2005 - November 2005". Click here for details.

You only need to download the Microsoft SQL Server 2005 Management Objects Collection.
Scroll down to find the category. Hope Microsoft will not sue me for having this direct link to that:

XMO for x86

XMO for x64

Next, fire-up Visual Studio 2003/2005/2008 Pro/Express. Create new Project and select console application.

Download the project solutions below. Run the app.

Wooohoow!...

Finally, I've decided to serve web hosting services for those web developers who can't afford the $$$ expensive $$$ web hosting services out there. I'm offering a fixed rate (since that's what in e-commerce) for the hosting.

Basically, I want it to be flexible and more innovative than other existing web hosting providers here in bohol. Actually, I'm in the level 3 of the hosting layers. What I mean is that, I am renting the leased boxes from a hosting provider. So that means I am a reseller. :).

Anyway, to be exact, both Linux and Windows OS's are supported. Both have an extensive & competitive feature. Prices are in peso value so no worry with those “fluctuating” dollar rates every minute.

I thought of providing this to students for educational purposes. Still, there are many of my clients migrated into it.

Anyway, I’ve added a category for this named “Web Hosting” so I’ll keep you posted.

Cheers!

Yah, I forgot to post about the WDG Anniversary. WDG Members are from Holy Name University & STI Tagbilaran. Hope to see the other clusters from Manga Highschool.

We're having some fun. Most of us enjoyed the games.

Well, hope to see you guys in another big events comming up soon.

Well, the date is:  July 26, 2008. Hope I'm correct. :)

Regards, 

heh, I forgot to include the visual basic version. If I remember it right, I just told myself not to code vb anymore. But I can still code in both language so I decided to write some updates. :)

First, you need to change the connection string from the web.config file.

then run the application.

Still, I test the project twice in Debug mode. No release happened.

You can download the files below

mysql_datagrid_vb.rar (98.03 kb)

hmmm... smell somethings coming?.. yah, i'ts about my brother's wedding. I'm totally unprepared. Not to mention that I have to be a guide for the sponsor then 

throw some speech at the reception. 

Nah, just like to talk about it. Its wonderful to be a part of the wedding. I'll keep you posted about the speech.
Leave it to your grandma for now.

Cheers