Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 17th, 2006, 09:02 PM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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


 
Old July 18th, 2006, 01:08 AM
Friend of Wrox
 
Join Date: Jun 2004
Posts: 449
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to r_ganesh76
Default

what is the value of Session("id")? is it a number or text? if text, you need to make it a parameter and pass or pass it within single quotes

Regards
Ganesh
http://ganeshprof.blogspot.com
 
Old July 18th, 2006, 02:12 AM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The session id refers to an integer. What should i do if it's an integer?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Some help required ! codenet C# 2005 1 September 24th, 2007 04:01 PM
No value given for one or more required parameters djatsii Classic ASP Databases 16 January 4th, 2006 05:49 PM
No value given for one or more required parameters imercha Classic ASP Databases 1 December 21st, 2005 06:44 PM
No value given for one or more required parameters vlado Classic ASP Databases 10 October 5th, 2004 09:10 PM
No value given for one or more required parameters nidy_online ADO.NET 1 June 27th, 2004 09:44 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.