Torna al Thread

Function CreateDataSource(ByVal CodiceComune As Integer) As ICollection Dim dt As New DataTable() Dim dr As DataRow dt.Columns.Add("tipo_esenti") dt.Columns.Add("desc_esenti") Try Dim conString = ConfigurationManager.ConnectionStrings("DB_PROVA") Dim strConnString As String = conString.ConnectionString Using db As New SqlConnection(strConnString) db.Open() Using sqlcmd As New SqlCommand("Get_tipo_esenzioni", db) sqlcmd.CommandType = CommandType.StoredProcedure sqlcmd.Parameters.AddWithValue("@CodComune", SqlDbType.Int).Value = CodiceComune Using sqldr As SqlDataReader = sqlcmd.ExecuteReader While sqldr.Read dr = dt.NewRow() dr(0) = sqldr.GetSqlValue(0).Value dr(1) = sqldr.GetSqlValue(1).Value dt.Rows.Add(dr) End While End Using End Using End Using Dim dv As New DataView(dt) Return dv Catch ex As SqlException Page.RegisterStartupScript("ScriptDescription", "<script type=""text/javascript"">alert('" & ex.Message & "');</script>") Catch ex As Exception Page.RegisterStartupScript("ScriptDescription", "<script type=""text/javascript"">alert('" & ex.Message & "');</script>") End Try End Function 'CreateDataSource
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5