create database dbclube; create table clubee(codecl int primary key, nomcl varchar(50), emailcl varchar(40), telcl varchar(40)); create table membre(codem int primary key, nomm varchar(50), prenomm varchar(50), emailm varchar(40), telm varchar(50), codecl int); insert into membre(codem, nomm, prenomm, emailm, telm, codecl)values(1, 'Kadiri', 'Amine', '***@***', '0681152', 2),(2, 'Fahmi', 'Amina', '***@***', '0681152', 3),(3, 'Swiri', 'Mourad', '***@***', '0681152', 4); select * from membre;
Option Strict On Public Class Form1 Sub chargerclub() cbclub.DisplayMember = "nomcl" cbclub.ValueMember = "codecl" cbclub.DataSource = getTable("select*from clubee") End Sub Sub listermembre(ByVal n As String) Dim req As String req = "select codem as [Code], nomm as [Nom de famille], prenomm as [Nom propre] emailm as [Email], nomcl as [club] from membre m inner join clubee c on m.nomcl=c.nomcl" dgvliste.DataSource = getTable(req) End Sub Function formvalide() As Boolean If txtnom.Text.Trim.Equals("") Or txtprenom.Text.Trim.Equals("") Or txtemail.Text.Trim.Equals("") Or txttel.Text.Trim.Equals("") Then Return False End If Return True End Function Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load connecter() chargerclub() listermembre("") End Sub Private Sub txtsearch_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtsearch.TextChanged listermembre(txtsearch.Text) End Sub Sub nouvelcode() Dim x As DataTable = getTable("select max(codem)from membre") Dim n As Integer = CInt(x.Rows(0).Item(0).ToString) n += 1 txtcode.Text = n.ToString End Sub Private Sub cmbcode_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbcode.Click nouvelcode() End Sub Private Sub cmbEnregistrer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbEnregistrer.Click If Not formvalide() Then MessageBox.Show("formulaire invalide") Exit Sub End If Dim r As String = "insert into membre values(" + txtcode.Text + ",'" + txtnom.Text + "','" + txtprenom.Text + "','" + txtemail.Text + "','" + txttel.Text + "'," + cbclub.SelectedValue.ToString + ")" setreq(r) listermembre("") End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim pos As Integer = dgvliste.CurrentRow.Index If pos = -1 Then Exit Sub Dim n As Integer = CInt(dgvliste.Rows(pos).Cells(0).Value.ToString) Dim rep As DialogResult = MessageBox.Show("delete?", "choix", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) If rep <> DialogResult.Yes Then Exit Sub Dim r As String = "delete from membre where codem=" + n.ToString setreq(r) listermembre("") End Sub End Class <code basic></code>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question
8 févr. 2020 à 12:50
8 févr. 2020 à 13:18
Avec le bout de code, je ne vois pas où ça parle de l'objet en cause.
Si cela est en lien avec une requête SQL, il serait bien de la voir.