VS2015 - Strings.format + Combobox 3 Values + TextBox
Bonjour,
J'ai besoin d'un peu d'aide car je suis bloqué.
J'ai un Combobox avec 3 valeurs par ligne et j'ai creer un bouton pour qu'il m'affiche dans
- textbox1 = la premiere valeur du combobox
- textbox2 = la deuxieme valeur du combobox
Mais je mis prend mal, une aide serai bienvenue, je laisse mon code.
Code:
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
| Imports MySql.Data.MySqlClient
Public Class test
Dim MysqlConn As MySqlConnection
Dim COMMAND As MySqlCommand
Dim READER As MySqlDataReader
Dim a As Object
Dim b As Object
Dim c As Object
Private Sub test_Load(sender As Object, e As EventArgs) Handles MyBase.Load
MysqlConn = New MySqlConnection
MysqlConn.ConnectionString =
"server=xxxxxx;userid=xxxx;password=xxxxx;database=xxxxx"
Dim READER As MySqlDataReader
Try
MysqlConn.Open()
Dim Query As String
Query = "select nombre, tipo, ref from xxxx.xxxxx "
COMMAND = New MySqlCommand(Query, MysqlConn)
READER = COMMAND.ExecuteReader
While READER.Read
Dim sProductos = READER.GetString("nombre")
Dim sTipoProductos = READER.GetString("tipo")
Dim sProductosRef = READER.GetString("ref")
ComboBox2.Items.Add(String.Format("{0}|{1}|{2}", sProductos, sTipoProductos, sProductosRef))
End While
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
MysqlConn.Dispose()
End Try
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
TextBox1.Text = ComboBox2.Text(String.Format("{0}"))
TextBox2.Text = ComboBox2.Text(String.Format("{1}"))
End Sub
End Class |
