.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error: No value given for one or more required parameters

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :ASP.Net

Hi.. Im getting error: No value given for one or more required parameters. in following code. I checked the code n found that if i remove cmd.Parameters.AddWithValue("PERIOD", period); from code and [period] = ? from command text, everything works fine. I am not getting what is wrong with period.
I am using access database and every field in database is text.
string period;
public void calc()

View Complete Post

More Related Resource Links

Viewmodel property not set to [Required] yet getting error message saying it is?


I have a viewmodel that i use for my view

public int SelectionId{ get; set; }        
public IEnumerable<Selections> Selections { get; set; }

Notice that SelectionId is not decorated with [Required]. In my view, i use DropDownFor like this:

<%= Html.DropDownListFor(m => m.SelectionId, new SelectList(Model.Selections, "Id", "Name"), "--- Select ---")%>

It should be possible to not select anything from the dropdown, resulting in model.SelectionId = 0, which is fine. Why do i get a "SelectionId field is required" error when i Post?  If i do this:

<%= Html.DropDownList(mySelectionId, new SelectList(Model.Selections, "Id", "Name"), "--- Select ---")%>

I no longer get the error if i dont select anything, which is what i want - but no way to bind it to the id if the user does select something

thanks for any help!

No value given for one or more required parameters.

Hello, I am getting the "No value given for one or more required parameters." when importing an Excel 2003 spreadsheet into my web site. I have pinpointed the problem to be the last column in my SELECT statement. This column does not seem to be a reserved word and the the data in the column 'POS' and 'HMO' seems fine as well. The SELECT code is posted below as well as 4 other columns I am having the same problem (they are commented out for now). Any help solving this problem would be greatly appreciated.Dim objCommand As New OleDbCommand("SELECT [Employee Name] as Employee, " & _ "[Residence Zip Code] as ZipCode, " & _ "[Position] as EmpPos, " & _ "[FT Exempt, FT Non Exempt, PT Exempt, PT Non Exempt] as Exempt, " & _ "[Annual Salary OR Hourly Rate] as Rate, " & _ "[Hours Per Pay Cycle] as HoursPerPayCycle, " & _ "[Date of Birth] as DateOfBirth, " & _ "[Gender] as Gender, " & _ "[Status: Active or COBRA] as AorCStatus, " & _ "[Plan Name] as PlnName " & _ "FROM [Census$]", objXConn) ' "[Workers Comp Category] as WorkersComp, " & _ ' "[Medical Tier: EE Only, EE & Child(ren), EE

Server ERROR: An error occurred during the parsing of a resource required to service this request.

I have created one asp.net 2.0 application and created a setup project. I run this setup in my local machine, the application run fine, but i uploaded into online server I met the following parser error.How to solve this error? Kindly help me. Very urgent.. Kamal....

error in MVC2 on empty string form fields which are required: "This property cannot be set to a null

In model I have:[DisplayName("ISBN")] [Required(ErrorMessage = "ISBN is required.")] [StringLength(50, ErrorMessage = "ISBN book must have max {1} chars.")] [DisplayFormat(ConvertEmptyStringToNull = false)] public string isbn { get; set; }But when I submit form with empty field ISBN I have an error - ConstraintException: This property cannot be set to a null value.I have find that other people have the same problem and they say that debbugger in VS2010 works wrong - yes ?http://p2p.wrox.com/book-professional-asp-net-mvc-2/79788-constraintexception-unhandled-user-code.html#post259245http://efreedom.com/Question/1-3129080/Server-Side-Validation-REQUIRED-String-Property-MVC2-Entity-Framework-Workhttp://mvcmusicstore.codeplex.com/workitem/6604

modalpopup and javascript error object required

Hi!   I Have this error when click on a button to open a popup box in my page: "object required"   Here is my code:   <%@ Page Language="VB" MasterPageFile="~/artm.master" AutoEventWireup="false" CodeFile="artm_principal.aspx.vb" Inherits="artm_principal" title="Principal" Debug="true" MaintainScrollPositionOnPostback="true"%><%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="AJT" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">                                      <AJT:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"></AJT:ToolkitScriptManager>                                        <AJT:ModalPopupExtender ID="ModalPopupExtender1" runat="server"         &

Microsoft SharePoint server 2010 encountered an error during setup. One or more required office comp

I am encountering this error during setup. The server previously had WSS 3.0 and the Group Board Workspace. I uninstalled those and installed sharepoint foundation 2010. Initially It was up and running but I was receiving errors trying to load the group space template, so I uninstalled SPF2010. cleaned up the registry pointers to the old WSS3.0 and Groupboard Workspace and tried to reinstall. Now I get the error

Microsoft SharePoint server 2010 encountered an error during setup. One or more required office components failed to complete successfully.

Looking into the issue it appears that setup cannot install the embedded sql server, since the logs indicate a dbwrap error. There are no "pendingfilerename" operations which fixed this problem for some. I tried to install as a farm but it won't allow me to use a local admin account.  I also looked at the sql configurations and the windows internal database is running.

Any ideas how to I can remove the windows internal database and reinstall SF2010?

InfoPath error: One or more required custom controls in this form cannot be created


I have an InfoPath 2007 form published to a form library in MOSS 2007.  This form opens in InfoPath and is not browser-enabled.

The form suddenly stopped working for me and 1 other user.  I'm a farm admin and the user only has contributor rights on the form library (and site and subsite).  Everyone else with appropriate permissions can access existing forms that use the template and can create new forms using the template.

When either one of us tries to open the form, we get:

InfoPath cannot open the following file: http://site/subsite/formlibrary/filename.xml?OpenIn=PreferClient&NoRedirect=true&XmlLocation=/subsite/formlibrary/filename.xml.
One or more required custom controls in this form cannot be created.

No errors in the web front end event log or SharePoint log files.  No errors in my client PC's event log.

I've tried the following without success:

Opening the template and publishing it to a new list. 
Published the template to a new content type on this list and a new list. 
Dumped IE cache and reset IE settings.
Rebooted the computer.
Checked permissions on the list to make sure they were correct.

Last change made to the farm:

I performed the work around change to the web

Parameters with DBNull.Value becomes "default" and causes error in SqlServer


Hi, I have a table with a nullable column.

When I try to insert a record using INSERT statement I pass a parameter set to the value DBNull.Value.

Then I get an error from the SqlServer saying that the parameter was not supplied.

Using Sql-profiler i see that the applied parameter is set to the keyword 'default'.

I try to run the query inside Sql Server Management Studio, it looks something like this:

exec sp_executesql N'INSERT INTO [tbl] ([Val1]) VALUES (@Val1_P)', @Val1_P=default

First, why is the server giving the error about parameter not supplied? I have supplied it, and the value is keyword default.

Then I try to change the query to setting @Val1_P=null. This works..

BUT the problem then is, how do I set this from ADO Command object? I have set the parameter to DbNull.Value, and it translate it to 'default'.. What's going on here? I wanted the parameter to be the keyword 'null' not 'default'.

Any suggestions? Thank you in advance!

Multiple Parameters Error OLEDB MS Access SSRS



I have created an SSRS in BIDS 2008 with OLEDB Provider so as to access MS Access 2010 DB. My report is working fine. But the only problem is when am sending multiple parameter it raises error. I have enabled AllowMultiple Value checkbox.

ERROR : "Cannot add multi value parameter '@parametername" for DataSetName because it is not supported by the data extension".

My query is "SELECT * FROM tablename WHERE ([columnname] in (@parametername))"

Thanks in advance



Error passing parameters from C# to Stored Procedure



I have a Stored Procedure that receive a parameter.
- SP name: hr_all_markets
- SP parametter: @cs_rep (type varchar 50)
In my C# code I already called this SP without parameters and works fine, but when I try to run with parameters I have this error:
- Incorrect syntax near 'hr_all_markets'.

No value given for one or more required parameters


I have a form that has 5 text boxes on it and 2 command buttons. One of the command buttons inserts data into the database and the other command button gets data from the database. I made a ms access database that has 6 fields(id, Ticket, UserID, Date, Time, Description). I am able to connect to the database and insert data from the text boxes on my form but i am having  problems getting the data from the database and displaying the information in text boxes located on my windows form. When i hit the "Get Data" command button a input box comes so i can type in the ticket number "IN403256" to retrieve the data, but everytime i type one of the ticket numbers in the input box it says "No value given for one or more required parameters." I want to be able to input a ticket number and bring up all the information that pertains to that unique ticket number and see the information from the database in the text boxes on the windows forms.

here is my code:

Private Sub btnRetrieve_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRetrieve.Click

txtTicket.text = ""


Database Tuning Advisor, Stored Procedure with datetime parameters, syntax error


I receive these error(s) in the Tuning Log. I have several stored procedures and they all use a datetime parameter.

E000    exec <some sproc name> ''2009-01-01 00:00:00:000'',''2010-09-30 00:00:00:000'',N'',N'',NULL,NULL,NULL,NULL,NULL,NULL         1    [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '2009'.

I am using SQL 2005. Any suggestions?

Thanks, Reece

"Procedure has no parameters and arguments were supplied." Error

Hi all, 
I keep getting a "Procedure has no parameters and arguments were supplied."
Here is the stored procedure and code-behind:
ALTER PROCEDURE [dbo].[c_clinical_services_erp_insert_submission] 


DECLARE @my_err as integer 
DECLARE @id as integer
declare @award_id as integer
declare @submitter_username as varchar(50)
declare @submit_date as varchar(50)
declare @nominee_name as varchar(50)
declare @nominee_dept as varchar(50)
declare @aop_goals as varchar(50)
declare @reason as varchar(5000)
declare @award_cat as varchar(25)
declare @quest_num as varchar(25)
declare @answer1 as varchar(1000)
declare @answer2 as varchar(1000)
declare @answer3 as varchar(1000)
declare @answer4 as varchar(1000)
declare @answer5 as varchar(1000)
declare @answer6 as varchar(1000)
set @id = 1
set @award_id = 1
set @submitter_username = 'cjose'
set @submit_date = '10/25/10'
set @nominee_name = 'lee'
set @aop_goals = 'test'
set @reason = 'test'
set @award_cat = 'customer service'
set @quest_num = '1'
set @answer1 = 'gfehfds'
set @answer2 = 'gasd'
set @answer3 = 'gfsdfs'
set @answer4 = 'gsdfds'
set @answer5 = 'sdfs'
set @answer6 = 'sdfghs&

SQL Execution Error, Specified type is not registered on the target, when adding DateTime parameters


I have SQLServer 2008r2 installed on a Windows Server 2008 R2 machine.  I'm trying to build a report using SSRS - and as soon as I try to add some DateTime parameters to the query and execute, I get

SQL Execution Error.

Executed SQL Statement:  blah blah Error

Source: System.Data

Error Message: Specified type is not registered on the target server.System.DateTime, mscorlig, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089.

I tried taking the suggestion from another thread and installing the .NET Framework 2.0 from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=B44A0000-ACF8-4FA1-AFFB-40E78D788B00, but I received the message that it is already installed.  How do I get past this error?

Microsoft JScript runtime error: Object required


have code

and i m getting an error( mentioned in title ) on line

browserdetect = textcontainerobj.filters ? "ie" : typeof textcontainerobj.style.MozOpacity == "string" ? "mozilla" : ""

please help 


<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb" Inherits="Default3" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>GFLN - Global Freight & Logistics Network</title>
<!--[if IE 6]>
<script type="text/javascript" src="js/DD_belatedPNG.js"></script>
<link href="css/styles.css" rel="stylesheet" type="text/css"/>
<!-- for left menu-->
<script type="text/javascript">

    var baseopacity = 0

    function showtext(thetext) {
        if (!document.getE

Object Required..etc error point to label while clicking panel.


while clicking on the panel for expanding collapsible panel

getting errors such as , object required..etc on line :

<asp:Label ID="lbldateempty" runat="server" ForeColor="Red"
                                                    Text="Please select the dates" Visible="False"></asp:Label>

the portion of the panel as below :

<asp:Panel ID="pnl01" runat="server">

<asp:CollapsiblePanelExtender ID="CollapsiblePanelExtender1" runat="server" ExpandedText="asasddsa"  ExpandControlID="pnl01" CollapseControlID="pnl01" TargetControlID="panelmultiplecategory" Collapsed="true"></asp:CollapsiblePanelExtender>    
                                     <asp:Panel ID="panelmultiplecategory" runat="server" Width="830px"> 
                                         <asp:GridView ID="gvClaimSummaryMini" HeaderStyle-BackColor="#B8A9DC" 

No value given for one or more parameters error


I am working in ASP and keep getting a No value given for one or more parameters error. The problem is I'm passing txtHotelID as a string but in the textbox I entered a number. I've tried several times putting single quotes around it and keep getting the same error. In my access database I declared the Hotel_ID field as Text. Please help.

    Protected Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnUpdate.Click

        Dim sSQLUpdate As String

        Dim sConnectionString As String = "Provider=Microsoft.jet.oledb.4.0;" & _
        "Data source=e:\Hotels.mdb"

        sSQLUpdate = "Update Hotels set Hotel_Name = @HotelName where Hotel_ID = '& txtHotelID.Text &'"
        Dim conUpdate As New OleDbConnection(sConnectionString)

        Dim cmdUpdate As New OleDbCommand(sSQLUpdate, conUpdate)

    End Sub

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend