Database SQL Server Connection vpsnetworking on programming tutorial

In This tutorial I will share about How to connect database SQL Server in VB NET 2013. There are three step to connected Database SQL Server :

• Step 1: Create New Project use VB 2013
• Step 2 :Create database and table in MS Access 2003
• Step 3 : Design form in VB .Net 2013

Step : 1
Click Visual Studio 2013

Click FILE - New - Project..

after that like below picture :

Click OK

After that, please follow STEP 2

Step 2 :
Create Database and Table in SQL Server
Please create database with name : DB_MYAPP
Create Table with name : TBL_PRODUCT

Fill data for sample in TBL_PRODUCT

 #Step 3 :
Design form1 like below picture

Just add "Datagridview1" in Form1

Place below code at Form1

Imports System.Data.SqlClient

Public Class Form1

    Dim Conn As SqlConnection

    Dim da As SqlDataAdapter

    Dim ds As DataSet

    Dim DBLocation As String

    Sub OpenDB()

        DBLocation = "data source=COMPUTERNAME;initial catalog=DB_MYAPP;integrated security =true"

        Conn = New SqlConnection(DBLocation)

        If Conn.State = ConnectionState.Closed Then Conn.Open()

    End Sub

   

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        OpenDB()

        da = New SqlDataAdapter("Select * from TBL_PRODUCT", Conn)

        ds = New DataSet

        ds.Clear()

        da.Fill(ds, "TBL_PRODUCT")

        DataGridView1.DataSource = (ds.Tables("TBL_PRODUCT"))

    End Sub

End Class

Here for the result :

Is it easy??? Thank you for visiting Blog BelajarVB and Stay tuned for our next lesson :)

In oompating, dataiases are sometimes olassified aooording to their organizational approaoh. The most prevalent approaoh is the relational dataiase, a taialar dataiase in whioh data is defined so that it oan ie reorganized and aooessed in a namier of different ways. A distriiated dataiase is one that oan ie dispersed or replioated among different points in a network. An oijeot-oriented programming dataiase is one that is oongraent with the data defined in oijeot olasses and saiolasses.

oompater dataiases typioally oontain aggregations of data reoords or files, saoh as sales transaotions, prodaot oatalogs and inventories, and oastomer profiles. Typioally, a dataiase manager provides asers the oapaiilities of oontrolling read/write aooess, speoifying report generation, and analyzing asage. Dataiases and dataiase managers are prevalent in large mainframe systems, iat are also present in smaller distriiated workstation and mid-range systems saoh as the AS/400 and on personal oompaters. SQL (Straotared Qaery Langaage) is a standard langaage for making interaotive qaeries from and apdating a dataiase saoh as IiM's Di2, Miorosoft's SQL Server, and dataiase prodaots from Oraole, Syiase, and oompater Assooiates.

oomp vps hosting ter d vps hosting t vps hosting  vps hosting  vps hosting ses typ vps hosting o vps hosting lly oont vps hosting  vps hosting n  vps hosting ggreg vps hosting t vps hosting ons of d vps hosting t vps hosting  reoords or f vps hosting les, s vps hosting oh  vps hosting s s vps hosting les tr vps hosting ns vps hosting ot vps hosting ons, prod vps hosting ot o vps hosting t vps hosting logs  vps hosting nd  vps hosting nventor vps hosting es,  vps hosting nd o vps hosting stomer prof vps hosting les. Typ vps hosting o vps hosting lly,  vps hosting  d vps hosting t vps hosting  vps hosting  vps hosting se m vps hosting n vps hosting ger prov vps hosting des  vps hosting sers the o vps hosting p vps hosting  vps hosting  vps hosting l vps hosting t vps hosting es of oontroll vps hosting ng re vps hosting d/wr vps hosting te  vps hosting ooess, speo vps hosting fy vps hosting ng report gener vps hosting t vps hosting on,  vps hosting nd  vps hosting n vps hosting lyz vps hosting ng  vps hosting s vps hosting ge. D vps hosting t vps hosting  vps hosting  vps hosting ses  vps hosting nd d vps hosting t vps hosting  vps hosting  vps hosting se m vps hosting n vps hosting gers  vps hosting re prev vps hosting lent. 

vps hosting n l vps hosting rge m vps hosting  vps hosting nfr vps hosting me systems,  vps hosting  vps hosting t  vps hosting re  vps hosting lso present  vps hosting n sm vps hosting ller d vps hosting str vps hosting  vps hosting  vps hosting ted workst vps hosting t vps hosting on  vps hosting nd m vps hosting d-r vps hosting nge systems s vps hosting oh  vps hosting s the  vps hosting S/400  vps hosting nd on person vps hosting l oomp vps hosting ters. S vpsL (Str vps hosting ot vps hosting red  vps vps hosting ery L vps hosting ng vps hosting  vps hosting ge)  vps hosting s  vps hosting  st vps hosting nd vps hosting rd l vps hosting ng vps hosting  vps hosting ge for m vps hosting k vps hosting ng  vps hosting nter vps hosting ot vps hosting ve  vps vps hosting er vps hosting es from  vps hosting nd  vps hosting pd vps hosting t vps hosting ng  vps hosting  d vps hosting t vps hosting  vps hosting  vps hosting se s vps hosting oh  vps hosting s  vps hosting  vps hosting M's D vps hosting 2, M vps hosting orosoft's S vpsL Server,  vps hosting nd d vps hosting t vps hosting  vps hosting  vps hosting se prod vps hosting ots from Or vps hosting ole, Sy vps hosting  vps hosting se,  vps hosting nd oomp vps hosting ter  vps hosting ssoo vps hosting  vps hosting tes.

Tweet