Seems a common problem . . . tblInvTrans (child) tblPurchaseOrders(parent) FK Insert & Delete set to cascade. I current throw a foreign key constraint error as follows: _________________________________________ System.Data.SqlClient.SqlException was caught Class=16 ErrorCod...more >>

Here is a simple question: There is a list of objects in a collection that need to be displayed in a ComboBox. The text that should be displayed is NOT the ToString(), but the property LongDisplayName. What is the best way to display this collection? Should I be using a BindingSource or s...more >>

I have bound via Datasource tree comboboxes to the same Datatable. Valuemember and Displaymember are set to the same fieldname. The selectedvalue i've planed to set individually. While runing, every change in an combobox changes all three comboboxes. Why the three Comboboxes change selecte...more >>

Hi, I recently replaced a datatable with a lighter weight generic List<myClass> object. I created a BindingSource, made the List the DataSource for the BindingSource, and the set the BindingSource as the datasource for a DataGridView. I managed to implement filtering and sorting for single ...more >>

Hi i'm using .NET2, I've got 2 screens : - A List : Grid binded to an object array, an Edit button opening the detail Screen. - A Detail : Modal Form with textboxes to edit one object of the previous list. The problem is that, because the datasource object is the same on the both S...more >>

I have created a Component called a BOConnector that implements IBindingList so it can provide access to a list of business objects to be bound to controls. At design time there is no live list of objects so BOConnector creates an internal list of one object. It needs one object because when ...more >>

I thought I'd try some drag and drop database work, so I created a datasource for a simple SQL 2005 Express DB and dragged one of the tables from the datasource onto a form, where it created a grid and nav bar, along with the necessary binding controls. The data won't save to the database. I ...more >>

Hello I have a form that is a bunch of combos/texboxes etc and is used strictly for data entry, the customer would like to have the ability after saving the record to have the data stay on the screen, because most of the time the data is nearly identical - strange I know believe me :) Anyway ...more >>

Hello, After some extensive tests, I believe I know why nullable types won't bind correctly. It comes down to the way the Parse event needs to return the value in the cevent.Value object. For example, if I have a class I want to bind to: public class Class1 { private int? m_nulla...more >>

I am using a BindingNavigator inside a Form that has some ForeignKey related combo boxes. I am trying to limit the options available in my comboBox based on the value of on of the fields in the underlying datasource row. For example, my datasource has a field StateID and CityID. StateID...more >>

Ok, I am doing this in DotNet 2.0 and am trying to workout the workflow and process of this. I have a form with a section for me data header, 4 fields. I have a subsection that is a relationship, 8 fields and a many-one relationship. I have a second subsection that has 4 fields and a many-o...more >>

Hi, In .Net 2.0 the new DataGridView control has a property to "AllowUserToAddRows" which can be set to true or false. The doc says that this controls whether the user sees the "new row" (MS Access terminology) at the bottom of the Grid control. But... there are two other places in a Da...more >>

Hi! First of all, i know that this topic is discussed very often in this newsgroup, but i can't find an answer to my question. I try to describe my problem as good as possible (I'm using C#): I have a DataBase-Class with DataSets and DataViews. 2 other classes (i call them class A and cla...more >>

Can anyone tell me why the following snippet of code throws an exception on the forth iteration of the loop? If we comment out the last line of code everything is okay. DataSet dataSet = new DataSet(); DataTable dataTable = dataSet.Tables.Add(); DataColum...more >>

Hello, please bear with me on a question that seems to be asked all over (but for me, not adequately answered!). I have been trying to figure out what I'm missing for days now and haven't found a good explanation. The IDE is VS .NET 2k5. Suppose I have a DataGridView alone on a form. My goa...more >>

I have a datagridview populated with data and one edit column is a combobox. This column is also populated correctly. I can edit and delete the items in the datagridview and they save properly using the Update function on the table adaptor. The new rows are not inserting and saving when the...more >>

hi, i have two tables, related by a one to many relationship. i want a form with both tables showing, and when i click on a record in the 'one' datagridview, i want the 'many' view to show only the related records. i've been searching around and have created a relation between the two table ...more >>

Hello All, this question replies to the Compact Framework 2.0 . I am using a Webform with Databinding a DataSet. I use the DataSet.HasChanges and RowState to find out if changes took place or not before closing a form. The problem I run into is that if I bind a checkbox the DataSet alw...more >>

A) Destination Table with 4 Fields. 1) Last Name 2) First Name 3) State 4) Zip Code. B) Look up table State/Zip Code with 2 Fields 1) State 2) Zip Code. I created a DetailView Form in Asp.net to Insert/Update Destination Table. Destination Table's State and Zip Code Fields are...more >>

I'm using a windows form in Vb.net 2.0. I have a datagridview that is populated with data. It is for viewing only, i have turned of allowing edits, adding, deleteing and column reorg. when i click on the datagridview and go to edit columns and select a column and look at the SortMode, it's s...more >>