We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Bound ComboBoxAdv Mapping Error

Thread ID:





39669 Jan 15,2006 06:40 PM UTC Jan 16,2006 01:42 PM UTC WinForms 1
Tags: Tools
Tom Affholter
Asked On January 15, 2006 06:40 PM UTC

I have an application using bound controls connecting to a SQL Server update stored procedure. The app has about 30 controls of which one, cboprogID is a manually populated ComboBoxAdv control. I mapped the stored procedure''s @progID correctly (so it seems) along with the other 29 controls. cboprogID is bound by its text property. My DA''s select command thumbs thru data fine. When I try to perform an update I get the following error: Missing SourceColumn mapping for ''progID'' I have rearranged parameters and the problem follows progID. I have eliminated the problem in the stored procedure by including only variables in the procedure. I sure would appreciate some direction. Here is a bit of source: Me.cboProgID.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DsStudents1, "spSelectCommand.ProgID")) Me.UpDateStudent.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ProgID", System.Data.SqlDbType.VarChar, 10, "ProgID"))

Anupama Roy [Syncfusion]
Replied On January 16, 2006 01:42 PM UTC

Hi Tom, After setting up the command type and passing the parameters required for the stored procedure,have you specified any input/output parameter? Since you have just given a part of your code,I am not able to reproduce this issue here.Please try replacing your similar statement with the below given code snippet and see how it goes. Dim parm As SqlParameter parm = UpDateStudent.Parameters.Add(New SqlParameter("@ProgID", SqlDbType.VarChar, 10)) parm.Direction = ParameterDirection.Input; UpDateStudent.Parameters("@ProgID").Value = ProgID Since the Data Retrieval with stored procedures is the same as using standard SQL,I believe that the error is with either setting the query string or with the CommandType. Also please let me know whether you get the same error when you try binding with a .NET ComboBox? Thanks, Anu.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon