Torna al Thread

Function CreateDataSource() As ICollection Dim dt As New DataTable() Dim dr As DataRow dt.Columns.Add(New DataColumn("Denominazione", GetType(String))) dt.Columns.Add(New DataColumn("Indirizzo", GetType(String))) dt.Columns.Add(New DataColumn("Categoria", GetType(String))) dt.Columns.Add(New DataColumn("Comune", GetType(String))) dt.Columns.Add(New DataColumn("Provincia", GetType(String))) dt.Columns.Add(New DataColumn("Presenze", GetType(String))) dt.Columns.Add(New DataColumn("Percentuale", GetType(String))) dt.Columns.Add(New DataColumn("Totale Imposta", GetType(String))) Try Dim conString = ConfigurationManager.ConnectionStrings("DB_GESTIONE") Dim strConnString As String = conString.ConnectionString Using db As New SqlConnection(strConnString) db.Open() Using sqlcmd As New SqlCommand("imposta", db) sqlcmd.CommandType = CommandType.StoredProcedure sqlcmd.Parameters.AddWithValue("@start", SqlDbType.DateTime).Value = Me.Txt_dal.Text sqlcmd.Parameters.AddWithValue("@end", SqlDbType.DateTime).Value = Me.Txt_al.Text Using sqldr As SqlDataReader = sqlcmd.ExecuteReader While sqldr.Read dr = dt.NewRow() dr(0) = sqldr.GetSqlString(0).Value dr(1) = sqldr.GetSqlString(1).Value dr(2) = sqldr.GetSqlString(2).Value dr(3) = sqldr.GetSqlString(3).Value dr(4) = sqldr.GetSqlString(4).Value dr(5) = sqldr.GetSqlInt32(5).Value dr(6) = sqldr.GetSqlDecimal(6).Value dr(7) = sqldr.GetSqlDecimal(7).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