Datagrid: Impossibile popolare

Article View: free.it.visual-basic

Article #1235

Back to free.it.visual-basic Previous Next

#1235

From: Nicola
Date: Wed, 18 Aug 2004 21:19

32 lines
1697 bytes

Salve, devo popolare un datagrid, ma non ci riesco.
ecco il codice
---------------------
Set cn = New ADODB.Connection
        Set rs = New ADODB.Recordset
txtricerca = txtricerca.Text

cn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=C:\Documents and
Settings\Nicola\Desktop\Rubrica\Agenda.mdb"

rs.Open "SELECT * FROM utenti where " & tipo & " like '" & txtricerca & "'",
cn

If Not rs.EOF Then

Frame4.Visible = True

Set risultati.DataSource = rs
risultati.Refresh

        rs.Close
        cn.Close
                    Else

        MsgBox "La ricerca non ha prodotto nessun risultato."
                   End If
----------------------------
Che sbaglio?

Mi da errore nella linea rossa.

GRAZIE

Technical Details

Message-ID: <iJPUc.44588$1V3.1205911@twister2.libero.it>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!fr.ip.ndsoftware.net!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!nntp.eutelia.it!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f94ee,22be5230f0e15caa,start
X-Google-Attributes: gidf94ee,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!fr.ip.ndsoftware.net!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!nntp.eutelia.it!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail
From: "Nicola" <niteblue@libero.it>
Newsgroups: free.it.visual-basic
Subject: Datagrid: Impossibile popolare
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <iJPUc.44588$1V3.1205911@twister2.libero.it>
Date: Wed, 18 Aug 2004 21:19:10 GMT
NNTP-Posting-Host: 151.26.26.70
X-Complaints-To: abuse@libero.it
X-Trace: twister2.libero.it 1092863950 151.26.26.70 (Wed, 18 Aug 2004 23:19:10 MET DST)
NNTP-Posting-Date: Wed, 18 Aug 2004 23:19:10 MET DST
Organization: [Infostrada]