Torna al Thread

Option Explicit On Public Class Form1 Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim stringa As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click stringa = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" stringa = stringa & "C:\Inetpub\wwwroot\Sms_notify\db_data\sms_notify.mdb" cn = New ADODB.Connection rs = New ADODB.Recordset cn.Open(stringa) rs.Open("SELECT * FROM login", cn, 1) lblDati.Text = "--> " If rs.EOF Then lblDati.Text = "Nessun dato" Else While rs.EOF = False lblDati.Text = rs("username") rs.MoveNext() End While End If cn = Nothing rs = Nothing End Sub Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub End Class
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5