473,766 Members | 2,026 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

An SqlParameter with ParameterName '@employment' is not contained by this SqlParameterCol lection in asp.net

Hi all

I have got this error

An SqlParameter with ParameterName '@employment' is not contained by
this SqlParameterCol lection

in asp.net

please help me out
Thanks in advance

Oct 15 '07 #1
1 5009
On Oct 15, 11:22 am, Dhananjay <dhananjay...@y ahoo.co.inwrote :
Hi all

I have got this error

An SqlParameter with ParameterName '@employment' is not contained by
this SqlParameterCol lection

in asp.net

please help me out
Thanks in advance
Can you show us the code where you are building your Db objects?

Thanks,

Seth Rowe

Oct 15 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2085
by: Mike C | last post by:
Hi. I'm just getting started with vb.NET development in VS 2003. I have a datagrid that lists a bunch of customers (hospitals). Next to the customer number and name is a bunch of checkboxes that I want to use to check whether it's a key account, defensive account, ambulatory surgery center, academic hospital, or MD office. The grid opens with the checkboxes in edit mode and shows whether a box is checked or not. This initial binding is...
5
8303
by: Jason Huang | last post by:
Hi, The SqlParameter myPM =new SqlParameter("@Address", txtAddress.Text) is working for update, but SqlParameter myPM =new SqlParameter ("@Address",SqlDbType.NVarChar,90,txtAddress.Text) is not working. The Address column is DataType NVarChar 90, no problem. Any idea?
2
301
by: Stephan | last post by:
Hi, I'm experiencing the problem mentioned in the title above. Briefly, I build a page in which I include a class. This class contains a procedure to add a value to an ArrayList. The value is hold by a structure. So all elements in the arraylist are in fact a structure. As you can see in the code below. Now what I'm trying to do is for each value in the Arraylist create and add a parameter. Then I try to execute a SP. This only works if...
0
1131
by: simon | last post by:
I have collection: Dim myParams As New Collection Then I fill it with parameters. Now, I would like to use it more than 1 time. When I create first dataAdapter, it works:
3
2766
by: Stacey Levine | last post by:
I have a webservice that has the below procedure. Basically a procedure to called a stored procedure and return the results. When I try to call the webservice from my program I get the error. Both my calling code and the webservice code are below. Thanks for your help. D:\Projects .NET\StoreBO\frmVoids.vb(182): Value of type '1-dimensional array of System.Data.SqlClient.SqlParameter' cannot be converted to '1-dimensional array of...
3
2225
by: Teeravee Sirinapasawasdee | last post by:
I found this method code in Enterprise Library 2.0 and I really don't have idea what does it mean. public virtual void SetParameterValue(DbCommand command, string parameterName, object value) { command.Parameters.Value = (value == null) ? DBNull.Value : value; } In my guess, the "(value == null) ? DBNull.Value : value" means if "value"
1
2130
by: tsorgi | last post by:
I'm writing a data conversion application to support a system migration. The code is reading formatted text files and loading them into MS SQL 2005 database tables. I wanted to call the existing INSERT stored procedures in the database to perform the update, yet I don't want to hard-code all the parameter names. Below is a bit of code that reads the imported data from the 'Data' DataTable, and prepares to insert it into the database table...
2
5865
by: Brad Pears | last post by:
I have the following code that adds SQLParameter objects to an SQLParameterCollection object (well at least that's what I am trying to do!!) When the line of code runs that adds the parameter (colParams.Add), the actual function call (CreateSQLParam) executes with no errors but the actual ".add" fails with an "Object reference not set to an instance of an object" error. At first I thought it was maybe because I did not use the "New"...
2
1330
by: Fuzz13 | last post by:
As some of you may have seen (since I have had to practically live on Bytes.com for help) I am working on a program that reads a given .txt or .csv creating an object of an array (lines) per line of text. The program then creates a file and/or folders based off the text lines in the file. I am running tests on text files to make sure I've killed what bugs I can and I got an error I don't understand. The text file contained this data: ...
0
9404
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10168
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10008
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7381
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6651
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5279
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5423
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3929
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.