mirage041
جمعه 21 بهمن 1390, 12:32 عصر
من این کدها رو دارم :
Imports System.Data.OleDb
Public Class Database
Private Shared m_ConnectionString As String
Private Shared m_DBConnection As OleDbConnection
Private Shared Provider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source ="
Private Shared DataFile As String = Application.StartupPath + "\LibraryDB.accdb"
Public Shared Property ConnectionString() As String
Get
Return m_ConnectionString
End Get
Set(ByVal Value As String)
m_ConnectionString = Value
End Set
End Property
Public Shared Property DBConnection() As OleDbConnection
Get
Return m_DBConnection
End Get
Set(ByVal Value As OleDbConnection)
m_DBConnection = Value
End Set
End Property
'برنامه را به پایگاه داده وصل می کند
Public Shared Sub SetConnection()
Try
m_ConnectionString = Provider & DataFile
m_DBConnection = New OleDbConnection(m_ConnectionString)
Catch ex As Exception
MessageBox.Show("خطا در اتصال به پایگاه داده")
End Try
End Sub
End Class
می دونم که کار این کلاس اتصال به پایگاه داده است ولی کار این توابع رو نمی دونم :
Public Shared Property ConnectionString() As String
Get
Return m_ConnectionString
End Get
Set(ByVal Value As String)
m_ConnectionString = Value
End Set
End Property
Public Shared Property DBConnection() As OleDbConnection
Get
Return m_DBConnection
End Get
Set(ByVal Value As OleDbConnection)
m_DBConnection = Value
End Set
End Property
و همچنین این :
Public Shared Function ExecuteScaler(ByVal Query As String) As Object
Dim Cmd As New OleDbCommand(Query)
Cmd.Connection = Database.DBConnection
If Cmd.Connection.State <> ConnectionState.Open Then
Cmd.Connection.Open()
End If
Dim RetVal As Object = Cmd.ExecuteScalar()
Cmd.Connection.Close()
Return RetVal
End Function
Imports System.Data.OleDb
Public Class Database
Private Shared m_ConnectionString As String
Private Shared m_DBConnection As OleDbConnection
Private Shared Provider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source ="
Private Shared DataFile As String = Application.StartupPath + "\LibraryDB.accdb"
Public Shared Property ConnectionString() As String
Get
Return m_ConnectionString
End Get
Set(ByVal Value As String)
m_ConnectionString = Value
End Set
End Property
Public Shared Property DBConnection() As OleDbConnection
Get
Return m_DBConnection
End Get
Set(ByVal Value As OleDbConnection)
m_DBConnection = Value
End Set
End Property
'برنامه را به پایگاه داده وصل می کند
Public Shared Sub SetConnection()
Try
m_ConnectionString = Provider & DataFile
m_DBConnection = New OleDbConnection(m_ConnectionString)
Catch ex As Exception
MessageBox.Show("خطا در اتصال به پایگاه داده")
End Try
End Sub
End Class
می دونم که کار این کلاس اتصال به پایگاه داده است ولی کار این توابع رو نمی دونم :
Public Shared Property ConnectionString() As String
Get
Return m_ConnectionString
End Get
Set(ByVal Value As String)
m_ConnectionString = Value
End Set
End Property
Public Shared Property DBConnection() As OleDbConnection
Get
Return m_DBConnection
End Get
Set(ByVal Value As OleDbConnection)
m_DBConnection = Value
End Set
End Property
و همچنین این :
Public Shared Function ExecuteScaler(ByVal Query As String) As Object
Dim Cmd As New OleDbCommand(Query)
Cmd.Connection = Database.DBConnection
If Cmd.Connection.State <> ConnectionState.Open Then
Cmd.Connection.Open()
End If
Dim RetVal As Object = Cmd.ExecuteScalar()
Cmd.Connection.Close()
Return RetVal
End Function