Murugan.com
Murugan Andezuthu Dharmaratnam

  |  HOME   |  BLOG   |  TWITTER   |  ARTICLES   |  8086  |  C++   |  VC++   |  ASP .NET   |  VB .NET   |  JAVA SCRIPT   |  MS SQL   |  MY   |  VIDEOS   |  DOWNLOADS   |  CONTACT ME   |  



ASP .NET VB .NET Code connect to sql server using sql authentication sql connection string

Home   ASP.NET   ASP .NET VB .NET Code connect to sql server using sql authentication sql connection string         


sample code sql server authentication mode. how to connect to server using vb .net .

Public mUserId As String
Public sUserId As String = "sa"
Public sPassWord As String = "sa123"
Public sDatabase As String = "CampusIndya"
Public sServer As String = "MURUGAN\SQLEXPRESS"

Public Sub GetConnection()
If MyConnection.State = ConnectionState.Closed Then
MyConnection.ConnectionString = "User ID=" & sUserId & ";Password=" & sPassWord & ";database=" & sDatabase & " ;server=" & sServer
End If
End Sub






  |  HOME   |  BLOG   |  TWITTER   |  ARTICLES   |  8086  |  C++   |  VC++   |  ASP .NET   |  VB .NET   |  JAVA SCRIPT   |  MS SQL   |  MY   |  VIDEOS   |  DOWNLOADS   |  CONTACT ME   |  

Copyright 2009 @ Murugan Andezuthu Dharmaratnam