cs_snakeon
Messages postés59Date d'inscriptionmardi 29 janvier 2008StatutMembreDernière intervention 5 mars 2010
-
13 oct. 2009 à 00:11
cs_snakeon
Messages postés59Date d'inscriptionmardi 29 janvier 2008StatutMembreDernière intervention 5 mars 2010
-
29 oct. 2009 à 01:54
bonjour je travaille dans une application qui est reliée avec access
j ai un probleme au niveau d affichage des données dans datagridview et voila les etapes que j ai utilisé:
CLASS CONNECTION
Public Class Connection
Dim MaConnection As OleDbConnection = New OleDbConnection
Dim Adapter As OleDbDataAdapter = New OleDbDataAdapter
Dim ChaineConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=|DataDirectory|\CyberDB.mdb" & ";" & _
"Persist Security Info=False"
Public Function Select_DataTable(ByVal Cmd As OleDbCommand) As DataTable
Dim dt As New DataTable
Try
MaConnection.Close()
MaConnection.ConnectionString = ChaineConnection
MaConnection.Open()
If MaConnection.State = ConnectionState.Open Then
Cmd.Connection = MaConnection
Adapter.SelectCommand = Cmd
' dt = New DataTable
Adapter.Fill(dt)
Else
MsgBox("Connexion failed...")
End If
Catch ex As Exception
MsgBox(ex.Message & " Select_DataTable")
End Try
Return dt
End Function
Public Function Mise_A_Jour(ByVal Cmd As OleDbCommand) As Integer
Dim i As Integer
MaConnection.Close()
MaConnection.ConnectionString = ChaineConnection
MaConnection.Open()
Cmd.Connection = MaConnection
i = Cmd.ExecuteNonQuery()
Return i
End Function
End Class
DATACCESS:
Imports System.Data.OleDb
Public Class DataAccess
Dim Con As New Connection
Public Function Listdesplaystations() As DataTable
Dim cd As New OleDbCommand
Dim dt As New DataTable
Try
cd.CommandText = "select * from Playstation"
dt = Con.Select_DataTable(cd)
Catch ex As Exception
MsgBox(ex.Message & " Liste des playstation")
End Try
Return dt
End Function
End Class
et dans la class ou se trouve le datagrid j ai mis ce code:
Imports System.Windows.Forms
Public Class Playstation
Dim dacces As New DataAccess
Private Sub Playstation_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
PlaystationDataGridView.DataSource = dacces.Listdesplaystations
End Sub
End Class