1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| Private Sub FrmTitre_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim iData As IDataObject = Clipboard.GetDataObject() ' récupération du texte depuis le Clipboard
If iData.GetDataPresent(DataFormats.Text) Then
Txtbox1.Text = CType(iData.GetData(DataFormats.Text), String)
Else
Txtbox1.Text = "Impossible de récupérer le texte"
End If
Dim conn As OleDbConnection
conn = OleDbConnection1
Dim da As OleDbDataAdapter = New OleDbDataAdapter
Dim cmd As OleDbCommand
cmd = New OleDbCommand("SELECT CodeDVD, TitreOrigine, TitreTraduit, Divers, Annee FROM Films " & _
"WHERE (CodeSupport=1) AND (TitreOrigine LIKE '%' + [at]name + '%') ORDER BY TitreOrigine", conn)
cmd.Parameters.Add("@CodeDVD", OleDbType.Integer, 8)
cmd.Parameters.Add("@TitreOrigine", OleDbType.VarChar, 100)
cmd.Parameters.Add("@TitreTraduit", OleDbType.VarChar, 100)
cmd.Parameters.Add("@TitreOrigine", OleDbType.VarChar, 100)
cmd.Parameters.Add("@Divers", OleDbType.VarChar, 100)
cmd.Parameters.Add("@Annee", OleDbType.Numeric, 8)
cmd.Parameters.Add(New OleDbParameter("[at]name", OleDbType.VarChar, 20)).Value = Txtbox1.Text
da.SelectCommand = cmd
DataSet11.Clear()
da.Fill(DataSet11, "Films")
End Sub |
Partager