This class provides a fast and universal method for accessing SQL Server database. Create Instance At first you create an instance of SqlDatabase class. Dim sqldb As New SqlDatabase("Data Source=(local); Initial Catalog= ; UId = ; Pwd = ;") For more information about connection strings, visit ConnectionStrings.com. ExecuteNonQuery Method Executes a Transact-SQL statement against...
Read more »

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful. You can report bugs, opinions and suggestions to me. <<DONWLOAD>> << dataAccess.vb >> Imports System Imports System.IO Imports System.Text Imports System.Data Imports System.Data.SqlClient Namespace SqlDataProvider ''' <summary>...
Read more »

WITH set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “M”)’ set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “F”)’ member Customer.AggMale as ‘Aggregate() member Customer.AggFemale as ‘Aggregate() SELECT {.} ON AXIS(0), {Customer.AggMale,Customer.AggFemale} ON AXIS(1) FROM
Read more »

WAP Connection Setting Silakan ikuti petunjuk berikut ini untuk melakukan pengaturan (setting) konfigurasi Koneksi & WAP di ponsel Smart kamu. NOKIA 2685 & 6275 1. Ketik *#2769737# 2. Pilih Gateway settings 3. Pilih Server address 4. Pada pilihan IP address 1 ketik 010.017.027.250:08080 kemudian klik OK 5. Pada pilihan IP address 2 ketik 010.017.027.250:09201...
Read more »

Recently, we’ve jumped into the world of multi-dimensional OLAP.  We’re currently using SQL Server Analysis Services which has been great to create the data cubes and Microsoft Sharepoint with Business Scorecard Manager to render the cubes.  The database and cube work wonderfully.  We have had issues with Scorecard Manager 2005 though (namingly, it doesn’t render well to...
Read more »

  http://technet.microsoft.com/en-us/evalcenter/cc442495.aspx?ITPID=wtcfeed
Read more »