No value given for one or more required parameters
hi, i am new here. Just hop you all can help me with this error after i debug the mobile web application.
Here are my codes.
error: No value given for one or more required parameters
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
lblDeliverName.Text = "Hi Deliveryman: " + Session("name") & ""
If Not Page.IsPostBack Then
OleDbConnection1.Open()
Dim checksql As String
checksql = "SELECT WorkOrderID,CompanyName as Company, Description, " _
+ "TimeReported as Timing, Status FROM " _
+ "WorkOrder, Customer where WorkOrder.companyID " _
+ "=Customer.companyID AND Delivery=" + Session("id")
Dim OleDbCommand1 As OleDb.OleDbCommand
OleDbCommand1 = New OleDb.OleDbCommand(checksql, OleDbConnection1)
Dim DataReader1 As OleDb.OleDbDataReader
DataReader1 = OleDbCommand1.ExecuteReader
'connecting to the Listbox
ObjectList1.DataSource = DataReader1
ObjectList1.LabelField = "Company"
ObjectList1.BackCommandText = "Back to Summary"
ObjectList1.DataBind()
DataReader1.Close()
End If
End Sub
|