473,809 Members | 2,695 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

BindingManagerB ase not working with stored procedures

I have a BindingManagerB ase which is used witha stored precudure. When I try
to execute the statement:
this.BindingCon text[dataset1, "table1"]

I get the error: System.Argument Exception was unhandled. Message="Child
list for field table1 cannot be created."

L. A. Jones
Sep 4 '06 #1
4 1385
Dave,

Can you show the code that you are using that sets the data source on
your control? Without seeing that, it's hard to say.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Dave" <Da**@discussio ns.microsoft.co mwrote in message
news:40******** *************** ***********@mic rosoft.com...
>I have a BindingManagerB ase which is used witha stored precudure. When I
try
to execute the statement:
this.BindingCon text[dataset1, "table1"]

I get the error: System.Argument Exception was unhandled. Message="Child
list for field table1 cannot be created."

L. A. Jones

Sep 4 '06 #2
BindingManagerB ase bmProduct
bmProduct = this.BindingCon text[dsfrmRestock_Pr oductSelect1, "Product"];
this.cmbProduct .DataSource = this.dsfrmResto ck_ProductSelec t1;
this.cmbProduct .DisplayMember = "frmRestock_Pro ductsSelectComm and.Name";
this.cmbProduct .ValueMember = "frmRestock_Pro ductsSelectComm and.Barcode";
bmProduct = this.BindingCon text[dsfrmRestock_Pr oductSelect1, "Product"];
Sep 4 '06 #3

Sorry, I didn't state that the error is on last line below.

BindingManagerB ase bmProduct
bmProduct = this.BindingCon text[dsfrmRestock_Pr oductSelect1, "Product"];
this.cmbProduct .DataSource = this.dsfrmResto ck_ProductSelec t1;
this.cmbProduct .DisplayMember = "frmRestock_Pro ductsSelectComm and.Name";
this.cmbProduct .ValueMember = "frmRestock_Pro ductsSelectComm and.Barcode";
bmProduct = this.BindingCon text[dsfrmRestock_Pr oductSelect1, "Product"];
Sep 4 '06 #4
Dave,

That's the problem. You are setting the data source to
"this.dsfrmRest ock_ProductSele ct1", and then getting the BindingContext for
the "Product" member in "this.dsfrmRest ock_ProductSele ct1". Your call
really needs to be:

bmProduct = this.BindingCon text[dsfrmRestock_Pr oductSelect1];

That will give you the appropriate binding context.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Dave" <Da**@discussio ns.microsoft.co mwrote in message
news:82******** *************** ***********@mic rosoft.com...
>
Sorry, I didn't state that the error is on last line below.

BindingManagerB ase bmProduct
bmProduct = this.BindingCon text[dsfrmRestock_Pr oductSelect1, "Product"];
this.cmbProduct .DataSource = this.dsfrmResto ck_ProductSelec t1;
this.cmbProduct .DisplayMember = "frmRestock_Pro ductsSelectComm and.Name";
this.cmbProduct .ValueMember = "frmRestock_Pro ductsSelectComm and.Barcode";
bmProduct = this.BindingCon text[dsfrmRestock_Pr oductSelect1, "Product"];

Sep 5 '06 #5

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

Similar topics

11
10761
by: jrefactors | last post by:
I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures execute in the database server with better performance? Please advise good references for Oracle stored procedures also. thanks!!
2
2827
by: scott | last post by:
Hi, Just wondering what sort of problems and advantages people have found using stored procedures. I have an app developed in VB6 & VB.NET and our developers are starting to re-write some of the code in stored procedures (im advocating encryption of them). When deploying an application however stored procedure seem to add another level of complexity to installation. In future we also plan to have an basic ASP app with some of the...
1
2610
by: Sampath Reddy | last post by:
Hi Everybody, We are using UDB v8.1 I will explain about my Stored procedures which we are executing in UDB AIX box. We have 3 millions(apporox) of data in 22 tables. By applying the business logic through Stored procedures on 22 tables and writing into 3 new tables. We have used all temporary tables except starting 22 tables. The Stored procedures we have used nearly 6 temporary tables to handle the business logic. Finally we are loading...
2
9249
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered problems doing this. I wanted to implemented a generic "Helper" class like this: /** * Helper
5
3488
by: Tim Marshall | last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with interest and on reading the post describing Lauren Quantrell's SmartTree, I've run into something I don't understand: Stored Procedures. I thought stored pricedures were an Oracle/MS SQL Server thing and don't know how they work with Access Jet. I've looked at some of the help on stored procedures in A2003, but really don't understand what's going on. Can someone...
28
72576
by: mooreit | last post by:
The purpose for my questions is accessing these technologies from applications. I develop both applications and databases. Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test Environments. What is the purpose of a view if I can just copy the vode from a view and put it into a stored procedure? Should I be accessing views from stored procedures?
3
1425
by: Aswanth | last post by:
Hi.., I'm having Two Stored Procedures in Two Different Databases.. Database1 - Employee Stored Procedure - Employee_Details Database2 - Company Stored Procedure - Company_Details
11
3448
by: peter | last post by:
I am trying to get a SQL stored procedure to use user maintained MQT implicitly which raises questions on when they are used or not used. In theory you would expect the stored procedure to pick up the MQT at the time it is bound on the creation of the static SQL. This raises the question on how you stop it or start it using a MQT as there is no option on the bind. What happens when it is rebound? What happens if the plan is made invalid...
0
3450
by: zman77 | last post by:
Hi. My solution (working in VS 2008) has a C# console app, and a C# web service. The service has an entity data model. It has numerous stored procedures. For one of the stored procs, which just returns data (SELECT blah blah FROM...), I added a function import called "Iservice." I saved all, then in my console app, updated the service reference to my C# service. Now, in my console app, I am trying to do the following: This doesn't work....
0
10639
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
10376
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
10383
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10120
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9200
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7661
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
6881
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
5688
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4332
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

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.