Greetings,
I am preparing a web app that returns totals of shipping costs for several categories of shipments. I will be using two TextBox controls where users will enter start and end dates. When the user clicks the submit button, the form refreshes to reveal the results (a series of labels tied to various queries). I have spent the last few days researching ways to accomplish this and have gotten as far as the following code, which all seems to work.
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim conn As New System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("SeanHomeTestDBConnectionString").ConnectionString)
Dim cmd As New System.Data.SqlClient.SqlCommand("SELECT SUM(pkg_cost) FROM [UPS_EOD_Export]", conn)
Try
...
Go to the complete details ...