Protected Sub cat2_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim con2 As New System.Data.OleDb.OleDbConnection("Provider=SQLOLEDB;Data Source=GOMMOSA\SQLEXPRESS;Initial Catalog=MIO_SITO;User ID=sa;Password=saweb")
        con2.Open()
       
        Dim com2 As New System.Data.OleDb.OleDbCommand()
        com2.Connection = con2
        com2.CommandText = "select DENOMINAZIONE from CATEGORIE"
        Dim da2 As New System.Data.OleDb.OleDbDataAdapter()
        da2.SelectCommand = com2
        Dim dr1 As System.Data.OleDb.OleDbDataReader
        dr1 = com2.ExecuteReader()
        cat2.DataSource = dr1
        cat2.DataBind()
        dr1.Close()
        con2.Close()
    End Sub