Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OleDbException - parameter missing
Message
De
06/07/2007 12:04:10
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
OleDbException - parameter missing
Versions des environnements
Environment:
C# 2.0
Divers
Thread ID:
01238240
Message ID:
01238240
Vues:
55
I am getting an OleDbException of "No value given for one or more required parameters" with the following:
public mmBindingList<ContactNotesEntity> GetContactDetailByContactID(int? contactID)
     {
	mmBindingList<ContactNotesEntity> ContactNotesList;

	if (contactID != null)
         {
				
	    ContactNotesList = this.GetEntityList("SELECT * FROM ContactNotes WHERE request_ID = @ContactID",
		this.CreateParameter("@ContactID", contactID));
	}
	else
	{
	     this.GetEmptyDataSet();
	     ContactNotesList = new mmBindingList<ContactNotesEntity>();
	}
	return ContactNotesList;
      }
I am using Access data and it works everywhere else right now. In my aBusiness object I have:
this.DefaultCommandType = CommandType.Text;

I also do not get any build errors. Debugging shows the contactID is set to 5

Any ideas what I am overlooking?
Timothy Bryan
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform