Combo.Items.Add(myrecordset.Item("Intervenant")) Combo.Items.Add(myrecordset.Item("ID"))
Player le nom du tableau
playercode primary key
Name champ
Surname champ
Public Sub InsertPlayer(ByVal FamillyName As String, ByVal Surname As String) Dim strsql As String = String.Empty 'je supose que la connection a été établie Dim command As New OleDbCommand(strsql, Connection) command.CommandText = "INSERT INTO Player (Name,Surname) VALUES ([name?],[surname?]);" command.Parameters.Add("name?", OleDbType.BSTR).Value = FamillyName command.Parameters.Add("surname?", OleDbType.BSTR).Value = Surname command.ExecuteNonQuery() End Sub
Public Sub DeleteRecord(ByVal coderesult As Integer) Dim strsql As String = String.Empty 'je supose que la connection a été établie Dim command As New OleDbCommand(strsql, Connection) command.CommandText "DELETE FROM Results WHERE coderesult [coderesult?];" command.Parameters.Add("coderesult?", OleDbType.Integer).Value = coderesult command.ExecuteNonQuery() End Sub
Public Sub UPdatePlayer(ByVal FamillyName As String, ByVal Surname As String) Dim strsql As String = String.Empty 'je supose que la connection a été établie Dim command As New OleDbCommand(strsql, Connection) Dim codeplayer As Integer codeplayer = GetCodePlayer(FamillyName, Surname) command.CommandText "UPDATE Player SET FamillyName ([name?],Surname =[surname?]) WHERE playercode = [playercode?];" command.Parameters.Add("name?", OleDbType.BSTR).Value = FamillyName command.Parameters.Add("surname?", OleDbType.BSTR).Value = Surname command.Parameters.Add("playercode?", OleDbType.Integer).Value = codeplayer command.ExecuteNonQuery() End Sub
Private Function GetCodePlayer(ByVal FamillyName As String, ByVal Surname As String) As Integer Dim sql As String = String.Empty 'je supose que la connection a été établie Dim command As New OleDbCommand(sql, Connection) Dim recordset As OleDbDataReader recordset = Nothing command.CommandText "SELECT Playercode FROM Player WHERE Name [name?] AND Surname = [surname?];" command.Parameters.Add("name?", OleDbType.BSTR).Value = FamillyName command.Parameters.Add("surname?", OleDbType.BSTR).Value = Surname recordset = command.ExecuteReader() While recordset.Read Return Convert.ToInt32(recordset.GetValue(0)) End While End Function
Private Connection As New OleDb.OleDbConnection Public Sub Init() 'fait la connection 'à modifier selon le chemin BDD Dim base As String = "provider=microsoft.jet.oledb.4.0;data source=" & Application.StartupPath & "\DBSYNATEST.mdb" Connection.ConnectionString = base Try Connection.Open() Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub
Public Function GetList() As OleDbDataReader Dim sql As String Dim recordset As OleDbDataReader recordset = Nothing sql = "select * from TabInter" Dim myquery As New OleDbCommand(sql, Connection) Try recordset = myquery.ExecuteReader Catch ex As Exception MessageBox.Show(ex.Message) End Try Return recordset Connection.Close() End Function
private sub Displaylist() Dim myrecordset As OleDbDataReader myrecordset = Getlist() while myrecordset.read Me.Cmb_WO_Inter.Items.Add = myrecordset.GetString(0) ' pas forcément 0 mais l'index de Interv end while end sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionCombo.Items.Add(myrecordset.GetString(0))
Combo.Items.Add(myrecordset.GetString(1))
Combo.Items.Add(myrecordset.GetString(0))
Combo.Items.Add(myrecordset.GetString(0).tostring)
Combo.Items.Add(Convert.ToString(Convert.ToInt32(myrecordset.GetString(0))))
Mais je l'assume très bien!
aussi quelle réference as tu coché pour
déclarer ADODB.Connection ?
dans les COM réferences ?
MicroSoft ADO Data control 6.0 (OLEDB)
MicroSoft DAO 3.6 Objet Library
OLE Automation
je n'ai rien dans "Projets", mais j'ai:
Imports System.Data.OleDb Code Visual Basic : Private Connection As New OleDb.OleDbConnection Public Sub Init() 'fait la connection 'à modifier selon le chemin BDD Dim base As String = "provider=microsoft.jet.oledb.4.0;data source=" & Application.StartupPath & "\DBSYNATEST.mdb" Connection.ConnectionString = base Try Connection.Open() Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub Code Visual Basic : Public Function GetList() As OleDbDataReader Dim sql As String Dim recordset As OleDbDataReader recordset = Nothing sql = "select * from TabInter" Dim myquery As New OleDbCommand(sql, Connection) Try recordset = myquery.ExecuteReader Catch ex As Exception MessageBox.Show(ex.Message) End Try Return recordset Connection.Close() End Function Code Visual Basic : private sub Displaylist() Dim myrecordset As OleDbDataReader myrecordset = Getlist() while myrecordset.read Me.Cmb_WO_Inter.Items.Add = myrecordset.GetString(0) ' pas forcément 0 mais l'index de Interv end while end sub