World's Originating Website
Well Come To The World's Originating Websites Of Free Tricks
World's Originating Website

Gprs trick , Ring Tones , Games ,Apps And Many More


You are not connected. Please login or register

|:|~ VB.NET DataBase Connectivity ~|:|

Go down  Message [Page 1 of 1]

1default |:|~ VB.NET DataBase Connectivity ~|:| on Fri May 20, 2011 1:38 pm

Admin

avatar
Admin
affraid affraid Here U Got All Types of Connectivity of .Net affraid affraid

Types of Connectivity

  • OLEDB.Net
  • ODBC.Net
  • ODP.Net


Content Of Document :-

[*] Connection String
[*] Data Table
[*] Data Set
[*] Data Adapter
[*] Data Adapter>> Fill Method
[*] Command Builder

IMP Concept of DataBase Connectivity



Last edited by Admin on Mon May 23, 2011 2:36 pm; edited 3 times in total


_________________
http://dl4u.forumotion.net

Admin

avatar
Admin
Dim connetionString As String
Dim cnn As OleDbConnection
connetionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\TEST\DB.accdb;"
cnn = New OleDbConnection(connetionString)
Try
cnn.Open()
MsgBox("Connection Open ! ")
cnn.Close()
Catch
MsgBox("Can not open connection ! ")
End Try



Last edited by Admin on Mon May 23, 2011 2:38 pm; edited 1 time in total


_________________
http://dl4u.forumotion.net

Admin

avatar
Admin
Dim connetionString As String
Dim cnn As OdbcConnection


connetionString = "Dsn=AB"

cnn = New OdbcConnection(connetionString)
Try
cnn.Open()
MsgBox("Connection Open ! ")
cnn.Close()
Catch ex As Exception
MsgBox("Can not open connection !.... ")
End Try




Note :- Creating DSN

  • Open Control Panel
  • Administrative Tools
  • ODBC
  • Create DSN...


_________________
http://dl4u.forumotion.net

Sponsored content


Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum