Récupérer data de multiples requêtes en une fois
Bonjour,
Sur SQL server 2008 on peut lancer plusieurs requêtes en une fois.
Code:
1 2
| select colonne from table_1 where colonne = 'Salut';
select colonne_2 from table_2 where colonne_2 = 'Bonjour' |
comment récupérer les résultat des 2 requêtes
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
| Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim dt As DataTable
Dim cn As New SqlConnection
Dim ds As New DataSet
Dim connectionstring As String
Dim sql As String
sql = "select colonne from table_1 where colonne = 'Salut'" & _
" select colonne from table_2 where colonne_2 = 'Bonjour'"
connectionstring = "Persist Security Info=True;User ID=xx;Initial Catalog=xxx;Data Source=xxx;Packet Size=4096;Password=xxx"
cn = New SqlConnection(connectionstring)
cn.Open()
ds.Clear() 'efface le precedent dataset
Dim da As New SqlDataAdapter(sql, cn)
da.Fill(ds, "Verif_OBS")
cn.Close()
For i = 0 To ds.Tables(0).Rows.Count - 1
dt = ds.Tables("Verif_OBS")
Dim row As DataRow
row = dt.Rows(i)
Dim RESULT As String
RESULT = row("colonne") 'Pour la premiere
MsgBox(RESULT)
'??????????????????????????
'pour la 2e
Next
da = Nothing
ds = Nothing
End Sub |
Merci!