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
| Sub GetAuthors_Click(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
Dim SelectCommand As String = "select idagent,matricule,noms,prenoms,email,qualite,objetmission,pays,ville from agent where structure= structure"
MyConnection = New SqlConnection("Server=(local); Initial Catalog='mission';" _
& " Trusted_Connection=True;")
MyCommand = New SqlDataAdapter(SelectCommand, MyConnection)
' MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@structure", SqlDbType.VarChar, 2))
' MyCommand.SelectCommand.Parameters("@structure").Value = nomListe.Value
DS = new DataSet()
MyCommand.Fill(DS, "agent")
MyDataGrid.DataSource = DS.Tables("agent").DefaultView
MyDataGrid.DataBind()
End Sub
Public Shared Sub RemplirListeDer(ByVal idRQ As String, ByRef nomListe As DropDownList)
'MyConnection As New DataManager("missionConnectionString")
Dim dm = New SqlConnection("Server=(local); Initial Catalog='mission';" _
& " Trusted_Connection=True;")
Dim dt As DataTable
dt = dm.GetAuthors_Click(idRQ)
For i As Int16 = 0 To dt.Rows.Count - 1
nomListe.Items.Add(New ListItem(dt.Rows(i).Item(1), dt.Rows(i).Item(0)))
Next
End Sub |
Partager