Hi. I am running the following code through a button click. It uses the xSQLTable_Suppliers data table declared at the top of the code and bound using the code further down.
For some reason the data table isn't there. It looks like the variable isn't working. The error that I get is that there is no column called "SupplierName"
Sub Get_Defaults_for_Supplier(ByVal oSupplierName As String)
Dim xSQLAdapter_Suppliers As SqlDataAdapter 'declared at top of webform code
Dim xSQLTable_Suppliers As New DataTable
Function Fill_DGV_Suppliers() As Boolean
Dim sSQL As String
sSQL = "Select * From Suppliers"
Dim connection As New SqlConnection(Session("MyVar"))
xSQLAdapter_Suppliers = New SqlDataAdapter(sSQL, connection)
Me.dgvSuppliers.DataSource = xSQLTable_Suppliers
Fill_DGV_Suppliers = True
Catch ex As Exception
Me.lblGeneralError.Text = "Problem loading Suppliers table from SQL " & ex.Message
Fill_DGV_Suppliers = False
In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found. I hope it will be useful.
After closing a pop-up window, the parent page should be refreshed automaticall…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …