Dim monreader As OleDbDataReader = MaCommande.ExecuteReader() monreader.Read()
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWhile (monreader.Read = True) For i = 0 To nombreid -1 Step 1 DataGridView1.Item(0, i).Value = TextBox1.Text DataGridView1.Item(1, i).Value = monreader.GetString(0) DataGridView1.Item(2, i).Value = monreader.GetString(1) DataGridView1.Item(3, i).Value = monreader.GetString(2) DataGridView1.Item(4, i).Value = monreader.GetString(3) Next End While
MaConnexion.Open() MaCommande.CommandText = "SELECT NomPat,PrePat,MedecinTraitant,Pathologie FROM PATIENT WHERE ID='" & TextBox1.Text & "';" Dim monreader As OleDbDataReader = MaCommande.ExecuteReader() Dim i As Integer While (monreader.Read = True) i = DataGridView1.Rows.Add() DataGridView1.Item(0, i).Value = TextBox1.Text DataGridView1.Item(1, i).Value = monreader.GetString(0) DataGridView1.Item(2, i).Value = monreader.GetString(1) DataGridView1.Item(3, i).Value = monreader.GetString(2) DataGridView1.Item(4, i).Value = monreader.GetString(3) End While
Imports System.Data.OleDb Module db Private Connection As New OleDb.OleDbConnection 'declares connection Public Sub Init() Dim base As String = ("Provider=Microsoft.ACE.OleDb.12.0; Data source=BDD projet.accdb") Connection.ConnectionString = base Try Connection.Open() Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub Public Sub CloseConnection() Connection.Close() End Sub Private Function GetRecords(ByVal IdPatient As String) As Integer Dim sql As String = String.Empty Dim command As New OleDbCommand(sql, Connection) Dim recordset As OleDbDataReader recordset = Nothing command.CommandText "SELECT COUNT(*) FROM PATIENT WHERE ID [?] ;" command.Parameters.Add("?", OleDbType.BSTR).Value = IdPatient Try recordset = command.ExecuteReader If recordset.HasRows Then recordset.Read() Return recordset.GetInt32(0) Else Return 0 End If Catch ex As Exception MessageBox.Show(ex.Message) End Try End Function Public Function GetDetailsPatient(ByVal IdPatient As String) As OleDbDataReader Dim sql As String = String.Empty Dim command As New OleDbCommand(sql, Connection) Dim recordset As OleDbDataReader recordset = Nothing command.CommandText = "SELECT NomPat,PrePat,MedecinTraitant,Pathologie FROM PATIENT WHERE ID= [?] ;" command.Parameters.Add("?", OleDbType.BSTR).Value = IdPatient Try recordset = command.ExecuteReader Catch ex As Exception MessageBox.Show(ex.Message) End Try Return recordset End Function End Module
Imports System.Data.OleDb Public Class Form1 Private Sub ShowResultPatientPathology() Dim recordset As OleDbDataReader Dim iter As Integer Dim titles(3) As String Dim margin As Integer Dim widthgrid As Integer Dim heightgrid As Integer Dim drawfont As New Font("arial", 14, FontStyle.Bold, GraphicsUnit.Pixel) titles(0) = " Nom Patient" titles(1) = "Prenom Patient" titles(2) = " Medecin Traitant" titles(3) = "Pathologie" DataGridresult.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Sunken DataGridresult.Font = drawfont recordset = Nothing recordset = db.GetListPatientPathology(textbox1.text) If Not recordset.HasRows Then MessageBox.Show("Aucun résultat") Exit Sub End If DataGridresult.AutoResizeColumns() DataGridresult.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing DataGridresult.EnableHeadersVisualStyles = False DataGridresult.ColumnHeadersDefaultCellStyle.BackColor = Color.PowderBlue DataGridresult.Columns.Clear() DataGridresult.Rows.Clear() For iter = 0 To recordset.VisibleFieldCount - 1 DataGridresult.Columns.Add(recordset.GetName(iter), titles(iter)) DataGridresult.Columns(iter).DefaultCellStyle.BackColor = Color.Linen Next Dim rowvalue(recordset.VisibleFieldCount - 1) As String Dim counter As Integer counter = 1 While recordset.Read If counter > 14 Then heightgrid = DataGridresult.RowHeadersWidth * 12 Else heightgrid = DataGridresult.RowHeadersWidth * counter End If counter += 1 widthgrid = 40 For iter = 0 To recordset.VisibleFieldCount - 1 DataGridresult.Columns(iter).AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells rowvalue(iter) = (Convert.ToString(recordset.GetValue(iter))) widthgrid += DataGridresult.Columns(iter).Width Next DataGridresult.Rows.Add(rowvalue) End While DataGridresult.Width = widthgrid DataGridresult.Height = heightgrid End Sub Private Sub Buttonvalid_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Buttonvalid.MouseClick If RadioButton1.Checked Then db.Init() ShowResultPatientPathology db.CloseConnection End Sub End Class