SQL Server 2005 Joins in VB.NET

Sign in to leave a comment.

• HP

  Hemlata Pant15y agoPosted Jan 20, 2011, 5:27 AM

  what l b the source code (vb.net)of project on office automation system or bank automation where tables(created in sql server2005) are related to one another and changes in 1 table affects other.....
• HP

  Hemlata Pant15y agoPosted Jan 20, 2011, 5:23 AM

  thanxxxxx sirrrr.....this article z really helping
• KS

  Krishna Sharma17y agoPosted Nov 5, 2009, 12:49 AM

  Dear Raj, Kindly guide me how to connect vb.net with sql 2005? Regards, Krishna
  • 

    Raj Kumar17y agoPosted Nov 6, 2009, 12:21 AM

    <connectionStrings> <add name="ConnectionString" connectionString="Data Source=RAJ-PC\SQLSERVER2005;UID=sa;pwd=wintellect;Initial Catalog=NORTHWND;" providerName="System.Data.SqlClient"/> </connectionStrings> Imports System.Data.SqlClient Imports System.Data Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString) Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) If Not IsPostBack Then Try If (con.State <> ConnectionState.Open) Then con.Open() MessageLabel.Text = "Database connection opened successfully" End If Catch ex As Exception MessageLabel.Text = ex.Message End Try End If End Sub
• NN

  nos nos17y agoPosted Jul 5, 2009, 5:44 AM

  Exellant