Torna al Thread

Protected Sub cat_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Dim con As New System.Data.OleDb.OleDbConnection("Provider=SQLOLEDB;Data Source=GOMMOSA\SQLEXPRESS;Initial Catalog=MIO_SITO;User ID=sa;Password=saweb") con.Open() Dim com As New System.Data.OleDb.OleDbCommand() com.Connection = con com.CommandText = "select DENOMINAZIONE from CATEGORIE" Dim da As New System.Data.OleDb.OleDbDataAdapter() da.SelectCommand = com Dim ds As New DataSet1() da.Fill(ds, "CATEGORIE") Me.cat.DataSource = ds.Tables("CATEGORIE") Me.cat.DataValueField = "DENOMINAZIONE" con.Close() End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5