Archives

Create Database and Tables in SQL Server using VB.Net

Option Strict Off Option Explicit On Friend Class frmSQL Inherits System.Windows.Forms.Form #Region “Windows Form Designer generated code ” Public Sub New() MyBase.New() If m_vb6FormDefInstance Is Nothing Then If m_InitializingDefInstance Then m_vb6FormDefInstance = Me Else Try ‘For the start-up form, the first instance created is the default instance. If System.Reflection.Assembly.GetExecutingAssembly.EntryPoint.DeclaringType Is Me.GetType Then m_vb6FormDefInstance = Me […]

Rate this:

Read More

Create Fact Tables for Data Warehouse in VB.Net

Private Sub btnCreateFact_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreateFact.Click Try Dim tblerror As String tblerror = “” If (cbFTableName.SelectedIndex = -1) Then tblerror = “Please select a Table Name” End If If ((tblerror.Length > 0)) Then MessageBox.Show(tblerror + vbCrLf, “Information”, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If cmd.Connection = New System.Data.SqlClient.SqlConnection(ConnectionString) cmd.Connection.Open() sql […]

Rate this:

Read More